schema.prisma

model Company {
  id          String   @default(cuid()) @id
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt
  workspaceId Int      @unique
  name        String
  users       User[]
}

model User {
  id          String   @default(cuid()) @id
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt
  workspaceId Int      @unique
  givenName   String?
  familyName  String?
  email       String
  companies   Company[]
}

model CompanyUsers {
  id      String   @id
  company Company
  user    User
  roles   String[]
}

I think this should work:

model Company {
  id          String   @default(cuid()) @id
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt
  workspaceId Int      @unique
  name        String
  companyUsers       CompanyUser[]
}

model User {
  id          String   @default(cuid()) @id
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt
  workspaceId Int      @unique
  givenName   String?
  familyName  String?
  email       String
  companyUsers       CompanyUser[]
}

model CompanyUsers {
  id      String   @id
  company Company
  user    User
  roles   String[]
}

Hi @matthewmueller, what makes the difference from your another workarounds about explicit many-to-many described in prisma/prisma#816 (comment) ?

In above schema, both model has a list of relation model while in the gist they directly have list of each others

@ifndefdeadmau5 It was a mistake and the wrong syntax. See the link below. The syntax here is the correct one :)

https://prisma.slack.com/archives/CKQTGR6T0/p1576156448333900?thread_ts=1576156170.333700&cid=CKQTGR6T0

yep thanks @scriptcoded. sorry for the confusion!

@scriptcoded Thanks for the correction :)