WebSphere Commerce database table: PX_GROUP

Contains the promotion groups for the site.

Column Descriptions

Column Name	Column Type	Description
PX_GROUP_ID	INTEGER NOT NULL	The promotion group ID. This is a primary key.
STOREENT_ID	INTEGER NOT NULL	Foreign key to the STOREENT table. This is the store to which this promotion group belongs.
STATUS	SMALLINT NOT NULL DEFAULT 1	The current status of the group. Possible values include: 0: active 1: inactive 2: deleted The default value is 1.
GRPNAME	VARCHAR(128) NOT NULL	The name of the promotion group.
XMLPARAM	CLOB	No XMLPARAM external description assigned yet
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
I0000386	STOREENT_ID+GRPNAME	Unique Index
SQL060903235238750	PX_GROUP_ID	Primary Key
I0000394	STOREENT_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1042	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Constraint Name	Referenced Column Name	Foreign Table Name	Foreign Column Names	Constraint Type
F_1044	PX_GROUP_ID	PX_GRPPOLICY	PX_GROUP_ID	Cascade
F_1046	PX_GROUP_ID	PX_PROMOTION	PX_GROUP_ID	Cascade
F_1083	PX_GROUP_ID	PX_TPLTGRP	PX_GROUP_ID	Cascade