Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Table design question

Re: Table design question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 22 Aug 2002 19:57:23 +0200
Message-ID: <ff9amusu6oanrv0vg29m01cpfomcv8mvqt@4ax.com>


On Thu, 22 Aug 2002 09:47:20 -0400, MSherrill_at_compuserve.com wrote:

>On Wed, 21 Aug 2002 23:45:26 +0000, PeterS <member_at_dbfoums.com> wrote:
>
>>I have a table where foreign key references the same table's primary
>>key. Primary key is just one column as well as foreign key.
>>Is it good design?
>
>Normally, relationships between thingys get their own table.

Where did you learn that? Go ask your money back!

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Aug 22 2002 - 12:57:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US