This table stores information about the electronic coupons that
were used with the given (completed) Order.
Column Name |
Column Type |
Column Description |
CPWALLET_ID |
BIGINT
NOT NULL |
Primary key. Foreign key to the CPWALLET table. |
ORDERS_ID |
BIGINT
NOT NULL |
Primary key. Foreign key to the ORDERS table. |
Indexes:
Index Name |
Indexed Column Names |
Index Type |
I0000285 |
CPWALLET_ID |
Non-Unique Index |
SQL030416035014800 |
ORDERS_ID, CPWALLET_ID |
Primary Key |
Constraints:
Constraint Name |
Column Names |
Foreign Table Name |
Foreign Column Names |
Constraint Type |
F_484 |
CPWALLET_ID |
CPWALLET |
CPWALLET_ID |
Cascade |
F_485 |
ORDERS_ID |
ORDERS |
ORDERS_ID |
Cascade |
Referenced By:
Constraint Name |
Referenced Column Name |
Foreign Table Name |
Foreign Column Names |
Constraint Type |
Not Applicable |
