Each row of this table represents an equation entry
type.Currently there are following
types:PriceList,Operator,Parenthesis,Number,PriceConstant,InputPrice.
Column Descriptions:
Name | Type | Description |
PREQENTRYTYPE_ID | BIGINT NOT NULL | Generated Key |
IDENTIFIER | VARCHAR (64) NOT NULL | The identifier of the equation entry type. |
DESCRIPTION | VARCHAR (254) | The description of the equation entry type. |
PROPERTIES | VARCHAR (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 "+,-,*,/". |
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> | PREQENTRYTYPE_ID | Primary Key |
I0001386 | IDENTIFIER | Unique Index |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | Type |
F_3677 | PREQENTRYTYPE_ID | PREQENTRY | PREQENTRYTYPE_ID | Cascade |