Re: [SQLObject] Re: SQLObject

[Brad B. <br...@bb...>]

On 04/11/03 09:45, Bud P. Bruegger wrote:
> On Thu, 10 Apr 2003 18:22:11 -0500
> Brad Bollenbach <br...@bb...> wrote:
> 
> > Project
> > project_id PK
> > ...
> > 
> > Worker
> > worker_id PK
> > ...
> > 
> > ProjectWorker
> > project_id FK
> > worker_id  FK
> > (together they're the PK)
> > hourly_rate
> > ...
> > 
> > and so on.
> 
> But in my experience, it gets hard if these keys have to change--and
> since they carry business meaning, it is not always inevitable (people
> even in rare cases change social security numbers...).  For example,
> assume you reassign a project to another worker...  If there is a key
> without any business meaning whatsoever, changing is MUCH easier...

There's no implication in there that they do carry business
meaning. I.e. project_id and worker_id could easily be integers (and
each table could later have a name column, e.g. project_name,
worker_name, etc.)

-- 
Brad Bollenbach
BBnet.ca