Re: [GENERAL] Modeling bill/ship addresses

2007-08-06 Thread johnf
On Sunday 05 August 2007 21:43, snacktime wrote: > I've been going back and forth on the best way to model this. > > A user can have one to many bill and ship addresses. > An order can have one bill address and one to many ship addresses > > Let's assume I have a single address table, with an addre

Re: [GENERAL] Modeling bill/ship addresses

2007-08-05 Thread Shane Ambler
snacktime wrote: I've been going back and forth on the best way to model this. A user can have one to many bill and ship addresses. I would think that one billing and many shipping would be most likely. eg head office for billing and shipping to each branch office. An order can have one bill