I'm developing a project about little soccer league. I need to store teams, team's players, matches info (which are two teams involved in the match), events (various events happened douring a single match - goal, penalty, red card, yellow card etc etc-)
This is the DB realized (only PK and FK are shown): http://www.freeimgshost.com/viewer.php?file=pi93lbvdrje2iup9cw8.jpg What do you think? Is designed correctly. It seems correct my question is about naming convention. I'm pretty confused about name: teams_matches (better matches_teams I suppose), players_teams_matches (better matches_teams_players), and events are these correct??? What about teams_match_id foreign key? How many models I need to create? Best regards -- 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 [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
