WebSphere Commerce database table: PX_GROUP

Contains the promotion groups for the site.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000386 STOREENT_ID+GRPNAME Unique Index
SQL050212031301020 PX_GROUP_ID Primary Key
I0000394 STOREENT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1042 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)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

Feedback