I have two tables, products
and categories
which have a many to many relationship, so I'm adding a products_categories
table which will contain category_id
and product_id
.
Should I add another (autoincrementing) index column or use the two existing ones as primary key?