Biggie
Biggie
TTCTheo's Typesafe Cult
Created by Biggie on 4/20/2023 in #questions
Good way to do many to many relationship Prisma
I have these schemas where I want to create a many to many relationship between the Xyz table to the subcategory as well as between the Kva table to the subcategory. This is a schema sketch of how I would want to do it but I get the error: Error validating: Embedded many-to-many relations are not supported on MySQL. Please use the syntax defined in https://pris.ly/d/relational-database-many-to-many Is there any way to do it without intermediate tables? Will add up to a lot of tables over time 🙂 model Subcategory { id String @id @default(cuid()) name String xyzs Xyz[] @relation("XyzSubcategory") kvas Kva[] @relation("KvaSubcategory") } model Xyz { id String @id @default(cuid()) questionPrompt String @db.Text ... subcategories Subcategory[] @relation("XyzSubcategory", references: [id], fields: [subcategoryId]) subcategoryId String? } model Kva { id String @id @default(cuid()) questionPrompt String @db.Text ... subcategories Subcategory[] @relation("KvaSubcategory", references: [id], fields: [subcategoryId]) subcategoryId String? }
4 replies