[Open-bio-l] BioSQL schema: some questions

[Hilmar Lapp]

> -----Original Message-----
> From: Hilmar Lapp 
> Sent: Thursday, April 25, 2002 9:07 PM
> To: OBDA BioSQL (E-mail)
> Subject: [Open-bio-l] BioSQL schema: some questions
> 
[...]
> 
> 17) Aren't Dbxref.dbname and Biodatabase.name redundant? 
> Shouldn't there be a FK?
> 

The documentation for Bioentry_direct_links says

# Direct links. It is tempting to do this
# from bioentry_id to bioentry_id. But that wont work
# during updates of one database - we will have to edit
# this table each time.

I'm obviously missing the discussion that preceded that. Could someone try to explain to me briefly why this is so? What would need to be edited, and why?

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