WebSphere Commerce database table: PRICERULE

PRICERULE

Each row of this table represents a price rule in a store. Price rule is a business rule which defines how to get a dynamic price under different business conditions.

Column Descriptions:

Name Type Description
PRICERULE_ID BIGINT NOT NULL Generated Key
STOREENT_ID INTEGER NOT NULL The unique identifier of the store in which the price rule was created.
IDENTIFIER VARCHAR (64) NOT NULL The identifier of the price rule.
DESCRIPTION VARCHAR (254) A description of the price rule, suitable for display to business users.
VERSION DOUBLE Reserved for IBM internal use.
STATE SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
CREATETIME TIMESTAMP Created time.
LASTUPDATETIME TIMESTAMP Last updated time.
DEPENDENT SMALLINT NOT NULL DEFAULT 0 Indicate if the price rule is independent or not. Valid values include: 0 = Independent, 1 = Dependent. The default value is 0.
TYPE SMALLINT NOT NULL DEFAULT 0 The type of the price rule. Valid values include: 0 = internal, 1 = external. Default is 0.
STARTTIME TIMESTAMP The start time for the price rule. If the start time is null, then the price rule will take effect immediately. Currently reserved for IBM internal use.
ENDTIME TIMESTAMP The end time for the price rule. If the end time is null, then the price rule will run indefinitely. Currently reserved for IBM internal use.
FIELD1 VARCHAR (254) Customizable.
FIELD2 VARCHAR (254) Customizable.
FIELD3 VARCHAR (254) Customizable.
MARKFORDELETE INTEGER NOT NULL DEFAULT 0 Indicates if this is marked for deletion: 0 = No. 1 = Yes.
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> PRICERULE_ID Primary Key
I0001340 IDENTIFIER+STOREENT_ID Unique Index
I0001341 STOREENT_ID Non-Unique Index
I0001342 TYPE Non-Unique Index

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_3630 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By Child Tables:

Constraint Columns Child Table Child Columns Type
F_3633 PRICERULE_ID PRELEMENT PRICERULE_ID Cascade

Name	Type	Description
PRICERULE_ID	BIGINT NOT NULL	Generated Key
STOREENT_ID	INTEGER NOT NULL	The unique identifier of the store in which the price rule was created.
IDENTIFIER	VARCHAR (64) NOT NULL	The identifier of the price rule.
DESCRIPTION	VARCHAR (254)	A description of the price rule, suitable for display to business users.
VERSION	DOUBLE	Reserved for IBM internal use.
STATE	SMALLINT NOT NULL DEFAULT 0	Reserved for IBM internal use.
CREATETIME	TIMESTAMP	Created time.
LASTUPDATETIME	TIMESTAMP	Last updated time.
DEPENDENT	SMALLINT NOT NULL DEFAULT 0	Indicate if the price rule is independent or not. Valid values include: 0 = Independent, 1 = Dependent. The default value is 0.
TYPE	SMALLINT NOT NULL DEFAULT 0	The type of the price rule. Valid values include: 0 = internal, 1 = external. Default is 0.
STARTTIME	TIMESTAMP	The start time for the price rule. If the start time is null, then the price rule will take effect immediately. Currently reserved for IBM internal use.
ENDTIME	TIMESTAMP	The end time for the price rule. If the end time is null, then the price rule will run indefinitely. Currently reserved for IBM internal use.
FIELD1	VARCHAR (254)	Customizable.
FIELD2	VARCHAR (254)	Customizable.
FIELD3	VARCHAR (254)	Customizable.
MARKFORDELETE	INTEGER NOT NULL DEFAULT 0	Indicates if this is marked for deletion: 0 = No. 1 = Yes.
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>	PRICERULE_ID	Primary Key
I0001340	IDENTIFIER+STOREENT_ID	Unique Index
I0001341	STOREENT_ID	Non-Unique Index
I0001342	TYPE	Non-Unique Index