Expand | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
|
A lookup table is defined by an entry in the LookupTable
table. Each row in this table defines a lookup table. The rows of each one of these lookup tables are stored in one of the value tables. The LookupTable has the following properties:
uniqueName
Primary key. A string that is used to refer to the table. Contrary to the property name, it does not have to be unique. It is the combination of uniqueName
, validAfter
, and simulationSet
that uniquely identifies a lookup table.
validAfter
Primary key. Specifies a date after which this lookup table can be used. When multiple lookup tables share the same name, the lookup table with the most recent validAfter
date will be used.
simulationSet
Primary key. A nullable string that forms
type
& valueType
These fields do not have meaning on their own, but the combination determines which value table will be used. When the type
is SIMPLE
, the valueType
determines the type of value. When the type
is RANGE
, the valueType
determines the type of the key.
status
Value of the TimedObjectStatus
enumeration. Determines whether — or in what context — the lookup table will be used.
label
The text that will be displayed to the end-user — to represent the lookup table.
formatType
Only relevant for simple lookup tables. Specifies how the value in the key-value-pair will be formatted in the frontend application.
...