I'm new to Prisma, I was wondering how does Prisma maintains relationships between entities in the DB, since I don't see any join table. For example between User and Message there is not UserMessage table but I see in my queries a messages properties and can query all the messages

Not sure if you postgres, but if yes, there's table

_UserToMessage

or

_MessageToUser

which contains three columns, unique id, A and B where A is id of first type from relation abd B from second

Hi Michal, yes I'm using postgres.. But there is not table _UsetToMessage or _MessageToUser hence my question... I'm using prisma 1.34.0 .. I'm able to query the relationship though