Explicit many to many relationships with/without extra columns

[divyenduz]

Tracks implementation of https://github.com/prisma/specs/tree/master/schema#explicit-many-to-many-mn-relationships-with-or-without-extra-columns

Many-to-many relation with/without extra columns.

[nikolasburk]

There's also a related discussion here: prisma/specs#264

[ifndefdeadmau5]

Here I update temporary workaround by @matthewmueller (in slack channel) that possibly can be migrate into official implementation in future This isn't right, see below

model Blog {
  id       Int       @id
  authors  Writer[]
}
model Writer {
  id      Int     @id
  blogs   Blog[]
}
// many to many
model BlogsWriters {
  id        Int      @id
  blog      Blog
  author    Writer
  is_owner  Boolean
}

also suggested migration steps:

1. remove the @id from id
2. add @id([blog, author]), if that works... great, you don't have to migrate any data. if that doesn't work, you'll need to write a script to de-dupe
3. remove id Int entirely

[scriptcoded]

@ifndefdeadmau5 This won't actually work as of right now. The following schema has been tested and works :)

model Blog {
  id      Int          @id
  authors BlogWriter[]
}
model Writer {
  id    Int          @id
  blogs BlogWriter[]
}
// many to many
model BlogWriter {
  id       Int     @id
  blog     Blog
  author   Writer
  is_owner Boolean
}

[narciero]

what is the status of prisma supporting extra data fields with M-N relation?

[janpio]

This is now implemented 🚀