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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 81fa2196-4f15-46f7-be15-6ff76f63bfa4 | customer_name | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | e2c249b7-e46e-4a6f-ac4c-1fd85460d40c | customer_name | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 81fa2196-4f15-46f7-be15-6ff76f63bfa4 | customer_id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | 3e038892-6c46-40f8-ac03-347cbbff92d8 | customer_id | The unique key for each customer. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| c5b5ad9e-1ccd-4c78-8cf7-bd4a018ba780 | is_drink_item | null | BOOLEAN | BOOLEAN | snowflake | null | null | null | 6 | null | null | null | null | null | null | e508223c-4761-4525-b270-f0caffcfb521 | is_drink_item | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| c5b5ad9e-1ccd-4c78-8cf7-bd4a018ba780 | is_food_item | null | BOOLEAN | BOOLEAN | snowflake | null | null | null | 5 | null | null | null | null | null | null | 8b34f1d0-e6e9-4b98-8b26-c8a4b188f22a | is_food_item | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| c5b5ad9e-1ccd-4c78-8cf7-bd4a018ba780 | product_price | null | DECIMAL | NUMBER | snowflake | null | null | null | 4 | null | null | null | null | null | null | b47a4340-28d9-4f07-a6ee-165c1318e9ce | product_price | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| c5b5ad9e-1ccd-4c78-8cf7-bd4a018ba780 | product_description | null | STRING | TEXT | snowflake | null | null | null | 3 | null | null | null | null | null | null | 7e518d76-ceca-4716-82f4-cda8752cd44c | product_description | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| c5b5ad9e-1ccd-4c78-8cf7-bd4a018ba780 | product_type | null | STRING | TEXT | snowflake | null | null | null | 2 | null | null | null | null | null | null | 64ed7889-ce83-4edb-9fe7-89c590b4f036 | product_type | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| c5b5ad9e-1ccd-4c78-8cf7-bd4a018ba780 | product_name | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | 8b240417-bfde-4130-9c65-8ed3e851ead0 | product_name | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| c5b5ad9e-1ccd-4c78-8cf7-bd4a018ba780 | product_id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | 4fa760de-1d77-4225-ab6e-4128f744c7d0 | product_id | The unique key for each product. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 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:16:38 | 2026-01-03 15:16:38 | 1 |