Say I have to store data about two different types of person roles or occupations, i.e.,
Merchants, and both types of roles share a single base table called
In this respect,
Merchants need to have a few additional fields, e.g.,
What is the most efficient way to design a database for these specifications?
- Have extra columns on the
- Have an extra table called
MerchantDatawhich has a
- Have a
UserMetaEAV table which allows any amount of additional values.
I am currently leaning towards option 2, as the additional fields are fixed. Are there any down sides that I am not seeing?