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