Search
Star
Feedback
Setup for Free
© 2026 Hedgehog Software, LLC
Twitter
GitHub
Discord
System
Light
Dark
More
Communities
Docs
About
Terms
Privacy
n:m relations between tables and view - Prisma
P
Prisma
•
13mo ago
•
10 replies
ptrxyz
n:m relations between tables and view
I have a view
"DepartmentInfo
" as well as model
"User
"
.
The user can be part of many departments and a department can have many users
-
- we are talking about
n
:m relation
.
I defined the view as well as the model in my schema
, but prisma doesn
't seem to create the relation tables
(
_User_DepartmentInfo
_User_DepartmentInfo
) for that relation
. As soon as I change the view to a model
, the table is generated
.
What am I doing wrong here
?
Prisma
Join
The official Discord server of Prisma! Find us online at prisma.io
9,819
Members
View on Discord
Resources
ModelContextProtocol
ModelContextProtocol
MCP Server
Recent Announcements
Similar Threads
Was this page helpful?
Yes
No
Similar Threads
Multiple relations between the same Tables
P
Prisma / help-and-questions
2y ago
Prisma ORM multiple 1 to n relations
P
Prisma / help-and-questions
2y ago
Migration creates Implicit relational tables in database for an explicit M-N relationship
P
Prisma / help-and-questions
17mo ago
m-n schema change non locking
P
Prisma / help-and-questions
3d ago