Database Table: TCPITMAP

This table stores all the items from the shopping cart that are applicable to the current coupon for the Coupon Decision Support system.

Column Name Column Type Column Description
CPWALLET_ID BIGINT
NOT NULL
Primary Key. Foreign key to 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 ORDERITEMS table.
Indexes:
Index Name Indexed Column Names Index Type
I0000281 ORDERITEMS_ID Non-Unique Index
SQL030416035127950 CPWALLET_ID, ORDERITEMS_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_827 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade
F_828 CPWALLET_ID CPWALLET CPWALLET_ID Cascade

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