Database Table: CPOFFER

This table contains the promotions that are available to be shown to customers in their offer list.

Column Name Column Type Column Description
CPPMN_ID INTEGER
NOT NULL
Primary Key. Foreign key to CPPMN table.
FIELD1 VARCHAR (64)
NULL
Customizable.
FIRSTTIMESEEN TIMESTAMP
NULL
Time at which the customer first saw the offer.
STATE CHARACTER (4)
NOT NULL
The state of the offer: OFFERED, REJECTED, EXPIRED, or ACCEPTED.
USERS_ID BIGINT
NOT NULL
Primary Key Users ID. Foreign key to USERS table.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034915220 CPPMN_ID, USERS_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_263 USERS_ID USERS USERS_ID Cascade
F_264 CPPMN_ID CPPMN CPPMN_ID Cascade

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