Database Table: CONTRLRULE

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000080 RULENAME, OWNER_ID Unique Index
I0000081 RULETYPE Non-Unique Index
SQL030416034912360 RULE_ID Primary Key
Constraints:
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

Referenced By:
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