Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CPPMNDISC
This table contains the discount conditions for a promotion. Every coupon has exactly one calculation code. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.
Column Name Column Type Description CPPMNDISC_ID INTEGER NOT NULL Coupon discount ID. The primary key. CPPMN_ID INTEGER NOT NULL Foreign key to the CPPMN table. CALCODE_ID INTEGER NOT NULL Foreign key to the CALCCODE table to represent discount condition for the promotion. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030321330 CPPMNDISC_ID Primary Key I0000548 CALCODE_ID Non-Unique Index I0001252 CPPMN_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_272 CALCODE_ID CALCODE CALCODE_ID Cascade F_271 CPPMN_ID CPPMN CPPMN_ID Cascade
Related reference
_vcc_freeselect_bottom_