Sunday, May 12, 2013

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


Real Estate