야구장 DB 다이어그램

테이블 (7)

Table (미세먼지)

  • pm10 (Field) — int
  • stn (Field2) — int
  • date (Field3) — timestamp witout timezone

Table (경기장 위치)

  • id (key) — int — 기본 키 — NOT NULL
  • name (Field2) — varchar
  • longitude (Field3) — float
  • latitude (Field4) — float

경기 일정 (kbo_game_schedule)

  • date (Field) — string
  • time (Field2) — string
  • formatted_teams (Field3) — string
  • stadium (Field4) — string
  • today (Field5) — string
  • formatted_date (Field6) — string

고척 (gocheog)

  • temperature (Field1) — int
  • wind_speed (Field2) — float
  • precipitation_probability (Field3) — int
  • precipitation (Field4) — int
  • timestamp (Field5) — timestamp

문학 (munhak)

  • temperature (Field1) — int
  • wind_speed (Field2) — float
  • precipitation_probability (Field3) — int
  • precipitation (Field4) — int
  • timestamp (Field5) — timestamp

수원 (suwon)

  • temperature (Field1) — int
  • wind_speed (Field2) — float
  • precipitation_probability (Field3) — int
  • precipitation (Field4) — int
  • timestamp (Field5) — timestamp

잠실 (Jamsil)

  • temperature (Field1) — int
  • wind_speed (Field2) — float
  • precipitation_probability (Field3) — int
  • precipitation (Field4) — int
  • timestamp (Field5) — timestamp