Contains the promotion groups for the site.
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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000386 | STOREENT_ID+GRPNAME | Unique Index |
SQL050212031301020 | PX_GROUP_ID | Primary Key |
I0000394 | STOREENT_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_1042 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign 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 |