WebSphere Commerce database table: PX

PX_USAGE

This table contains statistics about promotion usage.

Column Descriptions:

Name 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 version number of this 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 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_USAGE_ID Primary Key
I0000392 STOREENT_ID+NAME+VERSION Non-Unique Index
I0000393 GUESTID Non-Unique Index
I0000407 USERS_ID Non-Unique Index
I0000408 ORDERS_ID Non-Unique Index
I0000409 STOREENT_ID Non-Unique Index

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_1055 USERS_ID USERS USERS_ID Cascade
F_1056 STOREENT_ID STOREENT STOREENT_ID Cascade
F_1057 ORDERS_ID ORDERS ORDERS_ID Cascade

Name	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 version number of this 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 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.

Name	Column Names	Type
<SYSTEM-GENERATED>	PX_USAGE_ID	Primary Key
I0000392	STOREENT_ID+NAME+VERSION	Non-Unique Index
I0000393	GUESTID	Non-Unique Index
I0000407	USERS_ID	Non-Unique Index
I0000408	ORDERS_ID	Non-Unique Index
I0000409	STOREENT_ID	Non-Unique Index

Constraint	Columns	Parent Table	Parent Columns	Type
F_1055	USERS_ID	USERS	USERS_ID	Cascade
F_1056	STOREENT_ID	STOREENT	STOREENT_ID	Cascade
F_1057	ORDERS_ID	ORDERS	ORDERS_ID	Cascade