This table contains information about bid control rules used in auctions.
Column Description(s):
Column Name | Column Type | Description |
RULE_ID |
BIGINT NOT NULL |
The bid control rule ID. The primary key to the table. |
OWNER_ID |
BIGINT NOT NULL |
ID of the owner of 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. |
ADMIN_ID |
BIGINT |
The ID of the administrator who created the bid control rule. |
RULETYPE |
CHAR(4) NOT NULL |
Auction type for this rule. Valid values are as follows:
- O=open cry
- SB=sealed bid
- D=dutch
|
RULENAME |
CHAR(30) NOT NULL |
Name of the bid control rule. |
RULEDESC |
VARCHAR(254) |
Description of the bid control rule. |
MINQUANT |
DOUBLE |
Minimum bid quantity allowed for this auction. Bids with a quantity less than the minimum are not accepted. |
MINVALUE |
DECIMAL (20,5) |
Minimum value allowed for the auction. Bids with a value less than this minimum are not accepted. |
RULETEXT |
VARCHAR(4000) |
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. |
FIELD1 |
BIGINT |
Customizable. |
FIELD2 |
DECIMAL (20,5) |
Customizable. |
FIELD3 |
VARCHAR(254) |
Customizable. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000080 |
RULENAME+OWNER_ID |
Unique Index |
SQL050212031216190 |
RULE_ID |
Primary Key |
I0000081 |
RULETYPE |
Non-Unique Index |
I0000540 |
ADMIN_ID |
Non-Unique Index |
I0000541 |
OWNER_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_255 |
OWNER_ID |
MEMBER |
MEMBER_ID |
Cascade |
F_256 |
ADMIN_ID |
MEMBER |
MEMBER_ID |
Cascade |
F_254 |
CLASS_ID |
RULECLSREG |
RULECLASS_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_81 |
BIDRULE_ID |
AUCTION |
RULE_ID |
Cascade |
F_94 |
RULE_ID |
AUCTSTYLE |
RULE_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.