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)