Re: A foreign key on a self-referring table

From: Tobias Faust <tobias.faust_at_gmx.net>
Date: Thu, 4 Mar 2004 15:11:45 +0100
Message-ID: <c27dck$n5n4_at_doiweb4.b2x.vwg>

hi andrea,

> In a project I'm currently working on, I looked at the database design
> chart (made by other people) and found that some tables have foreign
> keys referring to themselves.

the answer is simple: this feature is to build a simple hierarchy like employee�s of university and doctors who�s teaching

greetings from germany
Tobias Received on Thu Mar 04 2004 - 15:11:45 CET

This message: [ Message body ]
Next message: Matthias Klaey: "Re: Where can i find the original database rules from Codd?"
Previous message: Eric Kaun: "Re: Multiple specification of constraints"
In reply to Andrea Laforgia: "A foreign key on a self-referring table"
Next in thread: --CELKO--: "Re: A foreign key on a self-referring table"

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

Original text of this message