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:

NameTypeDescription
PRICERULE_IDBIGINT NOT NULLGenerated Key
STOREENT_IDINTEGER NOT NULLThe unique identifier of the store in which the price rule was created.
IDENTIFIERVARCHAR (64) NOT NULLThe identifier of the price rule.
DESCRIPTIONVARCHAR (254)A description of the price rule, suitable for display to business users.
VERSIONDOUBLEReserved for IBM internal use.
STATESMALLINT NOT NULL DEFAULT 0Reserved for IBM internal use.
CREATETIMETIMESTAMPCreated time.
LASTUPDATETIMETIMESTAMPLast updated time.
DEPENDENTSMALLINT NOT NULL DEFAULT 0Indicate if the price rule is independent or not. Valid values include: 0 = Independent, 1 = Dependent. The default value is 0.
TYPESMALLINT NOT NULL DEFAULT 0The type of the price rule. Valid values include: 0 = internal, 1 = external. The default value is 0.
STARTTIMETIMESTAMPThe 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.
ENDTIMETIMESTAMPThe 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.
FIELD1VARCHAR (254)Customizable.
FIELD2VARCHAR (254)Customizable.
FIELD3VARCHAR (254)Customizable.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Indicates if this is marked for deletion: 0 = No. 1 = Yes.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PRICERULE_IDPrimary Key
I0001340IDENTIFIER+STOREENT_IDUnique Index
I0001341STOREENT_IDNon-Unique Index
I0001342TYPENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3630STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3633PRICERULE_IDPRELEMENTPRICERULE_IDCascade