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 |
