WebSphere Commerce database table: PX_GRPPOLICY

This table contains relationships between promotion groups and promotion policies.

Column Descriptions

Column Name	Column Type	Description
PX_GROUP_ID	INTEGER NOT NULL	Foreign key to PX_GROUP table.
PX_POLICY_ID	INTEGER NOT NULL	Foreign key to PX_POLICY table.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
SQL060903235238910	PX_GROUP_ID+PX_POLICY_ID	Primary Key
I0000396	PX_GROUP_ID	Non-Unique Index
I0000397	PX_POLICY_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1044	PX_GROUP_ID	PX_GROUP	PX_GROUP_ID	Cascade
F_1045	PX_POLICY_ID	PX_POLICY	PX_POLICY_ID	Cascade