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

status_id

VARCHAR(40)

NOT NULL

(primary key)

The unique identifier associated with the promotion status.

profile_id

VARCHAR(40)

NOT NULL

The unique identifier associated with the user who owns this promotion status.

promotion

VARCHAR(40)

NOT NULL

The unique identifier associated with the promotion. References dcs_promotion(promotion_id)

num_uses

INT

none

The number of uses the promotion has remaining.

expirationDate

DATE

none

The date the promotion expires.

grantedDate

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

id

VARCHAR(40)

NOT NULL

(primary key)

The unique identifier associated with the user. References dps_user(id)

sequence_num

INT

NOT NULL

(primary key)

Used to order rows in the table.

promo_status_id

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

id

VARCHAR(40)

NOT NULL

(primary key)

The unique identifier associated with the user.

promotion_id

VARCHAR(40)

NOT NULL

(primary key)

The unique identifier associated with the promotion.


Copyright © 1997, 2012 Oracle and/or its affiliates. All rights reserved.

Legal Notices