WebSphere Commerce database table: OPERATOR

WebSphere Commerce database table: OPERATOR

This table is used to define operators.
Column Descriptions
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
SQL060903235217150 OPERATOR_ID Primary Key

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

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.

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