[Gmod-help] Re: [Gmod-schema] Unique constraint in natural diversity module

[Naama Menda]

hi Bob,
you could store the 2 measurements with 2 different experiment ids, or use
the same experiment for both.
Someone at some point asked for the 1-1 constraint, and I can't remember
why.
I think it's best to have users enforce this if needed on the software
level.

Any other thoughts?

-Naama



On Fri, Oct 22, 2010 at 5:53 AM, Bob MacCallum
<r.maccallum at imperial.ac.uk>wrote:

> Wasn't it just that if you are measuring two phenotypes, say leaf size and
> fruit weight, then you'd use two nd_experiments (each linked to the same
> stock) because you need two nd_protocols to describe the two assays?
>
> We have no objections to relaxing the constraint though - I'm sure there
> are situations where 1 to many is needed.
>
>
>
> On Thu, Oct 21, 2010 at 9:00 PM, Naama Menda <nm249 at cornell.edu> wrote:
>
>> hi,
>>
>> does anyone know why there was a request to have the experiment_id unique
>> constraint on nd_experiment_phenotype ad genotype tables?
>>
>> There was a request recently to drop this 1-1 relationship, and I can't
>> figure out why it was requested in the first place .
>>
>> thanks!
>> -Naama
>>
>>
>> Naama Menda
>> Boyce Thompson Institute for Plant Research
>> Tower Rd
>> Ithaca NY 14853
>> USA
>>
>> (607) 254 3569
>> Sol Genomics Network
>> http://solgenomics.net/
>> nm249 at cornell.edu
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://brie4.cshl.edu/pipermail/gmod-help/attachments/20101022/1cdb48ee/attachment.html>