PX_GROUP

Contains the promotion group information.

Column Descriptions:

NameTypeDescription
PX_GROUP_IDINTEGER NOT NULLThe promotion group ID. This is a primary key.
STOREENT_IDINTEGER NOT NULLForeign key to the STOREENT table. This is the store to which this promotion group belongs.
STATUSSMALLINT NOT NULL DEFAULT 1The current status of the group. Possible values include: 0: active 1: inactive 2: deleted The default value is 1.
GRPNAMEVARCHAR (128) NOT NULLThe name of the promotion group.
XMLPARAMCLOB (1000000)The XML definition of this group.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PX_GROUP_IDPrimary Key
I0000386STOREENT_ID+GRPNAMEUnique Index
I0000394STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1042STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1044PX_GROUP_IDPX_GRPPOLICYPX_GROUP_IDCascade
F_1046PX_GROUP_IDPX_PROMOTIONPX_GROUP_IDCascade
F_1083PX_GROUP_IDPX_TPLTGRPPX_GROUP_IDCascade