Forum Discussion
How to model soccer data ?
Hi all, I've got a short data modeling questions for a soccer dataset. Tables look like this: Matches: matchID | homeID | awayID | ... Teams: teamID | Name | ... Events: eventID | matc...
Hi Nico,
Can you share the three Tables please!
Thanks for the quick reply. I don't have the real data with me because I'm on the go. but basically it's like this:
Hi nwrozyna
You should have another table with the PlayerID, PlayerName and PlayerTeam. Like Salah is a Liverpool Player or Sterling is Man City...
Then in event Table you would add a Column for Event name like (Yellow Card, Red Card,Goal,Sub...) and another column with the name of the player or even better his ID.
I am sure these infos are available somewhere in Google.
Good luck
