test

Tables (5)

daily_weather

  • daily_weather_id — INT
  • location_id — INT — NOT NULL
  • forecast_date — DATE — NOT NULL
  • min_temp — DECIMAL(5, 2)
  • max_temp — DECIMAL(5, 2)
  • morning_condition_id — INT
  • afternoon_condition_id — INT
  • morning_humidity — INT
  • afternoon_humidity — INT
  • uv_index — DECIMAL(4, 2)
  • sunrise_time — TIME
  • created_at — TIMESTAMP

hourly_weather

  • hourly_weather_id — INT
  • location_id — INT — NOT NULL
  • forecast_datetime — DATETIME — NOT NULL
  • temperature — DECIMAL(5, 2)
  • feels_like — DECIMAL(5, 2)
  • humidity — INT
  • condition_id — INT
  • wind_direction — VARCHAR(10)
  • wind_speed — DECIMAL(5, 2)
  • fine_dust — INT
  • ultra_fine_dust — INT
  • created_at — TIMESTAMP

location_pins

  • pin_id — INT
  • location_id — INT — NOT NULL
  • is_pinned — BOOLEAN
  • created_at — TIMESTAMP

locations

  • location_id — INT
  • name — VARCHAR(100) — NOT NULL
  • latitude — DECIMAL(10, 8) — NOT NULL
  • longitude — DECIMAL(11, 8) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

weather_conditions

  • condition_id — INT
  • condition_name — VARCHAR(50) — NOT NULL
  • icon_path — VARCHAR(255)
  • description — TEXT