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