ME: Indices to composite foreign keys are impossible to create

[pimeys]

Schema:

model User {
  id                  Int       @id
  firstName           String
  lastName            String
  @@unique([firstName, lastName])
}

Now we want to create another table that references the unique firstName/lastName combination in the User model, first try:

model SpamList {
  id   Int  @id
  user User @relation(references: [firstName, lastName])
  @@index([user])
}

errors:

reading the prisma schema from prisma/schema.prisma
Error: Failure during a migration command: Connector error. (error: Error querying the database: Error querying the database: Error querying the database: db error: ERROR: column "user" does not exist)

and another try:

model SpamList {
  id   Int  @id
  user User @relation(references: [firstName, lastName])

  @@index([user_firstName, user_lastName])
}

errors:

Error: Failure during a migration command: error: Error validating model "SpamList": The index definition refers to the unknown fields user_firstName, user_lastName.
  -->  schema.prisma:33
   |
32 |
33 |   @@index([user_firstName, user_lastName])

[janpio]

It's possible that it is currently not defined yet how these indexes in relation with composite FKs should actually be represented in the schema: prisma/prisma#1606