mise_db
Tables (4)
recommend_behavior (추천 행동)
- all_air_grade (Key) — Primary key — NOT NULL
- bh_name (Field) — varchar(20)
- bh_amount (Field2) — int(3)
station_air_rmtm (측정소별 대기정보)
- station_num (Field15) — autoincrement — Foreign key → station_info.station_num
- station_location (Key3) — Foreign key → station_info.station_location — NOT NULL
- all_air_grade (Key) — Foreign key → recommend_behavior.all_air_grade — NOT NULL
- so2 (Field4) — int(5)
- co (Field3) — int(5)
- o3 (Field) — int(5)
- no2 (Field2) — int(5)
- pm10 (Field6) — int(5)
- pm25 (Field5) — int(5)
- all_air (Field7) — int(5)
- so2_grade (Field11)
- co_grade (Field10)
- o3_grade (Field8)
- no2_grade (Field9)
- pm10_grade (Field13)
- pm25_grade (Field12)
- update_time (Field22) — DATE
station_air_tm_af (내일모레 측정소 대기정보)
- station_location (Key) — Primary key — NOT NULL
- grade_tm (Field2) — tinyint
- grade_af (Field3) — tinyint
- update_time (Field) — DATE
station_info (측정소 정보)
- station_num (Field) — autoincrement — Primary key
- station_location (Key3) — Foreign key → station_air_tm_af.station_location — NOT NULL
- station_X (Field2) — float
- station_Y (Field3) — float
- station_name (Key) — varchar(20) — NOT NULL