WebSphere Commerce database table: CONTRLRULE

Reference > Database > WebSphere Commerce database tables > C

WebSphere Commerce database table: CONTRLRULE

This table contains information about bid control rules used in auctions.

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...

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.

Indexes
Index Name Indexed Column Names Index Type
I0000080 RULENAME+OWNER_ID Unique Index
SQL100520030319320 RULE_ID Primary Key
I0000081 RULETYPE Non-Unique Index
I0000540 ADMIN_ID Non-Unique Index
I0000541 OWNER_ID Non-Unique Index
I0001250 CLASS_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names 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 Names Constraint Type
F_81 BIDRULE_ID AUCTION RULE_ID Cascade
F_94 RULE_ID AUCTSTYLE RULE_ID Cascade

Related reference

Auction bid rules data model

_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

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... 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 Name	Indexed Column Names	Index Type
I0000080	RULENAME+OWNER_ID	Unique Index
SQL100520030319320	RULE_ID	Primary Key
I0000081	RULETYPE	Non-Unique Index
I0000540	ADMIN_ID	Non-Unique Index
I0000541	OWNER_ID	Non-Unique Index
I0001250	CLASS_ID	Non-Unique Index

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	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

Constraint Name	Referenced Column Name	Foreign Table Name	Foreign Column Names	Constraint Type
F_81	BIDRULE_ID	AUCTION	RULE_ID	Cascade
F_94	RULE_ID	AUCTSTYLE	RULE_ID	Cascade