MATCH(MatchID, Season, MatchDate, MatchStartTime, Field#, Park, HomeTeamID, AwayTeamID, RefereeName, MatchScore)
FIELD(Field#, Park, FieldName)
PLAYER(PlayerID, JerseyNumber, PlayerFirstName, PlayerLastName, PlayerGender, PlayerAge, TeamID, Position, CaptainStatus)
PLAYERSTATS(MatchID, PlayerID, MatchDate, MatchStartTime, HomeTeamName, AwayTeamName, JerseyNumber, PlayerName, Goals, Assists, PossessionPercent, PassCount, PassingChain#)
TEAM(TeamID, TeamName, CoachID, AssistantCoachID, SponsorID)
COACH(CoachID, CoachFirstName, CoachLastName, TeamID, CoachAge, CoachGender, CoachRole)
SPONSOR(SponsorID, SponsorName, SponsorEmail, SponsorAddress)
submitted by /u/volkxx
[link] [comments]