Database Table: TORCPMAP

This table stores information about the coupons that are applicable on the current shopping cart while the decision support system is running.

Column Name Column Type Column Description
CPWALLET_ID BIGINT
NOT NULL
Primary Key. Coupon ID. Foreign key to CPWALLET table.
ORDERS_ID BIGINT
NOT NULL
Primary Key. Foreign key to ORDERS table.
Indexes:
Index Name Indexed Column Names Index Type
I0000286 CPWALLET_ID Non-Unique Index
SQL030416035135600 ORDERS_ID, CPWALLET_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_862 CPWALLET_ID CPWALLET CPWALLET_ID Cascade
F_863 ORDERS_ID ORDERS ORDERS_ID Cascade

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