I am making a data base (for uni) and we’ll it’s schema is this:<\/p>\n
I need data for this and I reaaally don’t quite know where to get the specific shmuck that I need.<\/p>\n
Tournaments<\/p>\n
TournamentID (Primary Key) TournamentName TournamentYear TournamentCountry TournamentType TournamentFormat TournamentPrizeMoney <\/p>\n
Leagues<\/p>\n
LeagueID (Primary Key) LeagueName LeagueCountry LeagueWebsite LeagueSponsor LeaguePromotion LeagueRelegation <\/p>\n
Teams<\/p>\n
TeamID (Primary Key) TeamName TeamCity TeamCountry TeamLogo TeamFounded TeamStadium TeamCaptain LeagueID (Foreign Key) <\/p>\n
Players<\/p>\n
PlayerID (Primary Key) PlayerName PlayerAge PlayerNationality PlayerHeight PlayerWeight PlayerMarketValue PlayerPosition TeamID (Foreign Key) <\/p>\n
Stadiums<\/p>\n
StadiumID (Primary Key) StadiumName StadiumCity StadiumCountry StadiumAddress StadiumSurface StadiumRoof StadiumCapacity <\/p>\n
Matches<\/p>\n
MatchID (Primary Key) HomeTeamID (Foreign Key) AwayTeamID (Foreign Key) MatchDate MatchTime MatchReferee MatchAttendance MatchWeather HomeTeamScore AwayTeamScore TournamentID (Foreign Key) StadiumID (Foreign Key) <\/p>\n
PlayerMatches<\/p>\n
PlayerMatchID (Primary Key) PlayerID (Foreign Key) MatchID (Foreign Key) MinutesPlayed GoalsScored Assists ShotsOnTarget ShotsOffTarget Saves Tackles PassesCompleted YellowCards RedCards PlayerRating PlayerManOfTheMatch PlayerSubstitute <\/p><\/div>\n
submitted by \/u\/No_Secretary1128 <\/a>
[link]<\/a><\/span> [comments]<\/a><\/span><\/p>
