Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PX_PROMOPOLICY
This is table is intended for customization, which contains the relationship between a promotion policy with a promotion. This table is not used with default implementation.
Column Name Column Type Description PX_PROMOTION_ID INTEGER NOT NULL Foreign key to PX_PROMOTION table. PX_POLICY_ID INTEGER NOT NULL Foreign key to PX_PPOLICY table. RELATION SMALLINT NOT NULL DEFAULT 0 The type of relationships between promotions and policies. Possible values include:
0: applicable
1: exempted
The default value is 0.OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000402 PX_PROMOTION_ID Non-Unique Index I0000403 PX_POLICY_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1050 PX_POLICY_ID PX_POLICY PX_POLICY_ID Cascade F_1049 PX_PROMOTION_ID PX_PROMOTION PX_PROMOTION_ID Cascade _vcc_freeselect_bottom_