i've found what I need: http://book.cakephp.org/view/1046/Multiple-relations-to-the-same-model
On 19 Mar, 17:27, AD7six <[email protected]> wrote: > 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
