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:

Name	Type	Description
PRCONSTANT_ID	BIGINT NOT NULL	Generated Key
STOREENT_ID	INTEGER NOT NULL	The unique identifier of the store in which the price constant was created.
IDENTIFIER	VARCHAR (64) NOT NULL	The identifier of the price constant.
DESCRIPTION	VARCHAR (254)	A description of the price constant, suitable for display to business users.
TYPE	INTEGER NOT NULL DEFAULT 0	Indicates the type of the constant: 0 = NunmberType. 1 = MonetaryAmountType. 2 = PercentageType.
CREATETIME	TIMESTAMP	Created time.
LASTUPDATETIME	TIMESTAMP	Last updated time
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>	PRCONSTANT_ID	Primary Key
I0001351	IDENTIFIER+STOREENT_ID	Unique Index
I0001352	STOREENT_ID	Non-Unique Index
I0001353	TYPE	Non-Unique Index

Constrained By Parent Tables:

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

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_3638	PRCONSTANT_ID	PRCONVALUE	PRCONSTANT_ID	Cascade