>
> Therefore, I -1 your proposal as a commiter. I will lift it only if you
> really
> convince me (and the others) that those keys are neccesary.
>
> Rafal
Any key that is assigned by the database system is considered surrogate.
Almost all our tables have autoincrement primary keys. These are surrogate
keys (other columns could have been used instead, but were not). So for
example, TURBINE_PERMISSION.PERMISSIONID is one. Surrogate keys are
basically void of any semantic meaning. They solve a lot of problems.
I apoligize if I was unclear in my first post. I can post more
informations regarding the benefits of them, but I didn't think it
would be a big problem since we are already making haavy use them. I
just didn't see why we were incosistent with our use of them.
mike
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
