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

[seth redmond]

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>