This table stores the mapping of the coupon ID to the e-mail IDs of
guest customers to which specific coupon IDs persisted by them were
sent.
Column Name |
Column Type |
Column Description |
CPWALLET_ID |
BIGINT
NOT NULL |
Primary key. Foreign Key to CPWALLET. |
SHOPPEREMAILID |
CHARACTER (64)
NOT NULL |
Primary key. The e-mail ID of the customer. |
Indexes:
Index Name |
Indexed Column Names |
Index Type |
I0000276 |
SHOPPEREMAILID |
Non-Unique Index |
SQL030416034913420 |
CPWALLET_ID |
Primary Key |
Constraints:
Constraint Name |
Column Names |
Foreign Table Name |
Foreign Column Names |
Constraint Type |
F_974 |
CPWALLET_ID |
CPWALLET |
CPWALLET_ID |
Cascade |
Referenced By:
Constraint Name |
Referenced Column Name |
Foreign Table Name |
Foreign Column Names |
Constraint Type |
Not Applicable |
