Reference > Database > WebSphere Commerce database tables > C
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 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 SQL100520030315150 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 _vcc_freeselect_bottom_