Database Table: OPERATOR

This table is used to define operators.

Column Name Column Type Column Description
OPERATOR CHARACTER (32)
NOT NULL
The operator. For example, "<" or ">=".
OPERATORTYPE CHARACTER (1)
NOT NULL, DEFAULT '1'
The operator type:
  1. Simple operator (allows a single value) - Default
  2. Compound operator (range - continuous)
  3. Compound operator (set)
OPERATOR_ID INTEGER
NOT NULL
Unique table index. This is the primary key.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035012700 OPERATOR_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_482 OPERATOR_ID OPERATRDSC OPERATOR_ID Cascade
F_570 OPERATOR_ID PATTRVALUE OPERATOR_ID Cascade
F_72 OPERATOR_ID ATTRVALUE OPERATOR_ID Cascade