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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034915220 | CPPMN_ID, USERS_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|