Id necessary in a relationship table?

Oddish · #1 (**permalink**) 10-26-07, 04:16

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?

r937 · #2 (**permalink**) 10-26-07, 04:23

the latter

Oddish · #3 (**permalink**) 10-27-07, 06:41

Thanks!