|
Hello all,
I want to make a mysql db for my team, but i dont know how to put the scoring results in there.
I allready got:
ID
schooter
Adres
and more schooter info (as e-mail tel and so on)
Where the problem is:
We shoot different games in a year. But i want to get all scores of all years in the db.
for example:
Wintergames are 6 matches (over 25 arrows in 1 game)
Summer games are 9 matches and a finall (over 25 arrows in 1 game)
King games is 1 game (over 32 arrows)
Indoor games 7 matches (30 arrows over 1 game)
Field matches 1 game at a time (72 arrows)
Other matcges (name have to be fild in arrow amounth has to be fild in and sore has te be fild in)
In this over 10 years of scores.
Can anyone help me how this is best designed? Everything else i will find out myself.
|