WeatherDB

Tables (3)

area (지역)

  • district_ID (PK) — VACHAR(20) — Primary key — NOT NULL
  • district_name_step1 (Field1) — VACHAR(20) — NOT NULL
  • district_name_step2 (Field2) — VACHAR(10)
  • district_name_step3 (Field3) — VACHAR(10)
  • NY (Field4) — int — NOT NULL
  • NX (Field5) — int — NOT NULL
  • X (Field6) — decimal(16,14) — NOT NULL
  • Y (Field7) — decimal(17,14) — NOT NULL

fcast_weather (예보날씨)

  • district_ID (pk) — VACHAR(20) — Primary key — NOT NULL
  • fcastTime (PK) — VACHAR(10) — Primary key — NOT NULL
  • fcastDate (Pk) — VACHAR(10) — Primary key — NOT NULL
  • T3H (Field) — int
  • SKY (field) — int

now_weather (현재날씨)

  • district_ID (pk) — VACHAR(20) — Primary key — NOT NULL
  • baseTime (PK) — VACHAR(10) — Primary key — NOT NULL
  • baseDate (Pk) — VACHAR(10) — Primary key — NOT NULL
  • SKY (Field) — int
  • T1H (field) — int