WebSphere Commerce database table: PX_PROMOPOLICY

Reserved for IBM internal use.

Column Descriptions
Column Name Column Type Description
PX_PROMOTION_ID INTEGER NOT NULL Reserved for IBM internal use.
PX_POLICY_ID INTEGER NOT NULL No PX_POLICY_ID external description assigned yet
RELATION SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
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