>While on the topic, a similar questions. Are people adding a separate Primary key to many to many join tables or using the two Foreign key fields as that purpose?
I've done both. However, a lot of the basic classes I use tend to expect a single field primary key so I normally just add one to keep things consistent, then add a contraint + index on the two other fields.