WebSphere Commerce database table: CPPMNDISC

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 Descriptions
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
SQL060903235147790 CPPMNDISC_ID Primary Key
I0000548 CALCODE_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

E-coupon data model

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.

Index Name	Indexed Column Names	Index Type
SQL060903235147790	CPPMNDISC_ID	Primary Key
I0000548	CALCODE_ID	Non-Unique Index

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