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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000223 | RULETYPE, OWNER_ID | Unique Index |
I0000224 | NAME, OWNER_ID | Unique Index |
SQL030416035059640 | RULECLASS_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_734 | OWNER_ID | MEMBER | MEMBER_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_254 | RULECLASS_ID | CONTRLRULE | CLASS_ID | Cascade |