Composite key on n:m relation table

[ff-anthony-soto]

model Muscle {
  id Int @id @default(autoincrement())
  name String @unique
  exercises MuscleExercise[]
}

model MuscleExercise {
  muscle  Muscle @unique @relation
  exercise Exercise @unique @relation 
  priority Int
}

model Exercise {
  id String @id @default(uuid())
  name String @unique
  muscles MuscleExercise[]
}

I need to simulate an n:m table (MuscleExercise), but when I'm running the studio I'm getting an error:

PANIC: Unable to resolve a primary identifier for model MuscleExercise.
at PrismaClientFetcher.request

What's the way to do a composite key between tables?

[janpio]

Should both muscle and exercise in MuscleExercis both be unique individually (which is how it is modeled right now) or as a compound unique? If the latter, you should try @@unique([muscle, execrise]) - that should be treated as the unique identifier for that model.

[ff-anthony-soto]

Exactly, it has to be a compound unique! Thanks!