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.