Match scores entering

Ok, this is an interesting process. Since it has been bugging me while i was writing down the code for viewing the matches. There is a point when the match completes. And when this happends the match results needs to be entered in right? Ok.. then comes the pop quiz question:

- Who enters the scores?
- How is this process done?
- is there any role from the admin point of view?

To get answers to these questions, I asked around about how other systems work with this process. And personally I think I understand now where to take this all... Let me write it all down in the next few segments while it is still fresh on my mind:

- The match scores get entered by either one of the 2 team captains
- A match score gets accepted withing 2 hours time
- if the other side does not agree with the scores, they file a complaint towards the admins (dispute).
- If they accept the match results they can simply say "accept"

So this whole process leads into a new section i need to add inside the whole match system. Next to accepting matches, I need to have a field called "accept results". And this needs to be saved for both team 1 and team 2.

If team 1 enters the scores the flag for accepted team 1 will automaticly be set to true.

If one of these 2 fields is set to true, and nothing has happened in the next 2 hours, the match will automaticly be flagged for completed. This also needs to be a seperate field

Next interesting point is "rescheduling a match". This can happen when something goes terribly wrong during the match or it just did not really work out for both teams (eg: too little players, no one showed up etc).

To make this workable there needs to be 2 additional fields for the match which is called rejected team1, and rejected team2.

To be honest, I am beginning to wonder if I shouldn't just seperate the whole match thing into 2 tables. One for the match, and one for the entered data (flags) by the teams. Since from a 'retrieval' point of view it gets pretty messy when they are spread over more then one field.

So more like:

Match, data

Match, Side, Team, Accepted, Reschedule, Score etc

Somewhere in that direction. I just need to think this one really through if I am gonna this or not. Since it requires some changes inside the entermatch/ view match scripts.

Ah well.. I need to edit them anyways.