2
Tables (9)
ied_latest_values
- ied_model_node_id — int8 — Foreign key → ied_model_nodes.ied_model_node_id — NOT NULL
- ied_id — int8 — Foreign key → ied_model_nodes.ied_id — NOT NULL
- value_double — float8
- value_string — varchar(255)
- value_boolean — bool
- value_long — int8
- quality — varchar(50)
- updated_at — timestamptz — NOT NULL
ied_model_nodes
- ied_model_node_id — int8 — Primary key — NOT NULL
- ied_id — int8 — Foreign key → ieds.ied_id — NOT NULL
- logical_device — varchar(100) — NOT NULL
- logical_node — varchar(100) — NOT NULL
- data_object — varchar(100)
- data_attribute — varchar(100)
- fc — varchar(10)
- data_type — varchar(50)
- path — varchar(500) — NOT NULL
- parent_path — varchar(500)
- node_type — varchar(500) — NOT NULL
- created_at — timestamptz
- is_leaf — bool
- readable — bool
- writable — bool
- controllable — bool
ied_raw_values
- ied_raw_value_id — int8 — Primary key — NOT NULL
- ied_model_node_id — int8 — Foreign key → ied_model_nodes.ied_model_node_id — NOT NULL
- ied_id — int8 — Foreign key → ied_model_nodes.ied_id — NOT NULL
- logical_device — varchar(100)
- logical_node — varchar(100)
- data_object — varchar(100)
- data_attribute — varchar(100)
- fc — varchar(10)
- full_path — varchar(500)
- value_double — float8
- value_string — varchar(255)
- value_boolean — bool
- value_long — int8
- quality — varchar(50)
- source_timestamp — timestamptz
- created_at — timestamptz
ieds
- ied_id — int8 — Primary key — NOT NULL
- ip_address — varchar(100) — NOT NULL
- port — int4 — NOT NULL
- description — text
- created_at — timestamptz
- enabled — bool — NOT NULL
telemetry_values
- telemetry_value_id — int8 — Primary key — NOT NULL
- user_ied_mapping_id — int8 — Foreign key → user_ied_collection_configs.collection_config_id — NOT NULL
- user_ied_data_config_id — int8 — Foreign key → user_ied_data_configs.data_config_id — NOT NULL
- ied_model_node_id — int8 — NOT NULL
- value_double — float8
- value_string — varchar(255)
- value_boolean — bool
- value_long — int8
- quality — varchar(50)
- source_timestamp — timestamptz
- created_at — timestamptz
user_ied_collection_configs
- collection_config_id — int8 — Primary key — NOT NULL
- user_ied_mapping_id — int8 — Foreign key → user_ied_mappings.user_ied_mapping_id — NOT NULL
- polling_interval_seconds — int4 — NOT NULL
- enabled — bool — NOT NULL
- created_at — timestamptz
- updated_at — timestamptz
- last_run_time — timestamptz
user_ied_data_configs
- data_config_id — int8 — Primary key — NOT NULL
- user_ied_mapping_id — int8 — Foreign key → user_ied_mappings.user_ied_mapping_id — NOT NULL
- ied_model_node_id — int8 — Foreign key → ied_model_nodes.ied_model_node_id — NOT NULL
- enabled — bool — NOT NULL
- created_at — timestamptz
user_ied_mappings
- user_ied_mapping_id — int8 — Primary key — NOT NULL
- user_id — int8 — Foreign key → users.user_id — NOT NULL
- ied_id — int8 — Foreign key → ieds.ied_id — NOT NULL
- alias_name — varchar(100)
- created_at — timestamptz
users
- user_id — int8 — Primary key — NOT NULL
- password — varchar(255) — NOT NULL
- created_at — timestamptz
- user_name — varchar(200)
- role — varchar(100) — NOT NULL
- login_id — varchar(500)
- last_login — timestamptz
- updated_at — timestamptz