cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: Lookup tables
Date Thu, 21 Dec 2006 06:57:34 GMT
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
>


Mime
View raw message