>> I wouldn't enter the "delivery" and "billing" info either, but create
>> some sort of "customer_address" table or "order_customer_address"
>> in which records would be inserted if and only if the addresses used
>> for billing and delivery differ from the normal customer address.
>And what happens if the customer changes their "normal" address but
>you want to keep that historical information? This is mostly an
>exercise in thinking what can happen, which you want to do.
This is why I mentioned that as well.
I think that we offer the same solution -> create a new address
entry, to be used for new orders and so on, and mark it as the
"current address". Historical orders will point to the old address.
Database Workbench - development tool for MySQL, and more!
Database development questions? Check the forum!