WebSphere Commerce database table: CPPMNDISC

This table contains the discount conditions for a promotion. Every coupon has exactly one calculation code.


Column Description(s):
Column NameColumn TypeDescription
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(es):
Index NameIndexed Column NamesIndex Type
SQL050212031218100 CPPMNDISC_ID Primary Key
I0000548 CALCODE_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_272 CALCODE_ID CALCODE CALCODE_ID Cascade
F_271 CPPMN_ID CPPMN CPPMN_ID Cascade

Feedback