PREQENTRY

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:

NameTypeDescription
PREQENTRY_IDBIGINT NOT NULLGenerated Key
PREQUATION_IDBIGINT NOT NULLThe unique identifier of the equation which the equation entry belongs to.
PREQENTRYTYPE_IDBIGINT NOT NULLThe unique identifier of the equation entry type.
VALUEVARCHAR (254) NOT NULLThe value of the equation entry.
SEQUENCEDOUBLE NOT NULLThe sequence of this equation entry for the same equation.
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>PREQENTRY_IDPrimary Key
I0001359PREQUATION_IDNon-Unique Index
I0001385PREQENTRYTYPE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3676PREQUATION_IDPREQUATIONPREQUATION_IDCascade
F_3677PREQENTRYTYPE_IDPREQENTRYTYPEPREQENTRYTYPE_IDCascade