[Gmod-schema] Re: unique dbxref_id on cvterm

[Chris M. <cj...@fr...>]

the dbxref must be persistent and consistent across database
instances

what about making dbxref = cv.name + cvterm.name?

On Mon, 21 Feb 2005, Scott Cain wrote:

> 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
>
>