WebSphere Commerce database table: RULECLSREG

This table contains the class information used to interpret the text in the CONTRLRULE table.


Column Description(s):
Column NameColumn TypeDescription
RULECLASS_ID BIGINT NOT NULL Rule class ID. The primary key to the table.
RULETYPE CHAR(4) NOT NULL Rule type. Same as auction type. Valid values are as follows:
  • O=Open Cry
  • SB=Sealed Bid
  • D=Dutch
OWNER_ID BIGINT Owner of the rule. Foreign Key to the MEMBER table.
NAME VARCHAR(140) Descriptive name of the rule.
CLASSNAME VARCHAR(254) The class used to interpret the rule text in the CONTRLRULE table.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000223 RULETYPE+OWNER_ID Unique Index
I0000224 NAME+OWNER_ID Unique Index
SQL050212031309110 RULECLASS_ID Primary Key
I0000756 OWNER_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_734 OWNER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_254 CLASS_ID CONTRLRULE RULECLASS_ID Cascade

Feedback