Even n-n relation tables should have a simple PK

Continuing with the above/earlier I say that even the table to create a many-to-many relationship should have a simple primary key.
Table User_Role
– field UserRoleID PK
– field UserID FK
– field RoleID FK

As long as harddisk space is cheap and a simple PK does not create a performance impact there should be no reason to not have a simple primary key.


Leave a Reply