Hello friends, I have small problem that you can help figure out. I have a

User model

with enum roles: 1. Admin 2. siteUser 3. Moderator If I want one

siteUser

to be able to select and add (multiple)

Moderators

as their favs, I could do a one-many relationship, but because they are both in the ‘User model’ it’s a little challenging - How can I implement this logic in my

prisma.schema

file?

it’s a little challenging

what's the problem with declaring a pivot table in the prisma.schema?

@Ruben Amendoeira Great Idea, I thought about that but thought there might be an easier way. Thanks. @Chris Tsongas - Thanks as well for the link/ references. 🙏