Hi I am not sure how to give this thread a clear title or topic. But let me explain what I am trying to do (or find the best and "right" practice for this approch).
Think of 3 tables: Users, companies and subsidiaries. Users always belong to a company but they could (!) belong to subsidiary which is itself related to a company. So there are 2 constellations: Company -> Users Company -> Subsidiaries -> Users The relation between a company and a subsidiary is clear. But what is the best approach for storing the user relation? Set both company_id + subsidiary_id in the user model although subsidiary_id has already a relation to a company? This could lead into illogical data, if the relation between company and subsidiary has changed. Or leaving company_id empty in that case and only setting the subsidiary_id? In the other case leave subsidiary_id empty if a user belongs directly to a company. What do you think? Thanks, Frank -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
