Database Table: RULECLSREG

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

Column Name Column Type Column Description
CLASSNAME VARCHAR (254)
NULL
The class used to interpret the rule text in the CONTRLRULE table.
NAME VARCHAR (128)
NULL
Descriptive name of the rule.
OWNER_ID BIGINT
NULL
Owner of the rule. Foreign Key to the MEMBER table.
RULECLASS_ID BIGINT
NOT NULL
Rule class ID. The primary key to the table.
RULETYPE CHARACTER (4)
NOT NULL
Rule type. Same as auction type. Valid values: O=Open Cry, SB=Sealed Bid, D=Dutch.
Indexes:
Index Name Indexed Column Names Index Type
I0000223 RULETYPE, OWNER_ID Unique Index
I0000224 NAME, OWNER_ID Unique Index
SQL030416035059640 RULECLASS_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_734 OWNER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_254 RULECLASS_ID CONTRLRULE CLASS_ID Cascade