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

Home -> Community -> Usenet -> comp.databases.theory -> Re: A foreign key on a self-referring table

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@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 - 08:11:45 CST












Original text of this message













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