Sample Header Ad - 728x90

Relational database for address model

3 votes
2 answers
2071 views
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