do people even use composite primary keys these days?
like....... why DO i want an auto-incrementing integer field as a primary key?
seems arbitrary?
seriously though
if a row in my table is uniquely identified by a combination of fields
and if i didn't set them together as the primary key i would:
put a unique constraint on them
and
put an index on them
why would i not just make them the primary key?!
ah, thank you everyone who replied
the answer is deffo the case that you need to use the pkey of that table as fkey in another
for the system i am designing now i do not think that will be the case, but it likely could at some point i guess
so i will have the autoincrementing INT pkey as usual i think
thanks again!
🙇
@bea I learned that from a meme
@Fuego ye p much