PREQENTRYTYPE

Each row of this table represents an equation entry type.Currently there are following types:PriceList,Operator,Parenthesis,Number,PriceConstant,InputPrice.

Column Descriptions:

NameTypeDescription
PREQENTRYTYPE_IDBIGINT NOT NULLGenerated Key
IDENTIFIERVARCHAR (64) NOT NULLThe identifier of the equation entry type.
DESCRIPTIONVARCHAR (254)The description of the equation entry type.
PROPERTIESVARCHAR (254)The properties of the equation entry type.This can contain a set of symbols used for check if the entry is valid.For example, an "Operator" type equation entry can only be one of symbols such as "+,-,*,/".
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>PREQENTRYTYPE_IDPrimary Key
I0001386IDENTIFIERUnique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3677PREQENTRYTYPE_IDPREQENTRYPREQENTRYTYPE_IDCascade