MySQL Forums
Forum List  »  Newbie

help with database project
Posted by: matteo savini
Date: November 30, 2014 05:54PM

hi,
i'm a total newbie in database projecting: i've been using mysql for years but, unfortunately, i never considered projecting crucial. i was wrong, obviously...

i'm now organizing customers data. MOST of them have one shipping address and one invoice address. pretty easy. a few of them, however, are "dropshipping" customers, with one invoice address and hundreds of different shipping addresses.

how would you organize such details?

i thought i may create a table for "regular" customer, with one field for shipping and one field for invoice addresses, then create a table for each of the dropshipping customers where to list all of the shipping addresses.

is this the correct approach?

many thanks!

Options: ReplyQuote


Subject
Written By
Posted
help with database project
November 30, 2014 05:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.