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-ent3-000000000005 | null | null | DATETIME | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-enrg-a305-000000000011 | created_at | Forecast 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-ent3-000000000005 | null | null | STRING | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-enrg-a305-000000000010 | forecast_model | Forecast 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-ent3-000000000005 | null | null | DECIMAL | null | null | null | null | null | 8 | 3 | null | null | null | null | null | 00000000-demo-enrg-a305-000000000009 | confidence_level | Confidence level (0-1) | 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-ent3-000000000005 | null | null | DECIMAL | null | null | null | null | null | 7 | 3 | null | null | null | null | null | 00000000-demo-enrg-a305-000000000008 | demand_max_mwh | Forecast maximum (P90) | 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-ent3-000000000005 | null | null | DECIMAL | null | null | null | null | null | 6 | 3 | null | null | null | null | null | 00000000-demo-enrg-a305-000000000007 | demand_min_mwh | Forecast minimum (P10) | 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-ent3-000000000005 | null | null | DECIMAL | null | null | null | null | null | 5 | 3 | null | null | null | null | null | 00000000-demo-enrg-a305-000000000006 | demand_mwh | Forecasted demand (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-ent3-000000000005 | null | null | INTEGER | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-enrg-a305-000000000005 | forecast_horizon_hours | Forecast horizon in 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-ent3-000000000005 | null | null | DATETIME | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-a305-000000000004 | forecast_datetime | Forecast target 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-ent3-000000000005 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-a305-000000000003 | grid_zone | Grid zone for aggregated forecast | 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-ent3-000000000005 | null | null | STRING | null | null | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-a305-000000000002 | consumer_id | Consumer reference (optional for aggregated forecasts) | 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-ent3-000000000005 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-a305-000000000001 | forecast_id | Unique forecast 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-ent3-000000000004 | null | null | DATETIME | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-enrg-a304-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-ent3-000000000004 | null | null | STRING | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-enrg-a304-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-ent3-000000000004 | null | null | DECIMAL | null | null | null | null | null | 9 | 4 | null | null | null | null | null | 00000000-demo-enrg-a304-000000000010 | power_factor | Power factor (0-1) | 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-ent3-000000000004 | null | null | DECIMAL | null | null | null | null | null | 8 | 3 | null | null | null | null | null | 00000000-demo-enrg-a304-000000000009 | current_a | Current (A) | 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-ent3-000000000004 | null | null | DECIMAL | null | null | null | null | null | 7 | 2 | null | null | null | null | null | 00000000-demo-enrg-a304-000000000008 | voltage_v | Voltage (V) | 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-ent3-000000000004 | null | null | DECIMAL | null | null | null | null | null | 6 | 3 | null | null | null | null | null | 00000000-demo-enrg-a304-000000000007 | reactive_power_kvar | Reactive power (kVAr) | 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-ent3-000000000004 | null | null | DECIMAL | null | null | null | null | null | 5 | 3 | null | null | null | null | null | 00000000-demo-enrg-a304-000000000006 | power_kw | Average power (kW) | 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-ent3-000000000004 | null | null | DECIMAL | null | null | null | null | null | 4 | 3 | null | null | null | null | null | 00000000-demo-enrg-a304-000000000005 | consumption_kwh | Energy consumption (kWh) | 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-ent3-000000000004 | null | null | INTEGER | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-a304-000000000004 | interval_minutes | Reading 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-ent3-000000000004 | null | null | DATETIME | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-a304-000000000003 | reading_datetime | Reading 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-ent3-000000000004 | null | null | STRING | null | null | UUID | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-a304-000000000002 | meter_point_id | Meter point 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-ent3-000000000004 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-a304-000000000001 | reading_id | Unique reading 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-ent3-000000000003 | null | null | DATETIME | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-enrg-a303-000000000013 | 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-ent3-000000000003 | null | null | DATETIME | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-enrg-a303-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-ent3-000000000003 | null | null | STRING | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-enrg-a303-000000000011 | status | Meter status (active, inactive, faulty) | 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-ent3-000000000003 | null | null | DATE | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-enrg-a303-000000000010 | last_read_date | Last successful reading 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-ent3-000000000003 | null | null | DATE | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-enrg-a303-000000000009 | installation_date | Meter 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-ent3-000000000003 | null | null | DECIMAL | null | null | LONGITUDE | null | null | 7 | null | null | null | null | null | null | 00000000-demo-enrg-a303-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-ent3-000000000003 | null | null | DECIMAL | null | null | LATITUDE | null | null | 6 | null | null | null | null | null | null | 00000000-demo-enrg-a303-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-ent3-000000000003 | null | null | STRING | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-enrg-a303-000000000006 | location_description | Physical location 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-ent3-000000000003 | null | null | STRING | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-enrg-a303-000000000005 | communication_type | Communication type (cellular, RF, PLC) | 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-ent3-000000000003 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-a303-000000000004 | meter_type | Meter type (smart, AMR, analog) | 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-ent3-000000000003 | null | null | STRING | null | null | UUID | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-a303-000000000003 | consumer_id | Consumer 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-ent3-000000000003 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-a303-000000000002 | mpan_code | Meter Point Administration Number (MPAN) | 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-ent3-000000000003 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-a303-000000000001 | meter_point_id | Unique meter point 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-ent3-000000000002 | null | null | BOOLEAN | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-enrg-a302-000000000008 | is_residential | Residential category 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-ent3-000000000002 | null | null | BOOLEAN | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-enrg-a302-000000000007 | is_commercial | Commercial category 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-ent3-000000000002 | null | null | BOOLEAN | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-enrg-a302-000000000006 | is_industrial | Industrial category 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-ent3-000000000002 | null | null | DECIMAL | null | null | null | null | null | 4 | 4 | null | null | null | null | null | 00000000-demo-enrg-a302-000000000005 | typical_load_factor | Typical load factor (0-1) | 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-ent3-000000000002 | null | null | STRING | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-a302-000000000004 | description | Category 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-ent3-000000000002 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-a302-000000000003 | name | Category 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-ent3-000000000002 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-a302-000000000002 | code | Category 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-ent3-000000000002 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-a302-000000000001 | category_id | Unique category 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-ent3-000000000001 | null | null | DATETIME | null | null | null | null | null | 17 | null | null | null | null | null | null | 00000000-demo-enrg-a301-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-ent3-000000000001 | null | null | DATETIME | null | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-enrg-a301-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-ent3-000000000001 | null | null | STRING | null | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-enrg-a301-000000000016 | status | Consumer status (active, suspended, disconnected) | 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-ent3-000000000001 | null | null | DATE | null | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-enrg-a301-000000000015 | connection_date | Date of grid connection | 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-ent3-000000000001 | null | null | DECIMAL | null | null | null | null | null | 13 | 3 | null | null | null | null | null | 00000000-demo-enrg-a301-000000000014 | contract_power_kw | Contracted power capacity (kW) | 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-ent3-000000000001 | null | null | STRING | null | null | UUID | null | null | 12 | null | null | null | null | null | null | 00000000-demo-enrg-a301-000000000013 | tariff_id | Current tariff reference | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:38 | 2026-01-03 15:16:38 | 1 |