Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CPOFFER
This table contains the promotions that are available to be shown to customers in their offer list. 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 a primary key. USERS_ID BIGINT NOT NULL Foreign key to USERS table. This is the ID of the customer. This is a primary key. STATE CHAR(4) NOT NULL The state of the offer: OFFERED, REJECTED, EXPIRED, or ACCEPTED. FIRSTTIMESEEN TIMESTAMP Time at which the customer first saw the offer. FIELD1 VARCHAR(64) Customizable. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030320550 CPPMN_ID+USERS_ID Primary Key I0000545 USERS_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_264 CPPMN_ID CPPMN CPPMN_ID Cascade F_263 USERS_ID USERS USERS_ID Cascade
Related reference
_vcc_freeselect_bottom_