PRELETEMPLATE

Each row of this table represents a price rule element template. Elements which share the same template use the same element command but different parameters for price rule evaluation at runtime. For example, customer segment condition is an element template.

Column Descriptions:

NameTypeDescription
PRELETEMPLATE_IDBIGINT NOT NULLGenerated Key
IDENTIFIERVARCHAR (64) NOT NULLThe identifier of the price rule element template.
STOREENT_IDINTEGERThe store for which the price rule element template is applied. If this is null, the element template is applied for all stores.
DESCRIPTIONVARCHAR (254)A description of the price rule element template.
PRELETPLTGRP_IDBIGINT NOT NULLThe identifier of the price rule element template group.
RUNTIMEXMLCLOB (1000000)The runtime XML definition of the element template.
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>PRELETEMPLATE_IDPrimary Key
I0001343PRELETPLTGRP_ID+IDENTIFIER+STOREENT_IDUnique Index
I0001344STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3631PRELETPLTGRP_IDPRELETPLTGRPPRELETPLTGRP_IDCascade
F_3632STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3634PRELETEMPLATE_IDPRELEMENTPRELETEMPLATE_IDCascade