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