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