KBOWEATHER
Tables (4)
game (경기)
- id (Key) — BigInt — Primary key — NOT NULL
- game_date (Field) — Date
- game_time (Field2) — Time
- home_score (Field3) — Int — NOT NULL
- away_score (Field4) — Int — NOT NULL
- status (Field5) — Varchar(20)
- stadium_id (Key2) — BigInt — Foreign key → stadium.id — NOT NULL
- away_team_id (Key3) — BigInt — Foreign key → team.id — NOT NULL
- home_team_id (Key4) — BigInt — Foreign key → team.id — NOT NULL
stadium (구장)
- id (Key) — BigInt — Primary key — NOT NULL
- name (Field) — Varchar(50)
- city (Field2) — Varchar(20)
- latitude (Field3) — Double
- longitude (Field4) — Double
- weather_nx (Field5) — Int
- weather_ny (Field6) — Int
team (구단)
- id (Key) — BigInt — Primary key — NOT NULL
- name (Field) — Varchar(50)
- short_name (Field2) — Varchar(10)
team_stadium (팀-구장)
- id (Key) — BigInt — Primary key — NOT NULL
- stadium_id (Key2) — BigInt — Foreign key → stadium.id — NOT NULL
- team_id (Key3) — BigInt — Foreign key → team.id — NOT NULL
- stadium (Field) — VARCHAR(20)