PX_CDUSAGE

This table contains all the promotion code usage information. The recording of public promotion code usage must be enabled before this table includes usage information for public promotion codes.

Column Descriptions:

NameTypeDescription
PX_CDUSAGE_IDBIGINT NOT NULLPrimary key.
PX_CDPOOL_IDBIGINT NOT NULLForeign key to PX_CDPOOL.
OWNER_IDBIGINTForeign key to USERS.
ORDERS_IDBIGINTForeign key to ORDERS.
STATUSSMALLINT0: Unassigned 1: Assigned 2: Claimed 3: Rejected 4: Applied in an order 5: Redeemed in an order 6: Marked for deletion
VALIDFROMTIMESTAMPCurrently not in use.
VALIDUNTILTIMESTAMPCurrently not in use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PX_CDUSAGE_IDPrimary Key
I0001317PX_CDPOOL_IDNon-Unique Index
I0001318OWNER_IDNon-Unique Index
I0001319ORDERS_IDNon-Unique Index
I0001320STATUSNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3608PX_CDPOOL_IDPX_CDPOOLPX_CDPOOL_IDCascade
F_3609OWNER_IDUSERSUSERS_IDCascade
F_3610ORDERS_IDORDERSORDERS_IDCascade