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

[Richard Cote]

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