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 | Description |
---|---|---|---|
| varchar(40) | not null | 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 | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the user. References |
| int | not null | 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 | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the user. |
| varchar(40) | not null | The unique identifier associated with the promotion. |