Prisma-client-js: Explicit relation tables

[siberian-man]

As far as I aware of, the following feature from Prisma:

type MyRelation @relationTable {
  user: User!
  profile: Profile!
}

is somehow implemented in Prisma2. But there is no documentation. How to use it?

[nikolasburk]

Hey @victordombrovskiy, thanks for opening this issue. This topic indeed lacks proper documentation at the moment. You can however learn about the intended behaviour in our spec here.

In short: The @relationTable attribute is not needed any more. Instead you define a relation table in the same way you'd define any other model:

model MyRelation {
  user User
  profile Profile

  @@id([user, profile])
}

UPDATE: I just talked to @mavilein about this feature. Defining relation tables like this is actually not implemented yet. The query engine has the assumption that every model has a singular id field. This is not the case for thise use case, therefore it doesn't work yet.

[siberian-man]

@nikolasburk will it be included in the today's release? Or when do you this will be fixed? Just want to plan further work based on availability of this feature.

[nikolasburk]

It won't be included in today's release and might take a few more weeks (possibly months) until it is available.

[divyenduz]

We dropped this for now but this will be picked up again in coming weeks. We have noted that community wants this feature. It is blocked on some internal refactoring around supporting multiple unique ids and would be picked up in a bigger epic.

[siberian-man]

@divyenduz What is status of this? A lot of weeks passed :)
Probably, you can suggest a best way to workaround this limitation?

[divyenduz]

@victordombrovskiy If I understand it correctly, this feature is being worked on from the perspective of introspection https://github.com/prisma/prisma2/issues/1083 and is in the current milestone.

[mavilein]

@divyenduz : We are working on it right now. But it will take a few more weeks until this will be finished.

[janpio]

This is now implemented and can be used with the syntac @nikolasburk posted above 🚀