Best practice: Record associated to one or all
Hi
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.
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home