This table contains the purchase conditions for a promotion. If the purchase condition type in CPPMN table was "P", then this table is used to find out all the items that are required for this Coupon to be redeemed.
Column Name | Column Type | Column Description |
---|---|---|
CATENTRY_ID | BIGINT NOT NULL |
Primary key. This is product ID. Foreign key to the CATENTRY table. |
CPPMN_ID | INTEGER NOT NULL |
Primary key. Foreign key to the CPPMN table. |
QTYMEASURE | CHARACTER (16) NOT NULL |
Specifies the quantity measure for the item. |
QUANTITY | DOUBLE NOT NULL |
This is the quantity of the item to be bought to satisfy the condition. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000282 | CATENTRY_ID | Non-Unique Index |
SQL030416034917470 | CPPMN_ID, CATENTRY_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_274 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |
F_275 | CPPMN_ID | CPPMN | CPPMN_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|