SolPro
Tables (3)
Predictions (예측 데이터)
- prediction_id (Key) — INT PK AUTO_INCREMENT — Primary key — NOT NULL
- plant_id (Key2) — INT — Primary key — NOT NULL
- prediction_type (Field) — VARCHAR(20)
- start_time (Field2) — DATETIME
- end_time (Field3) — DATETIME
- predicted_kwh (Field4) — FLOAT
- model_version (Field5) — VARCHAR(20)
- created_at (Field6) — DATETIME
SolarProduction (태양광 발전량)
- production_id (Key) — INT PK AUTO_INCREMENT — Primary key — NOT NULL
- plant_id (Key2) — INT — Primary key — NOT NULL
- timestamp (Field) — DATETIME
- actual_kwh (Field2) — FLOAT
- created_at (Field3) — DATETIME
WeatherData (기상 데이터)
- weather_id (Key) — INT PK AUTO_INCREMENT — Primary key — NOT NULL
- plant_id (Key2) — INT — Primary key — NOT NULL
- timestamp (Field) — DATETIME
- wind_speed (Field2) — FLOAT
- humidity (Field3) — FLOAT
- pressire (Field4) — FLOAT
- solar_radiation (Field5) — FLOAT
- sunshine (Field6) — FLOAT
- cloud_cover (Field7) — FLOAT
- created_at (Field8) — DATETIME