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