2 months ago

Please help me design this database

Posted 2 months ago by ChrisF79

I'm creating a customer relationship management app. The users table will hold the users of the site. The site manages people so there will need to be a table for people. That said, how do I handle addresses? Someone may have two houses and therefore two mailing addresses. Do I then make an "addresses" table that's separate? And, if they have two addresses, do they then have two lines in the people table? How would you design it?

Please sign in or create an account to participate in this conversation.