WebSphere Commerce database table: OPERATOR

This table is used to define operators.


Column Description(s):
Column NameColumn TypeDescription
OPERATOR_ID INTEGER NOT NULL Unique table index. This is the primary key.
OPERATOR CHAR(32) NOT NULL The operator. For example, "<" or ">=".
OPERATORTYPE CHAR(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)
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031242420 OPERATOR_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_72 OPERATOR_ID ATTRVALUE OPERATOR_ID Cascade
F_482 OPERATOR_ID OPERATRDSC OPERATOR_ID Cascade
F_570 OPERATOR_ID PATTRVALUE OPERATOR_ID Cascade

Feedback