WebSphere Commerce database table: CPPMNACC

This table stores the number of times a coupon has 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 Description(s):
Column NameColumn TypeDescription
CPPMN_ID INTEGER NOT NULL Foreign key to the CPPMN table. This is the promotion ID. This is a primary table.
SHOPPEREMAILID CHAR(64) NOT NULL Primary key. The e-mail ID of the customer.
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.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031217680 CPPMN_ID+SHOPPEREMAILID Primary Key
I0000277 SHOPPEREMAILID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_975 CPPMN_ID CPPMN CPPMN_ID Cascade

Feedback