Database Table: CPEMAILMAP

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