Re: DB design question: how to handle address change in online shopping database?

From: Jan-Erik Rosinowski <spamfilter_at_rosinowski.de>
Date: 2000/02/15
Message-ID: <38a94bd5.16496200_at_News.CIS.DFN.DE>#1/1


(addressid, addressdata)

(userid, addressid, userdata...) // as default for 1st order,

(orderid, userid, addressid) // addressid as of last order

but this does not keep a history of user movements

ciao, jan

http://www.rsp.de - Software zur effizienten Erstellung und Verwaltung von Gutachten, Analysen, Pruefprotokollen etc. Received on Tue Feb 15 2000 - 00:00:00 CET

Original text of this message