What is the best practice to store records which are either related to one parent OR to all parents?
Related to one is clear (set parent_id to id), but which method is the better approach:
Set parent_id to 0 to make the record available to all parents or set it to "null" and make a "global switch" (tinyint 0/1)?
In real life a document can belong to one company OR (not at the same time) to all companies.
What would you do?
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 cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
No comments:
Post a Comment