cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Juergen Saar" <juer...@jsaar.org>
Subject Re: Lookup tables
Date Thu, 21 Dec 2006 07:16:02 GMT
I would it do in the Andrus-Style ...

but it seems, as if the idea of terry is a freetext-status,
that is continous changed during the lifecycle of a project.
I wonder why this information is not placed directly in the project-table.

2006/12/21, Andrus Adamchik <andrus@objectstyle.org>:
>
> 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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message