WebSphere Commerce database table: PX

Reference > Database > WebSphere Commerce database tables > P

WebSphere Commerce database table: PX_CDPROMO

This table contains all the promotion code information for relationships with a promotion.

Column Name Column Type Description
PX_CDPROMO_ID BIGINT NOT NULL Primary key.
PX_CDPOOL_ID BIGINT NOT NULL Foreign key to PX_CDPOOL.
PX_PROMOTION_ID INTEGER NOT NULL Foreign key to PX_PROMOTION.
STATUS SMALLINT NOT NULL DEFAULT 0 0: Inactive
1: Active
LASTUPDATE TIMESTAMP Currently not in use.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0001315 PX_CDPOOL_ID+PX_PROMOTION_ID Unique Index
SQL100520030706380 PX_CDPROMO_ID Primary Key
I0001316 PX_PROMOTION_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_3607 PX_CDPOOL_ID PX_CDPOOL PX_CDPOOL_ID Cascade
F_3606 PX_PROMOTION_ID PX_PROMOTION PX_PROMOTION_ID Cascade
_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

Column Name	Column Type	Description
PX_CDPROMO_ID	BIGINT NOT NULL	Primary key.
PX_CDPOOL_ID	BIGINT NOT NULL	Foreign key to PX_CDPOOL.
PX_PROMOTION_ID	INTEGER NOT NULL	Foreign key to PX_PROMOTION.
STATUS	SMALLINT NOT NULL DEFAULT 0	0: Inactive 1: Active
LASTUPDATE	TIMESTAMP	Currently not in use.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	Reserved for IBM internal use.

Index Name	Indexed Column Names	Index Type
I0001315	PX_CDPOOL_ID+PX_PROMOTION_ID	Unique Index
SQL100520030706380	PX_CDPROMO_ID	Primary Key
I0001316	PX_PROMOTION_ID	Non-Unique Index

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_3607	PX_CDPOOL_ID	PX_CDPOOL	PX_CDPOOL_ID	Cascade
F_3606	PX_PROMOTION_ID	PX_PROMOTION	PX_PROMOTION_ID	Cascade