Your content here
Object structure
Enum objects
Connected bitmasks/connected enum values
Data table
¶ Values and String constants
- OBJECT_REFERENCE = 0 - Reference to other generic object
- ENUM_REFERENCE = 1 - Reference to other enum object
- BOOL = 2
- SMALL_INT = 3
- INT = 4
- BIG_INT = 5 - Beware of internal BIG_INT/DOUBLE conversions in scripts
- REAL = 6
- DOUBLE = 7
- VARCHAR = 8
- TEXT = 9
- NUMERIC_BITFIELD = 10 - Internally represented by int, expected to serve as bitfield
- BITFIELD = 12 - Internally represented by bitfield
- JSON_BINARY = 14
- DATE = 16
- TIME = 17
- TIME_TIMEZONE = 18 - Time with timezone
- DATETIME = 19
- DATETIME_TIMEZONE = 20 - Datetime with timezone
- BYTE_ARRAY = 21 - Binary data
- IP_ADDRESS = 23
- UUID = 24
- DATA_SOURCE = 0 - Data table has column for data authors
- TIME_SERIES = 1 - Neccessary for using Timescale DB extension
- DISCONNECT_VALUE = "disconnect_value"
- DISCONNECT_TIMEOUT = "disconnect_timeout"
¶ Data table column types
- PRIMARY_TIME = 0 - Primary time column for timescale DB
- MAJOR_VALUE_ANALOG = 2 - Fast-changing values (e.g. temperature, pressure)
- MAJOR_VALUE_DISCRETE = 3 - Slowly-changing values (e.g. state, error, quality, running)
- MINOR_VALUE = 4 - Other auxiliary value (e.g. array of integers, reference to other object/enum, state, small JSON)
- VALUE_QUALITY = 5 - Quality of the row if this column is not a meta column (target meta column is null). Quality of the target value column otherwise
- ADDITIONAL_DATA = 6 - Other metadata (e.g. original message, position, JSON, binary data)
- VALUE_IDENTIFIER = 7 - part of primary key, can be used to filter (e.g. type, variable_id, device_id)
- VALUE_MIN = 100 - Minimum value of the target major value column (always meta column, always hat the same datatype)
- VALUE_MAX = 101 - Maximum value of the target major value column (always meta column, always has the same datatype)
¶ Data table column flags
- OPTIONAL = 0 - Nullable data type
- ARRAY_VALUE = 1 - Array of data types
- REGEX_CASE_SENSITIVE = 2 - Validate case sensitive Regex
- REGEX_NEGATION = 3 - Use !~ in regex validation instead of ~
- MIN_EXCLUDED = 4 - Use > instead of >= in minimum validation
- MAX_EXCLUDED = 5 - Use < instead of <= in minimum validation
¶ Data table column settings
- UNIT = "unit"
- MIN_EXPECTED_VALUE = "min_expected_value" - Not validated, just expected.
- MAX_EXPECTED_VALUE = "max_expected_value" - Not validated, just expected.