title: Mysql database design for customer multiple addresses and default address
body: <p>I am creating the database structure of an ecommerce with Mysql and INNODB engine.</p>
  
  <p><strong>Point 1</strong>: To create multiple addresses for the customers i have this tables</p>
  
  <p><img src="https://i.stack.imgur.com/AnrDA.jpg" alt=""></p>
  
  <p>Am I doing it in the correct way? And how should I store the default address (in which table)?</p>
  
  <p><strong>Point 2</strong>: I have another table called "Suppliers", should i just connect it to addresses with a "supplier_address" table or is there a better way?</p>
  
  <p><strong>Point 3</strong>: What about the tables cities and countries? Should i add something or is that ok? Maybe a field "district" in another table beetween the two?</p>