Footballay Refactoring

Tables (17)

ApiSportsMatchEvent (Match Event)

  • 아이디 (id) — Primary key — NOT NULL
  • 경기아이디 (fixture_apisports_id) — Foreign key → FixtureApiSports.아이디 — NOT NULL
  • 매치팀아이디 (match_team_id) — Foreign key → ApiSportsMatchTeam.아이디 — NOT NULL
  • 매치선수아이디 (match_player_id) — Foreign key → ApiSportsMatchPlayer.아이디 — NOT NULL
  • 매치도움선수아이디 (match_assist_id) — Foreign key → ApiSportsMatchPlayer.아이디 — NOT NULL
  • 순서 (sequence)

ApiSportsMatchPlayer (Match Player)

  • 아이디 (id) — Primary key — NOT NULL
  • 매치팀아이디 (match_team_id) — Foreign key → ApiSportsMatchTeam.아이디 — NOT NULL
  • api선수아이디 (player_apisports_id) — Foreign key → PlayerApiSports.아이디 — NOT NULL
  • 선발여부 (is_starting)

ApiSportsMatchPlayerStatistics (Match Player Stats)

  • 아이디 (id) — Primary key — NOT NULL
  • 공통매치선수아이디 (match_player_id) — Foreign key → ApiSportsMatchPlayer.아이디 — NOT NULL
  • 통계필드들 (field...)

ApiSportsMatchTeam (Match Team)

  • 아이디 (id) — Primary key — NOT NULL
  • api팀아이디 (team_apisports_id) — Foreign key → TeamApiSports.아이디 — NOT NULL

ApiSportsMatchTeamStatistics (Match Team Stats)

  • 아이디 (id) — Primary key — NOT NULL
  • 매치팀아이디 (match_team_id) — Foreign key → ApiSportsMatchTeam.아이디 — NOT NULL

FixtureApiSports (Provider Fixture)

  • 아이디 (id) — Primary key — NOT NULL
  • 코어 경기 아이디 (fixture_core_id) — Foreign key → FixtureCore.아이디 — NOT NULL
  • 홈 팀 아이디 (home_team_id) — Foreign key → ApiSportsMatchTeam.아이디 — NOT NULL
  • 어웨이 팀 아이디 (away_team_id) — Foreign key → ApiSportsMatchTeam.아이디 — NOT NULL
  • API 아이디 (api_id)

FixtureCore (Fixture)

  • 아이디 (id) — Primary key — NOT NULL
  • 리그아이디 (league_id) — Foreign key → LeagueCore.아이디 — NOT NULL
  • 홈팀아이디 (home_team_id) — Foreign key → TeamCore.아이디 — NOT NULL
  • 어웨이팀아이디 (away_team_id) — Foreign key → TeamCore.아이디 — NOT NULL
  • 시작시간 (kickoff)

LeagueApiSports (Provider League)

  • 아이디 (id) — Primary key — NOT NULL
  • 공통리그아이디 (league_id) — Foreign key → LeagueCore.아이디 — NOT NULL
  • oneApi에서제공되는값 (fields...)

LeagueApiSportsSeason (Provider Season)

  • 아이디 (id) — Primary key — NOT NULL
  • ApiSports리그아이디 (league_apisports_id) — Foreign key → LeagueApiSports.아이디 — NOT NULL
  • 시즌 년도 (season_year)
  • 시즌 시작일 (season_start)
  • 시즌 종료일 (season_end)
  • 리그 시즌 커버리지 (coverage)

LeagueCore (League)

  • 아이디 (id) — Primary key — NOT NULL
  • 이름 (name)

LeagueTeamCore (LeagueTeam)

  • 리그아이디 (league_id) — Foreign key → LeagueCore.아이디 — NOT NULL
  • 팀아이디 (team_id) — Foreign key → TeamCore.아이디 — NOT NULL

PlayerApiSports (Provider Player)

  • 아이디 (id) — Primary key — NOT NULL
  • 공통선수아이디 (player_id) — Foreign key → PlayerCore.아이디 — NOT NULL
  • oneApi에서제공되는값 (field...)

PlayerCore (Player)

  • 아이디 (id) — Primary key — NOT NULL
  • 이름 (name)

TeamApiSports (Provider Team)

  • 아이디 (id) — Primary key — NOT NULL
  • 공통팀아이디 (team_id) — Foreign key → TeamCore.아이디 — NOT NULL
  • 팀필드 (field...)

TeamCore (Team)

  • 아이디 (id) — Primary key — NOT NULL
  • 이름 (name)

TeamPlayerCore (TeamPlayer)

  • 팀아이디 (team_id) — Foreign key → TeamCore.아이디 — NOT NULL
  • 선수아이디 (player_id) — Foreign key → PlayerCore.아이디 — NOT NULL

VenueApiSports (Provider Venue)

  • 아이디 (id) — Primary key — NOT NULL
  • 경기 아이디 (fixture_apisports_id) — Foreign key → FixtureApiSports.아이디 — NOT NULL
  • 팀 아이디 (team_apisports_id) — Foreign key → TeamApiSports.아이디 — NOT NULL