Is it a bad practice to use primary key in junction tables?

Databases
19

that’s lovely

i’m on my way out but at first glance it will do splendidly

not sure why a label would have colours, but let’s carry on because the structure is the issue

EDIT –

you would want an auto_increment on user_has_photo_has_label_has_colour

  1. less noise and hassle, check

  2. not having to join… bzzzt, wrong :slight_smile: (i’m just having fun)

sample query: which users have used lavender as a label – you need an extra join