On Mar 1, 9:46 am, "[email protected]" <[email protected]> wrote: > Hi, cake1.2 here, > > I have a question on how to set this database up by cake's convention. > I have the following 2 tables: > > users > assets > > each user has many assets, but users can allow other users to access > their assets > so I figure the following, a third table is needed: > > a table that has attributes: > owner, allowed > > they both point to users_id, how do I make this table model in > cakephp? Is there another way to do this? > Because i know users_id means foreign key to table users, but how do > you have 2 foreign to the same table? > > thank you
First relationship is a simple one to many relation: - User -> is owner of -> Asset. Second relationship is a many to many relation: - User -> Can access -> Asset - Asset -> Is accessible by -> User Thus the second relationship requires a entity in between User and Asset, for example named AssetUsers. Create one model for each of the entities in the first relationship. No problem there I hope :) Depending on which way you wish to present the second relationship, create either a model going from Asset to Users through AssetUsers or vice verse. Enjoy, John --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
