Each row of this table represents an equation entry
(unit) for an equation. Multiple equation entries function together
to compose an equation. For example, the equation "Master Price
List * 0.5" is composed of 3 equation entries: "Master Price
List","*","0.5".
Column Descriptions:
Name | Type | Description |
PREQENTRY_ID | BIGINT NOT NULL | Generated Key |
PREQUATION_ID | BIGINT NOT NULL | The unique identifier of the equation which the
equation entry belongs to. |
PREQENTRYTYPE_ID | BIGINT NOT NULL | The unique identifier of the equation entry
type. |
VALUE | VARCHAR (254) NOT NULL | The value of the equation entry. |
SEQUENCE | DOUBLE NOT NULL | The sequence of this equation entry for the same
equation. |
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> | PREQENTRY_ID | Primary Key |
I0001359 | PREQUATION_ID | Non-Unique Index |
I0001385 | PREQENTRYTYPE_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_3676 | PREQUATION_ID | PREQUATION | PREQUATION_ID | Cascade |
F_3677 | PREQENTRYTYPE_ID | PREQENTRYTYPE | PREQENTRYTYPE_ID | Cascade |