I want to design an "Address" model for all types of entities like users, businesses, etc.
I have two types of main models: one is User and the other is Business. Each one has different address types like below.
1.Contact Address 2.Billing Address
1.Contact Address 2.something
So I created an address model with an
addresstype column like this
id addresstype user addressline1 addressline2
- User – One to many –> Business
- User – One to many –> Address (User Column)
Now using the above relations,
addresstype and user columns will be in a relation, but Business address is not relatted with address.
How can I design this one in an efficient way?