WebSphere Commerce database table: PX

Reference > Database > WebSphere Commerce database tables > P

WebSphere Commerce database table: PX_PROMOTION

This table contains promotions.

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
5: activating
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. This field is intended for customization and not used by default.
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
SQL100520030418500 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

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1058 PX_PROMOTION_ID CLCDPROMO PX_PROMOTION_ID Cascade
F_3606 PX_PROMOTION_ID PX_CDPROMO PX_PROMOTION_ID Cascade
F_3604 PX_PROMOTION_ID PX_CDSPEC PX_PROMOTION_ID Cascade
F_3548 PX_PROMOTION_ID PX_DESCRIPTION PX_PROMOTION_ID Cascade
F_3546 PX_PROMOTION_ID PX_ELEMENT PX_PROMOTION_ID Cascade
F_3545 PX_PROMOTION_ID PX_PROMOAUDIT PX_PROMOTION_ID Cascade
F_3544 PX_PROMOTION_ID PX_PROMOAUTH PX_PROMOTION_ID Cascade
F_3538 PX_PROMOTION_ID PX_PROMOCD 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
F_3593 PX_PROMOTION_ID PX_RWDOPTION PX_PROMOTION_ID Cascade
_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

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 5: activating
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. This field is intended for customization and not used by default.
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.

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

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_3606	PX_PROMOTION_ID	PX_CDPROMO	PX_PROMOTION_ID	Cascade
F_3604	PX_PROMOTION_ID	PX_CDSPEC	PX_PROMOTION_ID	Cascade
F_3548	PX_PROMOTION_ID	PX_DESCRIPTION	PX_PROMOTION_ID	Cascade
F_3546	PX_PROMOTION_ID	PX_ELEMENT	PX_PROMOTION_ID	Cascade
F_3545	PX_PROMOTION_ID	PX_PROMOAUDIT	PX_PROMOTION_ID	Cascade
F_3544	PX_PROMOTION_ID	PX_PROMOAUTH	PX_PROMOTION_ID	Cascade
F_3538	PX_PROMOTION_ID	PX_PROMOCD	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
F_3593	PX_PROMOTION_ID	PX_RWDOPTION	PX_PROMOTION_ID	Cascade