Prisma

```model ProjectCategories {
  project       Project  @relation(fields: [projectId], references: [id])
  projectId  String // relation scalar field (used in the `@relation` attribute above)
  category   Category @relation(fields: [categoryId], references: [id])
  categoryId String // relation scalar field (used in the `@relation` attribute above)


  @@id([projectId, categoryId])
}```

It seems you’re using the incorrect type to reference the foreign key

Try adding `@db.Uuid` to the `projectId` here as well.

error disappeared. let me try to run n check if it works. can i rename this table as well to be postgres naming convention comptaible?

You can use <https://www.prisma.io/docs/concepts/components/prisma-client/working-with-prismaclient/use-custom-model-and-field-names#using-map-and-map-to-rename-fields-and-models-in-the-prisma-client-api|@@map> to achieve this.

```const project = await prisma.project.findFirst({
                where: {
                    username: {
                        equals: slug,
                    },
                },
                include: {
                    categories: { include: { category: true } },
                },
            });```

<@UESADRKMY> is this the right way to get the thru table? will we need to do such a nested include to get the name?

isnt there just an easier way to solve to get the details

Currently if you’re using a separate model for the many-to-many relation then you would need to do a nested include.