This table contains the class information used to interpret the text in the CONTRLRULE table.
Column Description(s):
Column Name | Column Type | Description |
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 Name | Indexed Column Names | Index 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 Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_734 |
OWNER_ID |
MEMBER |
MEMBER_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_254 |
CLASS_ID |
CONTRLRULE |
RULECLASS_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.