PX_CDUSAGE

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:

Name	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 deletion
VALIDFROM	TIMESTAMP	Currently not in use.
VALIDUNTIL	TIMESTAMP	Currently not in use.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	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

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3608	PX_CDPOOL_ID	PX_CDPOOL	PX_CDPOOL_ID	Cascade
F_3609	OWNER_ID	USERS	USERS_ID	Cascade
F_3610	ORDERS_ID	ORDERS	ORDERS_ID	Cascade