What's industrial best practice for bill to and ship to deal with tables? Do people mix them into 1 table or seperate them into 2 different tables? To general invoice. Thanks ahead of time!
I'd possess a
CustomerAddress table permitting multiple records per Customer. An
IsShippingAddress flag would indicate which may be the shipping address. An
IsBillingAddress column. could be used similarly.
By doing this exactly the same address might be employed for both shipping and billing if preferred.
I have seen many systems with separate tables for permission and security reasons and often you will find many shipping addresses so a table for your is created. As well as the confirmation phone, etc. You get the drift?