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

[Naama Menda]

ok, I'm going to update the SQL with the dropped 2 constraints.

-Naama


On Fri, Oct 22, 2010 at 8:23 AM, seth redmond
<seth.redmond at imperial.ac.uk>wrote:

> It's a hang-over from when the tables were supposed to be 'subclasses' of
> nd_experiment. I agree it makes more sense to have it removed now, it's been
> requested a number of times.
>
> -s
>
>
>
> On 22 Oct 2010, at 12:46, Naama Menda wrote:
>
>  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
>>
>>
>> <ATT00003..txt><ATT00004..txt>
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://brie4.cshl.edu/pipermail/gmod-help/attachments/20101022/a16d8fd1/attachment.html>