Online
v0.9.0
Tables
data_attributes 9849 records
| entity_id | physical_name | origin | data_type | dialect_type | dialect | business_type | business_type_params | data_type_info | order | scale | is_primary_key | is_foreign_key | is_unique | is_nullable | is_autoincrement | is_surrogate_key | is_business_key | is_audit_column | is_scd_column | audit_role | scd_role | pii_level | pcidss_attribute | hipaa_identifier | id | name | description | created_by_id | updated_by_id | created_at | updated_at | version | deleted |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 89c76e55-9458-4d02-b5ae-938cebe7d40f | customer_name | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | 77b0828b-62e3-43e9-824f-258029f4e38f | customer_name | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 89c76e55-9458-4d02-b5ae-938cebe7d40f | customer_id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | 5f20542f-18b0-4460-ac05-efcbb46d8669 | customer_id | The unique key for each customer. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| f15a7625-5605-4e7a-b869-68c0e6b71064 | is_drink_item | null | BOOLEAN | BOOLEAN | snowflake | null | null | null | 6 | null | null | null | null | null | null | 62cd3cf5-1fc5-4dd5-9cbf-d882d0ff8209 | is_drink_item | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| f15a7625-5605-4e7a-b869-68c0e6b71064 | is_food_item | null | BOOLEAN | BOOLEAN | snowflake | null | null | null | 5 | null | null | null | null | null | null | 56119d5d-f0d9-4172-8644-2ba93027c4ed | is_food_item | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| f15a7625-5605-4e7a-b869-68c0e6b71064 | product_price | null | DECIMAL | NUMBER | snowflake | null | null | null | 4 | null | null | null | null | null | null | 4ea56165-34e1-43de-ab41-be1e95ed1606 | product_price | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| f15a7625-5605-4e7a-b869-68c0e6b71064 | product_description | null | STRING | TEXT | snowflake | null | null | null | 3 | null | null | null | null | null | null | 15497d8f-c9bf-4f58-a45c-6295f5ca6ffe | product_description | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| f15a7625-5605-4e7a-b869-68c0e6b71064 | product_type | null | STRING | TEXT | snowflake | null | null | null | 2 | null | null | null | null | null | null | 725bd955-0054-4d62-815d-b9a0e7a59d84 | product_type | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| f15a7625-5605-4e7a-b869-68c0e6b71064 | product_name | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | dc035ea7-0acc-4e9a-b78f-9f45ee1313f3 | product_name | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| f15a7625-5605-4e7a-b869-68c0e6b71064 | product_id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | 31409a01-0f1b-4026-b12c-5c002d400d36 | product_id | The unique key for each product. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000006 | null | null | STRING | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-enrg-a206-000000000011 | status | Event status (active, resolved, investigating) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000006 | null | null | STRING | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-enrg-a206-000000000010 | impact_description | Impact description | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000006 | null | null | STRING | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-enrg-a206-000000000009 | cause | Event cause description | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000006 | null | null | DECIMAL | null | null | null | null | null | 7 | 3 | null | null | null | null | null | 00000000-demo-enrg-a206-000000000008 | affected_capacity_mva | Affected capacity in MVA | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000006 | null | null | DATETIME | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-enrg-a206-000000000007 | end_datetime | Event end timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000006 | null | null | DATETIME | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-enrg-a206-000000000006 | start_datetime | Event start timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000006 | null | null | STRING | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-enrg-a206-000000000005 | event_type | Event type (outage, fault, maintenance) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000006 | null | null | STRING | null | null | UUID | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-a206-000000000004 | substation_id | Affected substation reference | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000006 | null | null | STRING | null | null | UUID | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-a206-000000000003 | node_id | Affected grid node reference | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000006 | null | null | STRING | null | null | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-a206-000000000002 | line_id | Affected transmission line reference | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000006 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-a206-000000000001 | event_id | Unique grid event identifier | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000005 | null | null | DATETIME | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-enrg-a205-000000000012 | created_at | Record creation timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000005 | null | null | STRING | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-enrg-a205-000000000011 | data_quality | Data quality flag (measured, estimated, validated) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000005 | null | null | STRING | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-enrg-a205-000000000010 | direction | Flow direction (forward, reverse) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000005 | null | null | DECIMAL | null | null | null | null | null | 8 | 3 | null | null | null | null | null | 00000000-demo-enrg-a205-000000000009 | losses_mw | Transmission losses in MW | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000005 | null | null | DECIMAL | null | null | null | null | null | 7 | 2 | null | null | null | null | null | 00000000-demo-enrg-a205-000000000008 | loading_percent | Line loading percentage | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000005 | null | null | DECIMAL | null | null | null | null | null | 6 | 3 | null | null | null | null | null | 00000000-demo-enrg-a205-000000000007 | apparent_power_mva | Apparent power flow in MVA | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000005 | null | null | DECIMAL | null | null | null | null | null | 5 | 3 | null | null | null | null | null | 00000000-demo-enrg-a205-000000000006 | reactive_power_mvar | Reactive power flow in MVAr | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000005 | null | null | DECIMAL | null | null | null | null | null | 4 | 3 | null | null | null | null | null | 00000000-demo-enrg-a205-000000000005 | active_power_mw | Active power flow in MW | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000005 | null | null | INTEGER | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-a205-000000000004 | interval_minutes | Measurement interval (minutes) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000005 | null | null | DATETIME | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-a205-000000000003 | measurement_datetime | Flow measurement timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000005 | null | null | STRING | null | null | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-a205-000000000002 | line_id | Transmission line reference | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000005 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-a205-000000000001 | flow_id | Unique power flow record identifier | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000004 | null | null | BOOLEAN | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-enrg-a204-000000000010 | is_binding | Currently binding constraint flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000004 | null | null | STRING | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-enrg-a204-000000000009 | direction | Flow direction constraint (forward, reverse, bidirectional) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000004 | null | null | DECIMAL | null | null | null | null | null | 7 | 3 | null | null | null | null | null | 00000000-demo-enrg-a204-000000000008 | contingency_limit_mva | Contingency limit in MVA | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000004 | null | null | DECIMAL | null | null | null | null | null | 6 | 3 | null | null | null | null | null | 00000000-demo-enrg-a204-000000000007 | stability_limit_mva | Stability limit in MVA | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000004 | null | null | DECIMAL | null | null | null | null | null | 5 | 3 | null | null | null | null | null | 00000000-demo-enrg-a204-000000000006 | thermal_limit_mva | Thermal capacity limit in MVA | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000004 | null | null | DATETIME | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-enrg-a204-000000000005 | valid_to | Validity end datetime | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000004 | null | null | DATETIME | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-a204-000000000004 | valid_from | Validity start datetime | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000004 | null | null | STRING | null | null | UUID | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-a204-000000000003 | node_id | Grid node reference | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000004 | null | null | STRING | null | null | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-a204-000000000002 | line_id | Transmission line reference | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000004 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-a204-000000000001 | capacity_id | Unique capacity record identifier | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000003 | null | null | DATETIME | null | null | null | null | null | 17 | null | null | null | null | null | null | 00000000-demo-enrg-a203-000000000018 | updated_at | Record last update timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000003 | null | null | DATETIME | null | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-enrg-a203-000000000017 | created_at | Record creation timestamp | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000003 | null | null | STRING | null | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-enrg-a203-000000000016 | status | Substation status (operational, offline, maintenance) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000003 | null | null | DATE | null | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-enrg-a203-000000000015 | commissioning_date | Commissioning date | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000003 | null | null | STRING | null | null | COUNTRY | null | null | 13 | null | null | null | null | null | null | 00000000-demo-enrg-a203-000000000014 | country_code | Country code | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000003 | null | null | STRING | null | null | STATE | null | null | 12 | null | null | null | null | null | null | 00000000-demo-enrg-a203-000000000013 | state | State/province | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000003 | null | null | STRING | null | null | CITY | null | null | 11 | null | null | null | null | null | null | 00000000-demo-enrg-a203-000000000012 | city | City | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-enrg-ent2-000000000003 | null | null | STRING | null | null | STREET_ADDRESS | null | null | 10 | null | null | null | null | null | null | 00000000-demo-enrg-a203-000000000011 | address | Physical address | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 |