09-01-2014, 01:06 AM
[eluser]Flemming[/eluser]
First of all, I think you have too many tables. What is the benefit of storing match data and result data in separate tables? Every match will have a result, so you could store hometeam_goals, awayteam_goals and overtime in the matches table.
This will make for simpler queries to create your league table.
I may be wrong though, I haven't spent long thinking about this! :-)
First of all, I think you have too many tables. What is the benefit of storing match data and result data in separate tables? Every match will have a result, so you could store hometeam_goals, awayteam_goals and overtime in the matches table.
This will make for simpler queries to create your league table.
I may be wrong though, I haven't spent long thinking about this! :-)
