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:
| 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 |