title: SQL table design: Should I store addresses with orders or in separate table?
body: <p>I am busy creating a basic ecommerce website and would like to know what is the best of the following two options regarding the way I store the billing and delivery addresses. I am open to any other suggestions.</p>
  
  <p>I can included the billing address and delivery address in the Order table:</p>
  
  <pre><code>order
  -------
  billing_name
  billing_address
  billing_state
  shipping_name
  shipping_address
  shipping_state
  </code></pre>
  
  <p>Otherwise I can create another table that will just store addresses for orders:</p>
  
  <pre><code>order
  -------
  billing_address_id
  shipping_address_id
  
  order_address
  -------
  address_id
  name
  address
  state
  </code></pre>