Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PX_CDUSAGE
This table contains all the promotion code usage information.
Column Name Column Type Description PX_CDUSAGE_ID BIGINT NOT NULL Primary key. PX_CDPOOL_ID BIGINT NOT NULL Foreign key to PX_CDPOOL. OWNER_ID BIGINT Foreign key to USERS. ORDERS_ID BIGINT Foreign key to ORDERS. STATUS SMALLINT 0: Unassigned
1: Assigned
2: Claimed
3: Rejected
4: Applied in an order
5: Redeemed in an order
6: Marked for deletionVALIDFROM TIMESTAMP Currently not in use. VALIDUNTIL TIMESTAMP Currently not in use. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030706690 PX_CDUSAGE_ID Primary Key I0001317 PX_CDPOOL_ID Non-Unique Index I0001318 OWNER_ID Non-Unique Index I0001319 ORDERS_ID Non-Unique Index I0001320 STATUS Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3610 ORDERS_ID ORDERS ORDERS_ID Cascade F_3608 PX_CDPOOL_ID PX_CDPOOL PX_CDPOOL_ID Cascade F_3609 OWNER_ID USERS USERS_ID Cascade _vcc_freeselect_bottom_