On Mar 19, 4:52 pm, "Mariano C." <[email protected]> wrote: > 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
I waited 60s for an image which didn't appear before concluding you've chosen the worst possible place to put what is essentially textual information (your db schema). TIp: if you want people to help you make it EASY for them to do so. > > What do you think? Is designed correctly. > It seems correct my question is about naming convention. I'd recommend asking such questions in an appropriate place - like a db group/irc channel. > > 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??? Doubt it - why are all your tables named like they are join tables - a table with more than 2 fields is a model. What does matches_teams_players represent? That a player took part in a match? Remember you're going to be typing these model names througout your app and PlayersTeamsMatches is going to get tiresome (and irritating e.g. or was it TeamsPlayersMatches or MatchesPlayersTeams?). Why not give it a name which means something to you, such as match_players id team_id player_id match_id position anything else you want > What about teams_match_id foreign key? Who knows... > > How many models I need to create? How many tables do you need which are not join tables? that's your golden number ;) AD -- 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
