[BioSQL-l] DB Schema question in the ontology section

[Aaron J. Mackey]

The reason is that the relationship between ontological terms may come 
from another ontology entirely (imagine a mapping between SO and, say, 
GAME-XML tags as defined by the DTD, in which case three ontologies 
would be in play).

Confusing, but there it is.  For the case where the two related terms 
are from the same ontology, the extra ontology_id will most likely 
point to the same ontology from which the terms arose.

-Aaron

On May 19, 2005, at 11:56 AM, Richard Cote wrote:

> Hello all
>
> The term_path and term_relationship tables of the biosql schema 
> contain an
> ontology_id FK that references the ontology table. Why is this key 
> present
> in those tables? What's the rationale? Can't you link back to the 
> ontology
> through the term table itself?
>
> Thanks for any info and regards,
> Rc
> --
> Richard Cote
> Software Engineer - PRIDE Project Team (Sequence Database Group)
>
> European Bioinformatics Institute
> Wellcome Trust Genome Campus            RCote at ebi.ac.uk
> Hinxton
> Cambridge CB10 1SD                      Phone: (+44) 1223 492610
> United Kingdom                          Fax  : (+44) 1223 494468
>
> _______________________________________________
> BioSQL-l mailing list
> BioSQL-l at open-bio.org
> http://open-bio.org/mailman/listinfo/biosql-l
>
>
--
Aaron J. Mackey, Ph.D.
Dept. of Biology, Goddard 212
University of Pennsylvania       email:  amackey at pcbi.upenn.edu
415 S. University Avenue         office: 215-898-1205
Philadelphia, PA  19104-6017     fax:    215-746-6697