status_id
(primary key)

varchar(40)

not null

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.

id
(primary key)

varchar(40)

not null

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

sequence_num
(primary key)

int

not null

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.

id
(primary key)

varchar(40)

not null

The unique identifier associated with the user.

promotion_id
(primary key)

varchar(40)

not null

The unique identifier associated with the promotion.