[BioSQL-l] DBXRef

[Hilmar Lapp]

I propose to convert the implicit foreign keys to bioentries 
captured as DBXref into explicit foreign keys to Bioentry.

This enables integrity checking by the database, fast and simple 
joins, and provides for easy annotation/decoration of DBXrefs 
(because they'd become no less annotatable as any other Bioentry).

At the same time, this change would give rise to a Bioentry-Bioentry 
association table, which we need anyway to represent relationships 
between bioentries, one of the central concepts of the database 
we're building here. These associations would be typed.

To extend this, eventually these relationships will also need to 
reference evidence. If anyone has thoughts on this please share. 
This is not our most immediate problem though.

	-hilmar
--
-------------------------------------------------------------
Hilmar Lapp                            email: lapp at gnf.org
GNF, San Diego, Ca. 92121              phone: +1-858-812-1757
-------------------------------------------------------------