[Open-bio-l] biosql schema oddities?

[Hilmar Lapp]

bioentry.entry_version is nullable in the version I have (I don't think I did this locally). Also, I don't find display_id included in a UK, let alone being a UK on its own.

	-hilmar

> -----Original Message-----
> From: Elia Stupka [mailto:elia@fugu-sg.org]
> Sent: Monday, June 17, 2002 12:48 AM
> To: Bioperl; OpenBio list
> Subject: [Open-bio-l] biosql schema oddities?
> 
> 
> Some biosql schema oddities:
> 
> 1)Last week we said with Hilmar that we should store NULL versions for
> bioentries that don't have a version, rather than zero, while 
> right now
> the schema a)does not allow NULL, b)defaults to zero... guess 
> we should
> change that, everybody ok with that? (until I hear back I re-committed
> non-versions to be zero for coherence)
> 
> 2)The unique key in bioentry is the display_id, without taking into
> account database id. At the moment it basically just happily 
> dies on mysql
> when you try to store the same display_id into two databases. 
> We should
> handle it better. I think in theory we shouldn't prevent two 
> biodatabases
> to contain an entry with the same display_id. What if I want to keep a
> database that is only swissprot and one that is sptr all 
> combined for some
> arcane reason? Or if I want to keep an old and a new version of a
> database? 
> 
> Elia
> 
> -- 
> ********************************
> * http://www.fugu-sg.org/~elia *
> * tel:    +65 6874 1467        *
> * mobile: +65 9030 7613        *
> * fax:    +65 6777 0402        *
> ********************************
> 
> 
> _______________________________________________
> Open-Bio-l mailing list
> Open-Bio-l@open-bio.org
> http://open-bio.org/mailman/listinfo/open-bio-l
>