Database Table: CPPMNDISC

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

Column Name Column Type Column Description
CALCODE_ID INTEGER
NOT NULL
Foreign key to the CALCCODE table to represent discount condition for the promotion.
CPPMNDISC_ID INTEGER
NOT NULL
Coupon discount ID. The primary key.
CPPMN_ID INTEGER
NOT NULL
Foreign key to the CPPMN table.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034916860 CPPMNDISC_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_271 CPPMN_ID CPPMN CPPMN_ID Cascade
F_272 CALCODE_ID CALCODE CALCODE_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable