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.

I can included the billing address and delivery address in the Order table:

order
-------
billing_name
billing_address
billing_state
shipping_name
shipping_address
shipping_state

Otherwise I can create another table that will just store addresses for orders:

order
-------
billing_address_id
shipping_address_id

order_address
-------
address_id
name
address
state
sql database-design
Edit
Report