Hi,

I've got a quick data modelling question.

I have 3 tables, Companies, Branches and Users. Would you add a FK to
Company in User like so:

Company hasMany Branch,User
Branch hasMany User
Branch belongsTo Company
User belongsTo Branch,Company

Or would you leave the FKs to Company out like so:

Company hasMany Branch
Branch hasMany User
Branch belongsTo Company
User belongsTo Branch

I'm thinking it would be really handy to be able to list all users of
a Company without going via the Branch model, but I'm not sure as it
might not be the recommended way of doing things.

Thanks,

Jon

--


jon bennett
t: +44 (0) 1225 341 039 w: http://www.jben.net/
iChat (AIM): jbendotnet Skype: jon-bennett

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake 
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to