PRCONSTANT

Each row of this table represents a price constant. Price constant is a reusable number or monetary value with a name indicating its business meaning. For example, a constant 'Uplift for EU countries' is used to increase prices in EU countries.

Column Descriptions:

NameTypeDescription
PRCONSTANT_IDBIGINT NOT NULLGenerated Key
STOREENT_IDINTEGER NOT NULLThe unique identifier of the store in which the price constant was created.
IDENTIFIERVARCHAR (64) NOT NULLThe identifier of the price constant.
DESCRIPTIONVARCHAR (254)A description of the price constant, suitable for display to business users.
TYPEINTEGER NOT NULL DEFAULT 0Indicates the type of the constant: 0 = NunmberType. 1 = MonetaryAmountType. 2 = PercentageType.
CREATETIMETIMESTAMPCreated time.
LASTUPDATETIMETIMESTAMPLast updated time
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>PRCONSTANT_IDPrimary Key
I0001351IDENTIFIER+STOREENT_IDUnique Index
I0001352STOREENT_IDNon-Unique Index
I0001353TYPENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3637STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3638PRCONSTANT_IDPRCONVALUEPRCONSTANT_IDCascade