Design: The Entity?
Last month, I
posted my preference
for maintaining addresses (and other entity attributes) via an ENTITY table. I got some good feedback, but I would like more.
Option 1
Option 2
In short, I prefer Option 1 as it requires no further modifications (if adding another entity) and you won't have to write funky SQL to get all the addresses (though you would have to UNION the people and organizations table and any subsequent entity). The one bad thing perhaps is that you would have to keep a close eye on your code to prevent someone from subverting your process...I think anyway.
So please vote and sound off in comments as to the "Why" of your choice.
(If you choose neither, please, please, please explain!)
Labels: database, design
