I also posted this question on StackOverflow
I’m new to Prisma. So I have a 3-way relationship between
Role I would like to define. For each association of a
User and an
Event, there exists a
Role for that association. If I were to design a database table for another ORM, I would have created a
event_user table with
role_id as columns to relate them.
How would one create a relationship like this in Prisma?
For some context, each user would have a list of global roles as well, so there would already be an association between
Role. The question concerns the “local roles” for each event.