When I use a third table to keep track of a many-to-many relationship I obviously create two columns in this third table that will hold both foreign kyes from the other two tables, but is it necessary to have an auto-increment, primary index column ("id" for example) in the relationship-table itself? Or should I just create a primary index using the two foreign keys?

the latter

Thanks!