ok, I'm going to update the SQL with the dropped 2 constraints.<br><br>-Naama<br><br><br><div class="gmail_quote">On Fri, Oct 22, 2010 at 8:23 AM, seth redmond <span dir="ltr"><<a href="mailto:seth.redmond@imperial.ac.uk">seth.redmond@imperial.ac.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">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.<br>
<br>
-s<div><div></div><div class="h5"><br>
<br>
<br>
On 22 Oct 2010, at 12:46, Naama Menda wrote:<br>
<br>
</div></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div><div></div><div class="h5">
hi Bob,<br>
you could store the 2 measurements with 2 different experiment ids, or use the same experiment for both.<br>
Someone at some point asked for the 1-1 constraint, and I can't remember why.<br>
I think it's best to have users enforce this if needed on the software level.<br>
<br>
Any other thoughts?<br>
<br>
-Naama<br>
<br>
<br>
<br>
On Fri, Oct 22, 2010 at 5:53 AM, Bob MacCallum <<a href="mailto:r.maccallum@imperial.ac.uk" target="_blank">r.maccallum@imperial.ac.uk</a>> wrote:<br>
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?<br>
<br>
We have no objections to relaxing the constraint though - I'm sure there are situations where 1 to many is needed.<br>
<br>
<br>
<br>
On Thu, Oct 21, 2010 at 9:00 PM, Naama Menda <<a href="mailto:nm249@cornell.edu" target="_blank">nm249@cornell.edu</a>> wrote:<br>
hi,<br>
<br>
does anyone know why there was a request to have the experiment_id unique constraint on nd_experiment_phenotype ad genotype tables?<br>
<br>
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 .<br>
<br>
thanks!<br>
-Naama<br>
<br>
<br>
Naama Menda<br>
Boyce Thompson Institute for Plant Research<br>
Tower Rd<br>
Ithaca NY 14853<br>
USA<br>
<br>
(607) 254 3569<br>
Sol Genomics Network<br>
<a href="http://solgenomics.net/" target="_blank">http://solgenomics.net/</a><br>
<a href="mailto:nm249@cornell.edu" target="_blank">nm249@cornell.edu</a><br>
<br>
<br></div></div>
<ATT00003..txt><ATT00004..txt><br>
</blockquote>
<br>
</blockquote></div><br>