Return-Path: Delivered-To: apmail-incubator-cayenne-user-archive@locus.apache.org Received: (qmail 87515 invoked from network); 21 Dec 2006 18:34:29 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 21 Dec 2006 18:34:29 -0000 Received: (qmail 79751 invoked by uid 500); 21 Dec 2006 18:34:36 -0000 Delivered-To: apmail-incubator-cayenne-user-archive@incubator.apache.org Received: (qmail 79739 invoked by uid 500); 21 Dec 2006 18:34:36 -0000 Mailing-List: contact cayenne-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: cayenne-user@incubator.apache.org Delivered-To: mailing list cayenne-user@incubator.apache.org Received: (qmail 79730 invoked by uid 99); 21 Dec 2006 18:34:36 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 21 Dec 2006 10:34:36 -0800 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of terry.jeske@gmail.com designates 64.233.184.227 as permitted sender) Received: from [64.233.184.227] (HELO wr-out-0506.google.com) (64.233.184.227) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 21 Dec 2006 10:34:26 -0800 Received: by wr-out-0506.google.com with SMTP id i11so1257363wra for ; Thu, 21 Dec 2006 10:34:05 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=baoWTF1TYej48Rg0177V1bV9FkV6Svmf2asOvMN7WenhSR9K+GfpiKgYzoSjOTtbcqXGdrRFMuEjV2LtO7GP4cLv3qRDqdhrwwywA7U7Qpzpv1DNm/j3Y0L6aKxuWxMNRcYSWGwwxa4wWviC9F+AeNA6nGN/NRlYfnlETPsEpPQ= Received: by 10.78.134.12 with SMTP id h12mr622104hud.1166725665688; Thu, 21 Dec 2006 10:27:45 -0800 (PST) Received: by 10.78.107.7 with HTTP; Thu, 21 Dec 2006 10:27:40 -0800 (PST) Message-ID: <466a19d0612211027q4dbfe07aj90590297f9846f44@mail.gmail.com> Date: Thu, 21 Dec 2006 10:27:40 -0800 From: "Terry Jeske" To: cayenne-user@incubator.apache.org Subject: Re: Lookup tables In-Reply-To: <5E562C54-2E91-4F8B-8596-B0A7DA1D8189@objectstyle.org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_51151_27304723.1166725660656" References: <466a19d0612201634x2e00a1ccv41b02ab7534f42ea@mail.gmail.com> <5E562C54-2E91-4F8B-8596-B0A7DA1D8189@objectstyle.org> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_51151_27304723.1166725660656 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Right you are! I was a bit sloppy with my description. Sorry about that. On 12/20/06, Andrus Adamchik wrote: > > Terry, > > Just noticed that according to your message, status_table has an FK > to project... Wouldn't you want the opposite if a project has just > one status? (other than that what others and myself suggested in this > thread is still correct). > > > projects_table > -------------------------------- > id int (pk) > projectname varchar > status_id int (fkey to status_table id) > > > status_table > ------------------------------ > status_id int (pk) > status_name varchar > > > Andrus > > > On Dec 21, 2006, at 2:34 AM, Terry Jeske wrote: > > > projects_table > > -------------------------------- > > id int > > projectname varchar > > status int > > > > > > status_table > > ------------------------------ > > projectId int (fkey back to projects_table id) > > status_name varchar > > > > ------=_Part_51151_27304723.1166725660656--