Model for competition

Hi every one,
I am working in a project, that is basicaly, a competition manager,
where organizers can register, and then have access to those things:
- Include Teams from a database
- Register new teams in database
- View only the events created by himself
- Include in each event, criteria, like: Project score, Building
score, Practice score...

Judges, would have access to:
- Post scores to the existing criteria created by the organizer
- Give comments to the teams, so that a team can have many comments in
one participating event

Scores would never be deleted, the "right" one would be the newer one

After doing that i want to make something like this:
Judge can only give scores to the criteria set to it`s user, so a
Project judge, can only give scores to the Project score.(don`t know
how to make that in db)

The thing, is that each event has many criterias, and that each
criteria have many scores with its type, but they are also linked with
the teams participating in the event. I`m VERY confused at this..
Here is what i have done, with the database in MySQL Workbench:
http://cl.ly/2r3F25232u1d303x2D2u

I apreciate, if anyone could tell me, if i`m in the right direction,
and if not, what can i do to make it work good.

Thanks everyone,
Ivan

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php