WebSphere Commerce database table: PX_PROMOTION

This table contains promotions.

Column Descriptions
Column Name Column Type Description
PX_PROMOTION_ID INTEGER NOT NULL The promotion ID. This is a primary key.
PRIORITY INTEGER NOT NULL The priority of the promotion.
STATUS INTEGER NOT NULL The current status of a promotion. Possible values include:
0: inactive
1: active
2: marked for deletion
3: suspended
4: obsolete
EXCLSVE INTEGER NOT NULL The exclusivity of a promotion. Possible values include:
0: This promotion may be combined with any other promotions
1: This promotion can not be combined with any other promotions in the same promotion group
2: This promotion can not be combined with any other promotions
TYPE INTEGER NOT NULL Contains the type of the promotion. Possible values include:
0: This promotion is applicable to people who belong to one or more of the targeted customer profiles. When the targeted profile file list is empty, it applies to everyone
1: This promotion is applicable only to those to whom it has been explicitly granted, that is, this promotion is a coupon promotion
PERORDLMT INTEGER NOT NULL DEFAULT -1 The number of times this promotion can be applied to a single order. A value of -1, which is the default, imposes no limit.
PERSHOPPERLMT INTEGER NOT NULL DEFAULT -1 The number of times a customer can redeem this promotion. A value of -1, which is the default, imposes no limit.
TOTALLMT INTEGER NOT NULL DEFAULT -1 The overall limit on the number of times this promotion can be redeemed. A value of -1, which is the default, imposes no limit.
RSV_INT INTEGER Reserved for IBM internal use.
PX_GROUP_ID INTEGER NOT NULL Foreign key to the PX_GROUP table. This identifies the promotion group to which this promotion belongs.
CAMPAIGN_ID INTEGER Foreign key to CAMPAIGN table. This identifies the campaign with which this promotion is associated.
STOREENT_ID INTEGER NOT NULL Foreign key to the STOREENT table. This identifies the store to which this promotion belongs.
VERSION INTEGER NOT NULL The version number of this promotion.
REVISION INTEGER NOT NULL The revision number of this promotion.
EFFECTIVE INTEGER If this promotion is a private promotion, this column defines how many days after the coupon is issued the coupon becomes active.
TRANSFER INTEGER DEFAULT 0 If this promotion is a private promotion, the value in this column deterimines whether the coupons generated for this promotion are transferrable or not. A value of 0, which is the default, does not allow the coupon to be transferred among customers.
CDREQUIRED INTEGER NOT NULL DEFAULT 0 A flag that determines whether a promotion code is required to redeem this promotion. A value of 0, which is the default, means that a code is not required.
EXPIRE INTEGER If this promotion is a private promotion, this column defines how many days, after the coupon becomes active, it expires.
LASTUPDATEBY BIGINT The ID of the user that last modified the promotion.
LASTUPDATE TIMESTAMP The timestamp of the most recent update to this promotion.
STARTDATE TIMESTAMP NOT NULL The overall starting date for this promotion.
ENDDATE TIMESTAMP NOT NULL The overall end date for this promotion.
RSV_TIME TIMESTAMP Reserved for IBM internal use.
RSV_REAL DECIMAL (20,5) Reserved for IBM internal use.
TGTSALES DECIMAL (20,5) The target sales figure for this promotion.
NAME VARCHAR(128) NOT NULL The name of the promotion.
CODE VARCHAR(128) The promotion code for this promotion.
RSV_VCH VARCHAR(254) Reserved for IBM internal use.
XMLPARAM CLOB The XML definition of this promotion.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000388 STOREENT_ID+NAME+VERSION+STATUS+REVISION Unique Index
SQL060903235239370 PX_PROMOTION_ID Primary Key
I0000398 PX_GROUP_ID Non-Unique Index
I0000399 CAMPAIGN_ID Non-Unique Index
I0000400 STOREENT_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1047 CAMPAIGN_ID CAMPAIGN CAMPAIGN_ID Cascade
F_1046 PX_GROUP_ID PX_GROUP PX_GROUP_ID Cascade
F_1048 STOREENT_ID STOREENT STOREENT_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1058 PX_PROMOTION_ID CLCDPROMO PX_PROMOTION_ID Cascade
F_1049 PX_PROMOTION_ID PX_PROMOPOLICY PX_PROMOTION_ID Cascade
F_1079 PX_PROMO_ID_TO PX_PROMPROM PX_PROMOTION_ID Cascade
F_1078 PX_PROMO_ID_FROM PX_PROMPROM PX_PROMOTION_ID Cascade