야구장 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