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 Descriptions
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
SQL060903235146940 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