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-ent1-000000000004 | null | null | STRING | null | null | UUID | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-a104-000000000003 | unit_id | Generation unit reference (optional) | 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-ent1-000000000004 | null | null | STRING | null | null | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-a104-000000000002 | plant_id | Power plant 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-ent1-000000000004 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-a104-000000000001 | forecast_id | Unique forecast 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-ent1-000000000003 | null | null | STRING | null | null | COLOR | null | null | 10 | null | null | null | null | null | null | 00000000-demo-enrg-a103-000000000011 | color_code | Display color 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-ent1-000000000003 | null | null | STRING | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-enrg-a103-000000000010 | description | Source 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-ent1-000000000003 | null | null | DECIMAL | null | null | null | null | null | 8 | 2 | null | null | null | null | null | 00000000-demo-enrg-a103-000000000009 | levelized_cost_usd_mwh | Levelized cost of energy ($/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-ent1-000000000003 | null | null | DECIMAL | null | null | null | null | null | 7 | 3 | null | null | null | null | null | 00000000-demo-enrg-a103-000000000008 | emission_factor_kg_co2_mwh | CO2 emission factor (kg/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-ent1-000000000003 | null | null | DECIMAL | null | null | null | null | null | 6 | 4 | null | null | null | null | null | 00000000-demo-enrg-a103-000000000007 | typical_capacity_factor | Typical capacity factor | 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-ent1-000000000003 | null | null | BOOLEAN | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-enrg-a103-000000000006 | is_dispatchable | Can be dispatched on demand | 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-ent1-000000000003 | null | null | BOOLEAN | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-enrg-a103-000000000005 | is_renewable | Renewable energy 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-ent1-000000000003 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-a103-000000000004 | category | Source category (renewable, fossil, nuclear) | 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-ent1-000000000003 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-a103-000000000003 | name | Energy source 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-ent1-000000000003 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-a103-000000000002 | code | Source 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-ent1-000000000003 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-a103-000000000001 | energy_source_id | Unique energy source 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-ent1-000000000002 | null | null | DATETIME | null | null | null | null | null | 20 | null | null | null | null | null | null | 00000000-demo-enrg-a102-000000000021 | 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-ent1-000000000002 | null | null | DATETIME | null | null | null | null | null | 19 | null | null | null | null | null | null | 00000000-demo-enrg-a102-000000000020 | 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-ent1-000000000002 | null | null | STRING | null | null | null | null | null | 18 | null | null | null | null | null | null | 00000000-demo-enrg-a102-000000000019 | status | Unit status (online, 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-ent1-000000000002 | null | null | INTEGER | null | null | null | null | null | 17 | null | null | null | null | null | null | 00000000-demo-enrg-a102-000000000018 | operating_hours | Total operating hours | 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-ent1-000000000002 | null | null | DATE | null | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-enrg-a102-000000000017 | next_maintenance_date | Next scheduled 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-ent1-000000000002 | null | null | DATE | null | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-enrg-a102-000000000016 | last_maintenance_date | Last maintenance 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-ent1-000000000002 | null | null | DATE | null | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-enrg-a102-000000000015 | installation_date | Unit installation 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-ent1-000000000002 | null | null | STRING | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-enrg-a102-000000000014 | model | Equipment model | 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-ent1-000000000002 | null | null | STRING | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-enrg-a102-000000000013 | manufacturer | Equipment manufacturer | 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-ent1-000000000002 | null | null | DECIMAL | null | null | null | null | null | 11 | 2 | null | null | null | null | null | 00000000-demo-enrg-a102-000000000012 | heat_rate_btu_kwh | Heat rate (BTU/kWh) for thermal units | 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-ent1-000000000002 | null | null | DECIMAL | null | null | null | null | null | 10 | 2 | null | null | null | null | null | 00000000-demo-enrg-a102-000000000011 | efficiency_percent | Generation efficiency | 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-ent1-000000000002 | null | null | DECIMAL | null | null | null | null | null | 9 | 3 | null | null | null | null | null | 00000000-demo-enrg-a102-000000000010 | ramp_down_rate_mw_min | Ramp down rate (MW/min) | 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-ent1-000000000002 | null | null | DECIMAL | null | null | null | null | null | 8 | 3 | null | null | null | null | null | 00000000-demo-enrg-a102-000000000009 | ramp_up_rate_mw_min | Ramp up rate (MW/min) | 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-ent1-000000000002 | null | null | DECIMAL | null | null | null | null | null | 7 | 3 | null | null | null | null | null | 00000000-demo-enrg-a102-000000000008 | max_output_mw | Maximum output | 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-ent1-000000000002 | null | null | DECIMAL | null | null | null | null | null | 6 | 3 | null | null | null | null | null | 00000000-demo-enrg-a102-000000000007 | min_output_mw | Minimum stable output | 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-ent1-000000000002 | null | null | DECIMAL | null | null | null | null | null | 5 | 3 | null | null | null | null | null | 00000000-demo-enrg-a102-000000000006 | rated_capacity_mw | Rated capacity 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-ent1-000000000002 | null | null | STRING | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-enrg-a102-000000000005 | unit_type | Unit type (turbine, panel_array, inverter) | 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-ent1-000000000002 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-a102-000000000004 | name | Unit 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-ent1-000000000002 | null | null | STRING | null | null | UUID | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-a102-000000000003 | plant_id | Power plant 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-ent1-000000000002 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-a102-000000000002 | unit_code | Unit 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-ent1-000000000002 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-a102-000000000001 | unit_id | Unique generation unit 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-ent1-000000000001 | null | null | DATETIME | null | null | null | null | null | 21 | null | null | null | null | null | null | 00000000-demo-enrg-a101-000000000022 | 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-ent1-000000000001 | null | null | DATETIME | null | null | null | null | null | 20 | null | null | null | null | null | null | 00000000-demo-enrg-a101-000000000021 | 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-ent1-000000000001 | null | null | STRING | null | null | null | null | null | 19 | null | null | null | null | null | null | 00000000-demo-enrg-a101-000000000020 | status | Plant status (operational, maintenance, offline) | 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-ent1-000000000001 | null | null | STRING | null | null | COMPANY_NAME | null | null | 18 | null | null | null | null | null | null | 00000000-demo-enrg-a101-000000000019 | operator_company | Operator company 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-ent1-000000000001 | null | null | STRING | null | null | COMPANY_NAME | null | null | 17 | null | null | null | null | null | null | 00000000-demo-enrg-a101-000000000018 | owner_company | Owner company 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-ent1-000000000001 | null | null | INTEGER | null | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-enrg-a101-000000000017 | expected_lifetime_years | Expected operational lifetime | 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-ent1-000000000001 | null | null | DATE | null | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-enrg-a101-000000000016 | commissioning_date | Date plant was commissioned | 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-ent1-000000000001 | null | null | STRING | null | null | UUID | null | null | 14 | null | null | null | null | null | null | 00000000-demo-enrg-a101-000000000015 | grid_node_id | Grid connection node | 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-ent1-000000000001 | null | null | STRING | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-enrg-a101-000000000014 | 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-ent1-000000000001 | null | null | DECIMAL | null | null | LONGITUDE | null | null | 12 | null | null | null | null | null | null | 00000000-demo-enrg-a101-000000000013 | 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-ent1-000000000001 | null | null | DECIMAL | null | null | LATITUDE | null | null | 11 | null | null | null | null | null | null | 00000000-demo-enrg-a101-000000000012 | 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-ent1-000000000001 | null | null | STRING | null | null | COUNTRY | null | null | 10 | null | null | null | null | null | null | 00000000-demo-enrg-a101-000000000011 | 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-ent1-000000000001 | null | null | STRING | null | null | STATE | null | null | 9 | null | null | null | null | null | null | 00000000-demo-enrg-a101-000000000010 | 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-ent1-000000000001 | null | null | STRING | null | null | CITY | null | null | 8 | null | null | null | null | null | null | 00000000-demo-enrg-a101-000000000009 | 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-ent1-000000000001 | null | null | STRING | null | null | STREET_ADDRESS | null | null | 7 | null | null | null | null | null | null | 00000000-demo-enrg-a101-000000000008 | 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 |