Reference > Database > WebSphere Commerce database tables > C
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. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.
Column Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type SQL100520030320880 CPPMN_ID+SHOPPEREMAILID Primary Key I0000277 SHOPPEREMAILID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_975 CPPMN_ID CPPMN CPPMN_ID Cascade
Related reference
_vcc_freeselect_bottom_