Quote:
Originally Posted by Furface  Again, out of interest a) how do other clubs do this and b) do other clubs keep separate FITA age-band records? |
The club I designed this follows the records allowed at national level for simplicity and validity, prevents arguments and stops silly records being claimed by adults or younger juniors (and that includes finals total and match rounds).
As national level doesn't have separate records for FITA groups (although the small print in archery UK said they should IIRC) neither does the club.
For my database it isn't a complexity too far, as the fields are present and it would be easy to pull them out (easier still if all FITA shoots put it on the results sheets if the rounds were shot by juniors, cadet or masters as the ones organised by
GNAS do) ie in this case I've remembered to think about it so the problem is in data availability not in design. I don't want to store date of birth in the database which would solve many many problems because I think that info is a bit too personal and carries more risks.