Database Table: CPITMAP

This table stores all the items from the given (completed) order that were applicable to the selected coupon set.

Column Name Column Type Column Description
CPWALLET_ID BIGINT
NOT NULL
Primary key. Foreign key to the CPWALLET table.
DISCAMT DECIMAL (20,5)
NOT NULL
The discount amount for this item when this coupon is used.
ORDERITEMS_ID BIGINT
NOT NULL
Primary key. Foreign key to the ORDERITEMS table.
Indexes:
Index Name Indexed Column Names Index Type
I0000280 ORDERITEMS_ID Non-Unique Index
SQL030416034914650 CPWALLET_ID, ORDERITEMS_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_261 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade
F_262 CPWALLET_ID CPWALLET CPWALLET_ID Cascade

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