ChrisF79
2 months ago
296
2
General

Should I have one address table or two?

Posted 2 months ago by ChrisF79

I'm creating a customer relationship manager (CRM) app so Realtors can manage their customers. The Realtors are the users of the site so they will be stored in the user table. Their customers can have multiple physical addresses (work, home, second home, etc) so they're going to be in an address table.

With that said though, the users of the site will also have addresses used for billing purposes. Do I create a second address table for them? I'm not sure how would be best to design this in MySQL.

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