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