'Table relationship problem for an competition program (tennis/Padel)
I am trying to make a my first relationally table structure for a tennis/Padel competition program that registers the scores (sets.)of dubbel matches(4players). And I don’t know how I should register it in the right way, how many tables I should have and how I should register it. I have for the moment three tables: Players, score and contest.
The player table exists with following fields: Playerid,firstname, lastname
The score table exist of: ScoreId,set1gameswon,set1gameslost,set2gameswon,set2gameslost
The Contest Table exist of: Contestid,scoreid,player1,player2,player3,player 4 and datecontest
My problem is now that the score for the winners is 6/4 and 6/3 for example but the losers should have the opposite score 4/6 and 3/6 And I don’t know how too fix that?
Thank u in advance.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|