Reference > Database > WebSphere Commerce database tables > R

WebSphere Commerce database table: RULECLSREG

This table contains the class information used to interpret the text in the CONTRLRULE table.

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

Indexes

Index Name	Indexed Column Names	Index Type
I0000223	RULETYPE+OWNER_ID	Unique Index
I0000224	NAME+OWNER_ID	Unique Index
SQL100520030426430	RULECLASS_ID	Primary Key
I0000756	OWNER_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_734	OWNER_ID	MEMBER	MEMBER_ID	Cascade

Referenced By

Constraint Name	Referenced Column Name	Foreign Table Name	Foreign Column Names	Constraint Type
F_254	CLASS_ID	CONTRLRULE	RULECLASS_ID	Cascade

Related reference

• Auction bid rules data model

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search