Oracle ATG Web Commerce uses the following tables to store information about user promotions:
dcs_usr_promostat
This table contains information about the status of promotions owned by specific users and the number of remaining uses of those promotions.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the promotion status. | |
| VARCHAR(40) | NOT NULL |
The unique identifier associated with the user who owns this promotion status. | ||
| VARCHAR(40) | NOT NULL |
The unique identifier associated with the promotion. References | ||
| INT | none |
The number of uses the promotion has remaining. | ||
| DATE | none |
The date the promotion expires. | ||
| DATE | none |
The date the promotion was granted. |
dcs_usr_actvpromo
This table contains information about a user’s active promotions.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the user. References | |
| INT | NOT NULL |
(primary key) | Used to order rows in the table. | |
| VARCHAR(40) | NOT NULL |
The ID of the promo status Object (a promotion and its number of uses) associated with the active promotion. |
dcs_usr_usedpromo
This table contains information about promotions that have been used.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the user. | |
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the promotion. |