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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 00000000-demo-enrg-ent2-000000000003 | null | null | DECIMAL | null | null | LONGITUDE | null | null | 9 | null | null | null | null | null | null | 00000000-demo-enrg-a203-000000000010 | longitude | GPS longitude | 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 | DECIMAL | null | null | LATITUDE | null | null | 8 | null | null | null | null | null | null | 00000000-demo-enrg-a203-000000000009 | latitude | GPS latitude | 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 | DECIMAL | null | null | null | null | null | 7 | 3 | null | null | null | null | null | 00000000-demo-enrg-a203-000000000008 | capacity_mva | Substation 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-000000000003 | null | null | DECIMAL | null | null | null | null | null | 6 | 2 | null | null | null | null | null | 00000000-demo-enrg-a203-000000000007 | secondary_voltage_kv | Secondary voltage level in kV | 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 | DECIMAL | null | null | null | null | null | 5 | 2 | null | null | null | null | null | 00000000-demo-enrg-a203-000000000006 | primary_voltage_kv | Primary voltage level in kV | 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 | UUID | null | null | 4 | null | null | null | null | null | null | 00000000-demo-enrg-a203-000000000005 | node_id | Associated 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-000000000003 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-a203-000000000004 | substation_type | Type (transmission, distribution, switching) | 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 | 2 | null | null | null | null | null | null | 00000000-demo-enrg-a203-000000000003 | name | Substation name | 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 | 1 | null | null | null | null | null | null | 00000000-demo-enrg-a203-000000000002 | substation_code | Industry standard substation 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 | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-a203-000000000001 | substation_id | Unique substation 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-000000000002 | null | null | DATETIME | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-enrg-a202-000000000014 | 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-000000000002 | null | null | DATETIME | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-enrg-a202-000000000013 | 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-000000000002 | null | null | STRING | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-enrg-a202-000000000012 | status | Line 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-000000000002 | null | null | INTEGER | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-enrg-a202-000000000011 | construction_year | Year of construction | 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-000000000002 | null | null | DECIMAL | null | null | null | null | null | 9 | 6 | null | null | null | null | null | 00000000-demo-enrg-a202-000000000010 | reactance_ohm | Line reactance in ohms | 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-000000000002 | null | null | DECIMAL | null | null | null | null | null | 8 | 6 | null | null | null | null | null | 00000000-demo-enrg-a202-000000000009 | resistance_ohm | Line resistance in ohms | 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-000000000002 | null | null | DECIMAL | null | null | null | null | null | 7 | 3 | null | null | null | null | null | 00000000-demo-enrg-a202-000000000008 | capacity_mva | Line 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-000000000002 | null | null | DECIMAL | null | null | null | null | null | 6 | 3 | null | null | null | null | null | 00000000-demo-enrg-a202-000000000007 | length_km | Line length in kilometers | 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-000000000002 | null | null | DECIMAL | null | null | null | null | null | 5 | 2 | null | null | null | null | null | 00000000-demo-enrg-a202-000000000006 | voltage_level_kv | Line voltage level in kV | 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-000000000002 | null | null | STRING | null | null | UUID | null | null | 4 | null | null | null | null | null | null | 00000000-demo-enrg-a202-000000000005 | to_node_id | Destination 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-000000000002 | null | null | STRING | null | null | UUID | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-a202-000000000004 | from_node_id | Source 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-000000000002 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-a202-000000000003 | name | Line name | 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-000000000002 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-a202-000000000002 | line_code | Industry standard line 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-000000000002 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-a202-000000000001 | line_id | Unique transmission line 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-000000000001 | null | null | DATETIME | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-enrg-a201-000000000012 | 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-000000000001 | null | null | DATETIME | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-enrg-a201-000000000011 | 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-000000000001 | null | null | STRING | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-enrg-a201-000000000010 | status | Node status (active, inactive, 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-000000000001 | null | null | STRING | null | null | COMPANY_NAME | null | null | 8 | null | null | null | null | null | null | 00000000-demo-enrg-a201-000000000009 | operator_company | Transmission operator company | 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-000000000001 | null | null | DECIMAL | null | null | LONGITUDE | null | null | 7 | null | null | null | null | null | null | 00000000-demo-enrg-a201-000000000008 | longitude | GPS longitude | 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-000000000001 | null | null | DECIMAL | null | null | LATITUDE | null | null | 6 | null | null | null | null | null | null | 00000000-demo-enrg-a201-000000000007 | latitude | GPS latitude | 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-000000000001 | null | null | STRING | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-enrg-a201-000000000006 | grid_zone | Grid zone/balancing area | 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-000000000001 | null | null | DECIMAL | null | null | null | null | null | 4 | 2 | null | null | null | null | null | 00000000-demo-enrg-a201-000000000005 | voltage_level_kv | Voltage level in kV | 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-000000000001 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-a201-000000000004 | node_type | Node type (generation, load, interconnect) | 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-000000000001 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-a201-000000000003 | name | Node name | 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-000000000001 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-a201-000000000002 | node_code | Industry standard node 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-000000000001 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-a201-000000000001 | node_id | Unique grid node 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-ent4-000000000006 | null | null | DATETIME | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-enrg-a406-000000000011 | created_at | Schedule 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-ent4-000000000006 | null | null | STRING | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-enrg-a406-000000000010 | optimization_model | Optimization model used | 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-ent4-000000000006 | null | null | DECIMAL | null | null | null | null | null | 8 | 2 | null | null | null | null | null | 00000000-demo-enrg-a406-000000000009 | price_signal | Price signal (USD/MWh) | 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-ent4-000000000006 | null | null | DECIMAL | null | null | null | null | null | 7 | 2 | null | null | null | null | null | 00000000-demo-enrg-a406-000000000008 | expected_revenue | Expected revenue (USD) | 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-ent4-000000000006 | null | null | DECIMAL | null | null | null | null | null | 6 | 3 | null | null | null | null | null | 00000000-demo-enrg-a406-000000000007 | target_power_mw | Target power setpoint (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-ent4-000000000006 | null | null | STRING | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-enrg-a406-000000000006 | action | Scheduled action (charge, discharge, idle) | 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-ent4-000000000006 | null | null | DATETIME | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-enrg-a406-000000000005 | interval_end | Interval end time | 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-ent4-000000000006 | null | null | DATETIME | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-a406-000000000004 | interval_start | Interval start time | 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-ent4-000000000006 | null | null | DATE | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-a406-000000000003 | schedule_date | Schedule 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-ent4-000000000006 | null | null | STRING | null | null | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-a406-000000000002 | facility_id | Storage facility 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-ent4-000000000006 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-a406-000000000001 | schedule_id | Unique schedule 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-ent4-000000000005 | null | null | STRING | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-enrg-a405-000000000009 | status | Unit status (charging, discharging, idle, fault) | 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-ent4-000000000005 | null | null | DECIMAL | null | null | null | null | null | 7 | 6 | null | null | null | null | null | 00000000-demo-enrg-a405-000000000008 | degradation_rate | Degradation rate (%/cycle) | 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-ent4-000000000005 | null | null | DECIMAL | null | null | null | null | null | 6 | 2 | null | null | null | null | null | 00000000-demo-enrg-a405-000000000007 | health_percent | State of health percentage | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 |