bisol weather
Tables (3)
weather_condition
- icon_code — VARCHAR2(12) — Primary key — PK
- state_ko — VARCHAR2(40) — NOT NULL
- group_code — VARCHAR2(20) — NOT NULL
- icon_hint — VARCHAR2(120)
weather_daily
- Key — NUMBER — Primary key — NOT NULL
- location_id (location_id2) — NUMBER — Foreign key → weather_location.location_id — PK
- icon_code (icon_code2) — VARCHAR2(12) — Foreign key → weather_condition.icon_code — PK
- location_id — NUMBER — NOT NULL
- forecast_date — DATE — NOT NULL
- icon_code — VARCHAR2(12) — NOT NULL
- temp_c — NUMBER(4,1) — NOT NULL
- temp_min_c — NUMBER(4,1)
- temp_max_c — NUMBER(4,1)
- precip_prob_pct — NUMBER(3) — NOT NULL
- source_name — VARCHAR2(40)
- source_updated_at — TIMESTAMP
- ingested_at — TIMESTAMP
weather_location
- location_id — NUMBER — Primary key — PK
- name — VARCHAR2(80) — NOT NULL
- country_code — VARCHAR2(2)
- timezone_id — VARCHAR2(60)
- created_at — TIMESTAMP