Re: Share a hasMany association ?

2009-06-09 Thread Travis L
iFeghali, Your decision will need to be based on your specific application. Take a look at the following tradeoffs and determine what's best for you. 1) Will a telephone EVER POSSIBLY have both a supplier AND a customer? If so, you def. want to go with option a; otherwise, you'll need to have t

Re: Share a hasMany association ?

2009-06-08 Thread iFeghali
ok this is similar to that question: http://groups.google.com/group/cake-php/browse_thread/thread/1d24a16fde2990c9 but the suggested solution is to add a forth model in the top which i prefer not to do for now. any other feedback on this ? --~--~-~--~~~---~--~~ Yo

Share a hasMany association ?

2009-06-08 Thread iFeghali
Hello All, I would love some feedback in the following design: Model Customers hasMany Telephones Model Suppliers hasMany Telephones Table telephones alternative (a): customer_id, supplier_id, phone# Table telephones alternative (b): foreign_key, phone# Given that all my keys are UIDS, AFAIK