[Gmod-schema] unique dbxref_id on cvterm

[Scott C. <ca...@cs...>]

Hi Chris,

I am dreading writing this email a little bit, given the discussion that
occurred a few weeks ago involving dbxrefs and cvterms.  Anyway, I
gather from the comments you added to cvterm that you really did intend
to make a unique index on dbxref_id in cvterm, and I even understand why
you did it given that much of the time, the cvs are coming from a real
ontology and they have accessions.  Of course, some of the time, there
will be "ad hoc" cvs that won't have accessions.  The solution I am
suggesting is the creation of a db sequence and items that don't belong
to a formal ontology will get the next available value from the
sequence.  Does that sound OK to you?

Thanks,
Scott

-- 
------------------------------------------------------------------------
Scott Cain, Ph. D.                                         ca...@cs...
GMOD Coordinator (http://www.gmod.org/)                     216-392-3087
Cold Spring Harbor Laboratory