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.
### User
1.Contact Address
2.Billing Address
### Business
1.Contact Address
2.something
So I created an address model with an
addresstype
column like this
### Address
id
addresstype
user
addressline1
addressline2
Relationships:
* 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?
Asked by Gowri
(209 rep)
Mar 6, 2013, 11:39 PM
Last activity: Mar 2, 2017, 04:09 AM
Last activity: Mar 2, 2017, 04:09 AM