This table contains statistics about promotion usage.
Column Descriptions
| Column Name
| Column Type
| Description
|
| PX_USAGE_ID
| BIGINT NOT NULL
| Primary key of this table.
|
| ORDERS_ID
| BIGINT NOT NULL
| Foreign key to the ORDERS table. This lists the orders to which this promotion was applied.
|
| USERS_ID
| BIGINT
| The ID of the customer to whom the promotion is applied.
|
| STOREENT_ID
| INTEGER NOT NULL
| Foreign key to the STORENT table. When combined with the values in the NAME and VERSION columns, this identifies the promotion that is being applied.
|
| VERSION
| INTEGER NOT NULL
| The name of the promotion.
|
| GUESTID
| VARCHAR(64)
| Contains the string token that identifies a customer if they are a guest customer. For example, an email address.
|
| NAME
| VARCHAR(128) NOT NULL
| The name of the promotion.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|