Working with Many-to-Many Relations

model Post {
  id   Int    @id @default(autoincrement())
  tags Tag[]
}
model Tag {
  id    Int    @id @default(autoincrement())
  posts Post[]
}

model PostTag {
  postId Int
  tagId  Int
  post   Post @relation(fields:[postId], references:[id], onDelete: Cascade)
  tag    Tag  @relation(fields:[tagId],  references:[id], onDelete: Cascade)
  @@id([postId, tagId])
}

model PostTag {
  postId   Int
  tagId    Int
  addedAt  DateTime @default(now())
  addedBy  String?
  @@id([postId, tagId])
}

const post = await prisma.post.findUnique({
  where: { id: 1 },
  include: { tags: true }
});

await prisma.post.update({
  where: { id: 1 },
  data: { tags: { connect: [{ id: 5 }, { id: 7 }] } }
});

await prisma.post.update({
  where: { id: 1 },
  data: { tags: { set: [{ id: 1 }, { id: 2 }, { id: 3 }] } }
});

await prisma.post.findMany({
  where: { tags: { some: { name: { in: ["typescript", "react"] } } } }
});