Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PX_GROUP
Contains the promotion group information.
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 The XML definition of this group. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000386 STOREENT_ID+GRPNAME Unique Index SQL100520030417180 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
Referenced By 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 _vcc_freeselect_bottom_