This table contains information about bid control rules used in auctions.
Column Name | Column Type | Column Description |
---|---|---|
ADMIN_ID | BIGINT NULL |
The ID of the administrator who created the bid control rule. |
CLASS_ID | BIGINT NOT NULL |
The ID of the rule class to use to interpret the rule text. This is a pointer to the RULECLSREG table. |
FIELD1 | BIGINT NULL |
Customizable. |
FIELD2 | DECIMAL (20,5) NULL |
Customizable. |
FIELD3 | VARCHAR (254) NULL |
Customizable. |
MINQUANT | DOUBLE NULL |
Minimum bid quantity allowed for this auction. Bids with a quantity less than the minimum are not accepted. |
MINVALUE | DECIMAL (20,5) NULL |
Minimum value allowed for the auction. Bids with a value less than this minimum are not accepted. |
OWNER_ID | BIGINT NOT NULL |
ID of the owner of the bid control rule. |
RULEDESC | VARCHAR (254) NULL |
Description of the bid control rule. |
RULENAME | CHARACTER (30) NOT NULL |
Name of the bid control rule. |
RULETEXT | VARCHAR (4000) NULL |
Rule text. This text contains the bid ranges and increments. It is processed by the rule class interpreter, which is defined in the RULECLSREG table. |
RULETYPE | CHARACTER (4) NOT NULL |
Auction type for this rule. Valid values: O=open cry, SB=sealed bid, D=dutch. |
RULE_ID | BIGINT NOT NULL |
The bid control rule ID. The primary key to the table. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000080 | RULENAME, OWNER_ID | Unique Index |
I0000081 | RULETYPE | Non-Unique Index |
SQL030416034912360 | RULE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_254 | CLASS_ID | RULECLSREG | RULECLASS_ID | Cascade |
F_255 | OWNER_ID | MEMBER | MEMBER_ID | Cascade |
F_256 | ADMIN_ID | MEMBER | MEMBER_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_81 | RULE_ID | AUCTION | BIDRULE_ID | Cascade |
F_94 | RULE_ID | AUCTSTYLE | RULE_ID | Cascade |