Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 1B6769FA432 for ; Tue, 9 Jan 2007 11:29:25 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 47176-09 for ; Tue, 9 Jan 2007 11:29:12 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from druid.net (druid.net [66.96.28.249]) by postgresql.org (Postfix) with ESMTP id 820909FA43C for ; Tue, 9 Jan 2007 11:29:18 -0400 (AST) Received: from dilbert.druid.net (H245.C18.B96.tor.eicat.ca [66.96.18.245]) by druid.net (Postfix) with SMTP id C37C9B58D; Tue, 9 Jan 2007 10:29:08 -0500 (EST) Date: Tue, 9 Jan 2007 10:30:33 -0500 From: "D'Arcy J.M. Cain" To: "Aaron Bono" Cc: Curtis@daycos.com, pgsql-sql@postgresql.org Subject: Re: Table relationships Message-Id: <20070109103033.a55fcd53.darcy@druid.net> In-Reply-To: References: <031936836C46D611BB1B00508BE7345D04DC1BB5@gatekeeper.daycos.com> <20070109094113.064bae02.darcy@druid.net> X-Mailer: Sylpheed version 2.2.0 (GTK+ 2.8.12; i386-portbld-freebsd6.1) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/21 X-Sequence-Number: 27173 On Tue, 9 Jan 2007 09:13:35 -0600 "Aaron Bono" wrote: > On 1/9/07, D'Arcy J.M. Cain wrote: > > company <===> address <===> detail > > This approach implies that the address defines the relationship between a > company and the detail (the other departments/offices). I cannot think of a > business model that would use this though there probably are some... Like the obvious one - companies have many places (departments) that things are shipped to and details are things that are shipped. > I'm not sure what this relationship is for. It would appear that a > department can have different addresses for different companies. Hmm. I guess I missed that. I'm just tossing out ideas here. Real, in depth analysis would require an invoicable relationship. :-) > There are many possibilities. Which one is best will depend on > > analysing your particular business model. > > I agree whole heartedly. That is why I recommend starting with a logic > structure before moving on to the physical. Absolutely. Don't even think about the tables until you have mapped out the business model. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.