Re: [SQLObject] Re: SQLObject

[Bud P. B. <bu...@si...>]

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...

--b