[BioSQL-l] RE: [Biojava-l] Change Proposal regarding References

[Hilmar Lapp]

On May 31, 2005, at 8:42 PM, Richard HOLLAND wrote:

> I should also point out that we should be using the 
> 'bioentry_reference'
> and 'reference' tables, and not 'bioentry_dbxref' as I mistakenly
> mentioned in the original post.
>

Right - so you've corrected this already.

Note that reference has a foreign key to dbxref to store the PUBMED or 
MEDLINE id. The foreign key is identifying; i.e., there's also a unique 
key constraint on that foreign key, meaning only one reference can 
point to a particular PUBMED id.

	-hilmar

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