How can I define a many to many relationship with muiltiple of relations in the same tables? for ex

User {
id: String
employeeProfile: Profile[]
clientProfile Profile[] @relation("client")
}

Profile {
id: String
client User?   @relation("clientProfile", fields: [clientProfileId], references: [id])
  clientProfileId String?

  employees User[]
}

The place where I'm having trouble is the employeeProfile. How can I do a many to man using the same tables?

#orm-help is the easiest channel to get. prisma help. In regards to your question, have a read of the Disambiguating relations doc