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-ent4-000000000001 | null | null | DECIMAL | null | null | LATITUDE | null | null | 11 | null | null | null | null | null | null | 00000000-demo-enrg-a401-000000000012 | latitude | GPS latitude | 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-ent4-000000000001 | null | null | STRING | null | null | COUNTRY | null | null | 10 | null | null | null | null | null | null | 00000000-demo-enrg-a401-000000000011 | 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-ent4-000000000001 | null | null | STRING | null | null | STATE | null | null | 9 | null | null | null | null | null | null | 00000000-demo-enrg-a401-000000000010 | 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-ent4-000000000001 | null | null | STRING | null | null | CITY | null | null | 8 | null | null | null | null | null | null | 00000000-demo-enrg-a401-000000000009 | 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-ent4-000000000001 | null | null | STRING | null | null | STREET_ADDRESS | null | null | 7 | null | null | null | null | null | null | 00000000-demo-enrg-a401-000000000008 | 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 | ||||||||||
| 00000000-demo-enrg-ent4-000000000001 | null | null | STRING | null | null | UUID | null | null | 6 | null | null | null | null | null | null | 00000000-demo-enrg-a401-000000000007 | grid_node_id | Grid connection 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-ent4-000000000001 | null | null | DECIMAL | null | null | null | null | null | 5 | 3 | null | null | null | null | null | 00000000-demo-enrg-a401-000000000006 | rated_power_mw | Rated power capacity in megawatts | 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-ent4-000000000001 | null | null | DECIMAL | null | null | null | null | null | 4 | 3 | null | null | null | null | null | 00000000-demo-enrg-a401-000000000005 | total_capacity_mwh | Total storage capacity in megawatt-hours | 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-ent4-000000000001 | null | null | STRING | null | null | UUID | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-a401-000000000004 | technology_id | Storage technology 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-ent4-000000000001 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-a401-000000000003 | name | Facility name | 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-ent4-000000000001 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-a401-000000000002 | facility_code | Industry standard facility 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-ent4-000000000001 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-a401-000000000001 | facility_id | Unique storage facility 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-ent1-000000000006 | null | null | BOOLEAN | null | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-enrg-a106-000000000016 | is_forecast | Forecast vs actual 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-ent1-000000000006 | null | null | STRING | null | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-enrg-a106-000000000015 | data_source | Weather data source | 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-ent1-000000000006 | null | null | DECIMAL | null | null | null | null | null | 13 | 2 | null | null | null | null | null | 00000000-demo-enrg-a106-000000000014 | pressure_hpa | Atmospheric pressure (hPa) | 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-ent1-000000000006 | null | null | DECIMAL | null | null | null | null | null | 12 | 2 | null | null | null | null | null | 00000000-demo-enrg-a106-000000000013 | precipitation_mm | Precipitation (mm) | 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-ent1-000000000006 | null | null | DECIMAL | null | null | null | null | null | 11 | 2 | null | null | null | null | null | 00000000-demo-enrg-a106-000000000012 | humidity_percent | Relative humidity | 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-ent1-000000000006 | null | null | DECIMAL | null | null | null | null | null | 10 | 2 | null | null | null | null | null | 00000000-demo-enrg-a106-000000000011 | cloud_cover_percent | Cloud cover 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-ent1-000000000006 | null | null | DECIMAL | null | null | null | null | null | 9 | 2 | null | null | null | null | null | 00000000-demo-enrg-a106-000000000010 | dni_w_m2 | Direct Normal Irradiance (W/m2) | 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-ent1-000000000006 | null | null | DECIMAL | null | null | null | null | null | 8 | 2 | null | null | null | null | null | 00000000-demo-enrg-a106-000000000009 | ghi_w_m2 | Global Horizontal Irradiance (W/m2) | 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-ent1-000000000006 | null | null | DECIMAL | null | null | null | null | null | 7 | 2 | null | null | null | null | null | 00000000-demo-enrg-a106-000000000008 | wind_direction_deg | Wind direction (degrees) | 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-ent1-000000000006 | null | null | DECIMAL | null | null | null | null | null | 6 | 2 | null | null | null | null | null | 00000000-demo-enrg-a106-000000000007 | wind_speed_ms | Wind speed (m/s) | 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-ent1-000000000006 | null | null | DECIMAL | null | null | null | null | null | 5 | 2 | null | null | null | null | null | 00000000-demo-enrg-a106-000000000006 | temperature_celsius | Temperature in Celsius | 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-ent1-000000000006 | null | null | DATETIME | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-enrg-a106-000000000005 | measurement_datetime | Weather observation time | 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-ent1-000000000006 | null | null | DECIMAL | null | null | LONGITUDE | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-a106-000000000004 | longitude | GPS longitude | 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-ent1-000000000006 | null | null | DECIMAL | null | null | LATITUDE | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-a106-000000000003 | latitude | GPS latitude | 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-ent1-000000000006 | null | null | STRING | null | null | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-a106-000000000002 | plant_id | Associated plant 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-ent1-000000000006 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-a106-000000000001 | weather_id | Unique weather 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-ent1-000000000005 | null | null | DATETIME | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-enrg-a105-000000000013 | 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-ent1-000000000005 | null | null | STRING | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-enrg-a105-000000000012 | 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-ent1-000000000005 | null | null | STRING | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-enrg-a105-000000000011 | curtailment_reason | Reason for curtailment | 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-ent1-000000000005 | null | null | DECIMAL | null | null | null | null | null | 9 | 3 | null | null | null | null | null | 00000000-demo-enrg-a105-000000000010 | curtailment_mwh | Curtailed energy (MWh) | 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-ent1-000000000005 | null | null | DECIMAL | null | null | null | null | null | 8 | 4 | null | null | null | null | null | 00000000-demo-enrg-a105-000000000009 | capacity_factor | Capacity factor for period | 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-ent1-000000000005 | null | null | DECIMAL | null | null | null | null | null | 7 | 2 | null | null | null | null | null | 00000000-demo-enrg-a105-000000000008 | availability_percent | Unit availability | 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-ent1-000000000005 | null | null | DECIMAL | null | null | null | null | null | 6 | 3 | null | null | null | null | null | 00000000-demo-enrg-a105-000000000007 | power_mw | Average power output (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-ent1-000000000005 | null | null | DECIMAL | null | null | null | null | null | 5 | 3 | null | null | null | null | null | 00000000-demo-enrg-a105-000000000006 | generation_mwh | Actual generation (MWh) | 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-ent1-000000000005 | null | null | INTEGER | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-enrg-a105-000000000005 | 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-ent1-000000000005 | null | null | DATETIME | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-a105-000000000004 | measurement_datetime | 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-ent1-000000000005 | null | null | STRING | null | null | UUID | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-a105-000000000003 | unit_id | Generation unit reference (optional) | 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-ent1-000000000005 | null | null | STRING | null | null | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-a105-000000000002 | plant_id | Power plant 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-ent1-000000000005 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-a105-000000000001 | production_id | Unique production 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-ent1-000000000004 | null | null | DATETIME | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-enrg-a104-000000000012 | created_at | Forecast 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-ent1-000000000004 | null | null | DECIMAL | null | null | null | null | null | 10 | 4 | null | null | null | null | null | 00000000-demo-enrg-a104-000000000011 | weather_factor | Weather adjustment factor | 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-ent1-000000000004 | null | null | STRING | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-enrg-a104-000000000010 | forecast_model | Forecast model used | 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-ent1-000000000004 | null | null | DECIMAL | null | null | null | null | null | 8 | 3 | null | null | null | null | null | 00000000-demo-enrg-a104-000000000009 | confidence_level | Confidence level (0-1) | 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-ent1-000000000004 | null | null | DECIMAL | null | null | null | null | null | 7 | 3 | null | null | null | null | null | 00000000-demo-enrg-a104-000000000008 | generation_max_mwh | Forecast maximum (P90) | 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-ent1-000000000004 | null | null | DECIMAL | null | null | null | null | null | 6 | 3 | null | null | null | null | null | 00000000-demo-enrg-a104-000000000007 | generation_min_mwh | Forecast minimum (P10) | 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-ent1-000000000004 | null | null | DECIMAL | null | null | null | null | null | 5 | 3 | null | null | null | null | null | 00000000-demo-enrg-a104-000000000006 | generation_mwh | Forecasted generation (MWh) | 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-ent1-000000000004 | null | null | INTEGER | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-enrg-a104-000000000005 | forecast_horizon_hours | Forecast horizon in hours | 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-ent1-000000000004 | null | null | DATETIME | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-a104-000000000004 | forecast_datetime | Forecast target datetime | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 |