Good point. <br>I dropped the 1-1 relationship and added a constraint on (nd_experiment_id, phenotype_id /genotype_id )<br><br>It's in svn, so update your schema if you're using it .<br><br>-Naama<br><br><br clear="all">
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/">http://solgenomics.net/</a><br><a href="mailto:nm249@cornell.edu">nm249@cornell.edu</a><br>
<br><br><div class="gmail_quote">On Fri, Oct 22, 2010 at 9:27 AM, Hilmar Lapp <span dir="ltr"><<a href="mailto:hlapp@nescent.org">hlapp@nescent.org</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;">
<div style="word-wrap: break-word;">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)?<div>
<br></div><div><span style="white-space: pre-wrap;"> </span>-hilmar</div><div><div><div></div><div class="h5"><br><div><div>On Oct 22, 2010, at 7:46 AM, Naama Menda wrote:</div><br><blockquote type="cite">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><div class="gmail_quote">On Fri, Oct 22, 2010 at 5:53 AM, Bob MacCallum <span dir="ltr"><<a href="mailto:r.maccallum@imperial.ac.uk" target="_blank">r.maccallum@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;">
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.<div><div></div><div><br><br><br><div class="gmail_quote">On Thu, Oct 21, 2010 at 9:00 PM, Naama Menda <span dir="ltr"><<a href="mailto:nm249@cornell.edu" target="_blank">nm249@cornell.edu</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;">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 clear="all">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>
</blockquote></div><br> </div></div></blockquote></div><br></blockquote></div><br></div></div><div> <span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;"><div style="word-wrap: break-word;">
<div><font size="3" face="Monaco"><span style="font-size: 11px;">-- </span></font></div><div><font size="3" face="Monaco"><span style="font-size: 11px;">===========================================================</span></font></div>
<div><font size="3" face="Monaco"><span style="font-size: 11px;">: Hilmar Lapp -:- Durham, NC -:- <a href="http://informatics.nescent.org" target="_blank">informatics.nescent.org</a> :</span></font></div><div><font size="3" face="Monaco"><span style="font-size: 11px;">===========================================================</span></font></div>
<div><br></div></div></span><br> </div><br></div></div></blockquote></div><br>