Database Table: CPPMNPROD

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000282 CATENTRY_ID Non-Unique Index
SQL030416034917470 CPPMN_ID, CATENTRY_ID Primary Key
Constraints:
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

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