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

[Hilmar Lapp]

It looks to me that after relaxing this uniqueness constraint the  
table doesn't have a natural primary key anymore. Every table should  
have a natural primary key enforced by a UNIQUE constraint. Maybe the  
constraint should be on (nd_experiment_id,phenotype_id)?

	-hilmar

On Oct 22, 2010, at 7:46 AM, 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
>
>

-- 
===========================================================
: Hilmar Lapp  -:- Durham, NC -:- informatics.nescent.org :
===========================================================



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://brie4.cshl.edu/pipermail/gmod-help/attachments/20101022/c1752c00/attachment.html>