OPERATOR

This table is used to define operators.

Column Descriptions:

NameTypeDescription
OPERATOR_IDINTEGER NOT NULLUnique table index. This is the primary key.
OPERATORCHAR (32) NOT NULLThe operator. For example, "<" or ">=".
OPERATORTYPECHAR (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)
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>OPERATOR_IDPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_482OPERATOR_IDOPERATRDSCOPERATOR_IDCascade
F_570OPERATOR_IDPATTRVALUEOPERATOR_IDCascade
F_72OPERATOR_IDATTRVALUEOPERATOR_IDCascade