Re: [SQLObject] Re: SQLObject

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

On Fri, 11 Apr 2003 07:58:45 -0500
Brad Bollenbach <br...@bb...> wrote:

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

Hmmm.  you're right!

But assume there are other tables referencing ProjectWorker; say
ProjectWorkerComment.  Assume, they also use composite keys:

project_id 
worker_id 
comment_id 

(where (project_id, worker_id) is a foreign key referencing
ProjectWorker

Then, if you reassign the project to another worker, you also have to
change the composite key of the related comments.  

So you could say that the business meaning is not in the key itself
but in the relationships you define in terms of the keys...

--b