Database Table: CPPMNACC

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000277 SHOPPEREMAILID Non-Unique Index
SQL030416034915910 CPPMN_ID, SHOPPEREMAILID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_975 CPPMN_ID CPPMN CPPMN_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable