Separate tables?

From: <terry_at_smallblueworld.com>
Date: 2000/07/04
Message-ID: <8jsdt8$7ql$1_at_news.netmar.com>#1/1

This is probably a very common question, but here goes. I have several tables all of which model concepts that require one or more addresses i.e. Customer, Supplier etc. If I create a single address table I have to have a foreign key column for every adressee, but if instead I have a separate address table for CustomersAddress, SupplierAddress etcthem I'm duplicating the address model.

Is there a better approach?

Regards

Terry Child

Posted via NewsOne.Net: Free Usenet News via the Web -----
http://newsone.net/ -- Discussions on every subject. ----- NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net

Received on Tue Jul 04 2000 - 00:00:00 CEST

This message: [ Message body ]
Next message: p.forestall: "Re: Separate tables?"
Previous message: Carl Rosenberger: "JDO Query Specification"
Next in thread: p.forestall: "Re: Separate tables?"
Reply: p.forestall: "Re: Separate tables?"
Reply: Joe Celko: "Re: Separate tables?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message