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 Descriptions
| 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 |
| SQL060903235146100
| 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