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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034916860 | CPPMNDISC_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|