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-000000000001 | null | null | DECIMAL | null | null | null | null | null | 6 | 4 | null | null | null | null | null | 00000000-demo-enrg-a101-000000000007 | capacity_factor | Average capacity utilization (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-000000000001 | null | null | DECIMAL | null | null | null | null | null | 5 | 3 | null | null | null | null | null | 00000000-demo-enrg-a101-000000000006 | available_capacity_mw | Currently available capacity | 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-000000000001 | null | null | DECIMAL | null | null | null | null | null | 4 | 3 | null | null | null | null | null | 00000000-demo-enrg-a101-000000000005 | installed_capacity_mw | Installed 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-ent1-000000000001 | null | null | STRING | null | null | UUID | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-a101-000000000004 | energy_source_id | Primary energy source 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-000000000001 | null | null | STRING | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-a101-000000000003 | name | Plant 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-ent1-000000000001 | null | null | STRING | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-a101-000000000002 | plant_code | Industry standard plant 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-ent1-000000000001 | null | null | STRING | null | null | UUID | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-a101-000000000001 | plant_id | Unique power plant 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-phys-000000000006 | null | null | DECIMAL | null | null | null | null | null | 9 | 2 | null | null | null | null | null | 00000000-demo-enrg-p006-000000000010 | RENEWABLE_SHARE_PERCENT | Renewable energy share 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-phys-000000000006 | null | null | DECIMAL | null | null | null | null | null | 8 | 2 | null | null | null | null | null | 00000000-demo-enrg-p006-000000000009 | INTENSITY_G_CO2_KWH | Carbon intensity (grams CO2 per kWh) | 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-phys-000000000006 | null | null | DECIMAL | null | null | null | null | null | 7 | 4 | null | null | null | null | null | 00000000-demo-enrg-p006-000000000008 | GENERATION_MWH | Associated generation in 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-phys-000000000006 | null | null | DECIMAL | null | null | null | null | null | 6 | 4 | null | null | null | null | null | 00000000-demo-enrg-p006-000000000007 | SO2_KG | SO2 emissions in kilograms | 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-phys-000000000006 | null | null | DECIMAL | null | null | null | null | null | 5 | 4 | null | null | null | null | null | 00000000-demo-enrg-p006-000000000006 | NOX_KG | NOx emissions in kilograms | 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-phys-000000000006 | null | null | DECIMAL | null | null | null | null | null | 4 | 6 | null | null | null | null | null | 00000000-demo-enrg-p006-000000000005 | CO2_TONNES | CO2 emissions in metric tonnes | 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-phys-000000000006 | null | null | INTEGER | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-p006-000000000004 | ENERGY_SOURCE_SK | Energy source dimension key | 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-phys-000000000006 | null | null | STRING | BIGINT | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-p006-000000000003 | TIME_SK | Time dimension key | 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-phys-000000000006 | null | null | INTEGER | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-p006-000000000002 | FACILITY_SK | Facility dimension key | 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-phys-000000000006 | null | null | STRING | BIGINT | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-p006-000000000001 | EMISSIONS_FACT_SK | Surrogate key | 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-phys-000000000005 | null | null | DECIMAL | null | null | null | null | null | 10 | 2 | null | null | null | null | null | 00000000-demo-enrg-p005-000000000011 | COST_USD | Total cost in USD | 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-phys-000000000005 | null | null | DECIMAL | null | null | null | null | null | 9 | 6 | null | null | null | null | null | 00000000-demo-enrg-p005-000000000010 | UNIT_RATE | Unit rate (USD per kWh) | 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-phys-000000000005 | null | null | STRING | VARCHAR | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-enrg-p005-000000000009 | TARIFF_TYPE | Tariff type (Residential, Commercial, Industrial) | 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-phys-000000000005 | null | null | DECIMAL | null | null | null | null | null | 7 | 4 | null | null | null | null | null | 00000000-demo-enrg-p005-000000000008 | POWER_FACTOR | Power factor (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-phys-000000000005 | null | null | DECIMAL | null | null | null | null | null | 6 | 4 | null | null | null | null | null | 00000000-demo-enrg-p005-000000000007 | REACTIVE_POWER_KVAR | Reactive power in kilovolt-amperes reactive | 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-phys-000000000005 | null | null | DECIMAL | null | null | null | null | null | 5 | 4 | null | null | null | null | null | 00000000-demo-enrg-p005-000000000006 | POWER_KW | Instantaneous power in kilowatts | 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-phys-000000000005 | null | null | DECIMAL | null | null | null | null | null | 4 | 4 | null | null | null | null | null | 00000000-demo-enrg-p005-000000000005 | CONSUMPTION_KWH | Energy consumed in kilowatt-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-phys-000000000005 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-p005-000000000004 | METER_POINT_BK | Meter point business key | 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-phys-000000000005 | null | null | STRING | BIGINT | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-p005-000000000003 | TIME_SK | Time dimension key | 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-phys-000000000005 | null | null | INTEGER | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-p005-000000000002 | CONSUMER_SK | Consumer dimension key | 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-phys-000000000005 | null | null | STRING | BIGINT | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-p005-000000000001 | CONSUMPTION_FACT_SK | Surrogate key | 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-phys-000000000004 | null | null | DECIMAL | null | null | null | null | null | 11 | 2 | null | null | null | null | null | 00000000-demo-enrg-p004-000000000012 | FORECAST_ERROR_PERCENT | Forecast error 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-phys-000000000004 | null | null | DECIMAL | null | null | null | null | null | 10 | 4 | null | null | null | null | null | 00000000-demo-enrg-p004-000000000011 | FORECAST_MWH | Forecasted generation in 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-phys-000000000004 | null | null | DECIMAL | null | null | null | null | null | 9 | 4 | null | null | null | null | null | 00000000-demo-enrg-p004-000000000010 | CURTAILMENT_MWH | Curtailed energy in 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-phys-000000000004 | null | null | DECIMAL | null | null | null | null | null | 8 | 2 | null | null | null | null | null | 00000000-demo-enrg-p004-000000000009 | AVAILABILITY_PERCENT | Facility availability 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-phys-000000000004 | null | null | DECIMAL | null | null | null | null | null | 7 | 6 | null | null | null | null | null | 00000000-demo-enrg-p004-000000000008 | CAPACITY_FACTOR | Capacity factor for interval (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-phys-000000000004 | null | null | DECIMAL | null | null | null | null | null | 6 | 4 | null | null | null | null | null | 00000000-demo-enrg-p004-000000000007 | POWER_MW | Instantaneous power 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-phys-000000000004 | null | null | DECIMAL | null | null | null | null | null | 5 | 4 | null | null | null | null | null | 00000000-demo-enrg-p004-000000000006 | GENERATION_MWH | Energy generated 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-phys-000000000004 | null | null | STRING | VARCHAR | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-enrg-p004-000000000005 | PRODUCTION_BK | Production business key | 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-phys-000000000004 | null | null | STRING | BIGINT | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-enrg-p004-000000000004 | TIME_SK | Time dimension key | 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-phys-000000000004 | null | null | INTEGER | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-enrg-p004-000000000003 | ENERGY_SOURCE_SK | Energy source dimension key | 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-phys-000000000004 | null | null | INTEGER | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-enrg-p004-000000000002 | FACILITY_SK | Facility dimension key | 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-phys-000000000004 | null | null | STRING | BIGINT | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-enrg-p004-000000000001 | PRODUCTION_FACT_SK | Surrogate key | 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-phys-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-enrg-p003-000000000017 | SEASON | Season (Winter, Spring, Summer, Fall) | 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-phys-000000000003 | null | null | CHAR | null | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-enrg-p003-000000000016 | YEAR_MONTH | Year-Month (YYYY-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-phys-000000000003 | null | null | INTEGER | null | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-enrg-p003-000000000015 | YEAR | Year | 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-phys-000000000003 | null | null | INTEGER | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-enrg-p003-000000000014 | QUARTER | Quarter (1-4) | 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-phys-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-enrg-p003-000000000013 | MONTH_NAME | Month 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-phys-000000000003 | null | null | INTEGER | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-enrg-p003-000000000012 | MONTH_NUMBER | Month number | 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-phys-000000000003 | null | null | BOOLEAN | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-enrg-p003-000000000011 | IS_BUSINESS_DAY | Business day 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-phys-000000000003 | null | null | BOOLEAN | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-enrg-p003-000000000010 | IS_PEAK_HOUR | Peak hour flag (typically 9-20) | 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-phys-000000000003 | null | null | BOOLEAN | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-enrg-p003-000000000009 | IS_WEEKEND | Weekend 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-phys-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-enrg-p003-000000000008 | DAY_NAME | Day name | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 |