This table stores the number of times coupons have been accepted from the coupon promotion by the guest customer identified by the e-mail ID. It also stores the number of times the customer has redeemed coupons from this promotion.
Column Name | Column Type | Column Description |
---|---|---|
CPPMN_ID | INTEGER NOT NULL |
Promotion ID. Primary key. Foreign key to the CPPMN table. |
NUMACCEPTED | INTEGER NOT NULL, DEFAULT 0 |
Reserved for IBM internal use. |
NUMREDEEMED | INTEGER NOT NULL, DEFAULT 0 |
Number of times the customer has redeemed coupons of this promotion. |
SHOPPEREMAILID | CHARACTER (64) NOT NULL |
Primary key. The e-mail ID of the customer. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000277 | SHOPPEREMAILID | Non-Unique Index |
SQL030416034915910 | CPPMN_ID, SHOPPEREMAILID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_975 | CPPMN_ID | CPPMN | CPPMN_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|