PRELEMENT

Each row of this table represents a price rule element. Multiple elements function together to determine the flow of a price rule. For example, price rule element could be price list, condition, equation, branch and coordinator etc.

Column Descriptions:

NameTypeDescription
PRELEMENT_IDBIGINT NOT NULLGenerated Key
IDENTIFIERVARCHAR (64) NOT NULLThe identifier of the price rule element.
DESCRIPTIONVARCHAR (254)A description of the element, suitable for display to business users.
PRELETEMPLATE_IDBIGINT NOT NULLThe template id of the price rule element.
PRICERULE_IDBIGINT NOT NULLThe price rule id.
PARENTVARCHAR (64)The identifier of the parent element.
SEQUENCEDOUBLE NOT NULLThe sequence of this element under its parent element.
FIELD1VARCHAR (254)Customizable.
FIELD2VARCHAR (254)Customizable.
FIELD3VARCHAR (254)Customizable.
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>PRELEMENT_IDPrimary Key
I0001345IDENTIFIER+PRICERULE_IDUnique Index
I0001346PRELETEMPLATE_ID+PRICERULE_IDNon-Unique Index
I0001347PRICERULE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3633PRICERULE_IDPRICERULEPRICERULE_IDCascade
F_3634PRELETEMPLATE_IDPRELETEMPLATEPRELETEMPLATE_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3635PRELEMENT_IDPRELEMENTATTRPRELEMENT_IDCascade