help with database project
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!
Subject
Written By
Posted
help with database project
November 30, 2014 05:54PM
November 30, 2014 08:07PM
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.