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:
|
OPERATOR_ID | INTEGER NOT NULL |
Unique table index. This is the primary key. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035012700 | OPERATOR_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
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 |