Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce database table: OPERATOR
This table is used to define operators.
Column Name Column Type Description 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:
- Simple operator (allows a single value) - Default
- Compound operator (range - continuous)
- Compound operator (set)
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030358760 OPERATOR_ID Primary Key
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names 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 _vcc_freeselect_bottom_