Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CPEMAILMAP
This table stores the mapping between the coupon ID and the e-mail IDs of guest customers to whom specific coupon IDs were sent. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.
Column Name Column Type Description CPWALLET_ID BIGINT NOT NULL Foreign key to the CPWALLET table. This identifies the wallet. SHOPPEREMAILID CHAR(64) NOT NULL Primary key. The e-mail ID of the customer. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030319790 CPWALLET_ID Primary Key I0000276 SHOPPEREMAILID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_974 CPWALLET_ID CPWALLET CPWALLET_ID Cascade
Related reference
_vcc_freeselect_bottom_