>> 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. Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
