So I'm from the camp that advocates the use of surrogate
keys for every table reqardless if a candidate keys already
exists.
There are two tables that don't use them:
TURBINE_ROLE_PERMISSION
TURBINE_USER_GROUP_ROLE
And another table, TURBINE_JOBENTRY, whose key, JOBID, should
be made to be autoincrement.
Does anyone object if we/I update the three tables? The big win
for using surrogate keys is that you add/change/delete columns
without affecting the relational intregrity.
mike
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
