WebSphere Commerce database table: CLCDPROMO

This table stores information about the relationship between the Calculation Framework and the promotion standalone infrastructure. Each calculation code matches one promotion in the PX_PROMOTION table.

Column Descriptions

Column Name	Column Type	Description
PX_PROMOTION_ID	INTEGER NOT NULL	Foreign key to the PX_PROMOTION table. This is the promotion specific object.
CALCODE_ID	INTEGER NOT NULL	Foreign key to reference the CALCODE table. This identifies the associated calculation framework object.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
SQL060903235141540	PX_PROMOTION_ID+CALCODE_ID	Primary Key
I0000410	PX_PROMOTION_ID	Non-Unique Index
I0000411	CALCODE_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1059	CALCODE_ID	CALCODE	CALCODE_ID	Cascade
F_1058	PX_PROMOTION_ID	PX_PROMOTION	PX_PROMOTION_ID	Cascade