I am trying to store whether an address is a Work address or a Home address. There will never be another type of address.
I'm wondering what the pros/cons are of the different ways to store this, and if there is an accepted 'style' for this type of situation which is considered best practice,
Would it be better to just have a single
IsHome bool column, and if it's false, I just assume it's a work?
2) or both a
3) or a
AddressType column which is an ID that would correspond to another table which has work and home with an ID?
4) or something I have not considered?
The third option seems a little cleaner however needing to join every time seems inefficient.