WeatherDB - 2020-07-14 04:50:37

Tables (3)

area (지역)

  • district_ID (PK) — int — Primary key — NOT NULL
  • district_name (Field1) — varchar(20) — NOT NULL
  • NY (Field2) — int — NOT NULL
  • NX (Field3) — int — NOT NULL
  • X (Field4) — int — NOT NULL
  • Y (Field5) — int — NOT NULL

fcast_weather (예보날씨)

  • fcast_num (PK) — int — Primary key — NOT NULL — district_ID+fcastTime+fcastDate
  • district_ID (FK) — int — Foreign key — NOT NULL
  • fcastTime (Field1) — int — NOT NULL
  • fcastDate (Field2) — int — NOT NULL
  • daseTime (Field3) — int — NOT NULL
  • daseDate (Field4) — int — NOT NULL
  • T3H (Field5) — int — NOT NULL
  • SKY (Field6) — int — NOT NULL

now_weather (현재날씨)

  • now_num (PK) — int — Primary key — NOT NULL — district_ID+baseTime+baseDate
  • district_ID (FK) — int — Foreign key — NOT NULL
  • baseTime (Field1) — int — NOT NULL
  • baseDate (Field2) — int — NOT NULL
  • SKY (Field4) — int — NOT NULL
  • T1H (Field5) — int — NOT NULL