How can I leverage Prisma's implicit relations to create the following relation? (one-many, many-many, one-one)

Question

I'm learning Prisma,

I want to leverage Prisma's Implicit relations as much as possible for the following relation (and later I want to use nexus for writing queries):

• 1 User can belong to Many Conversations (as it's participant)

• 1 Conversation has an array os users (called participants)

• 1 User can own Many Messages (as it's author)

• 1 Message can have 1 User (as it's author)

• 1 Conversation has an array of messages (called texts)

• 1 Message can only belong to 1 Conversation

So far I have come up with this (but I highly doubt it's correct because its not behaving as I want it to when using with nexus):

model User {
  id            String         @id @default(uuid())
  conversations Conversation[]
}

model Message {
  id        String   @id @default(uuid())
  authorId       String
  conversationId String
  author         User         @relation(fields: [authorId], references: [id])
  conversation   Conversation @relation(fields: [conversationId], references: [id])
}

model Conversation {
  id        String   @id @default(uuid())
  participants User[]
  messages     Message[]
}

Could I please get some pointers/help to proceed?

Answer 1

following your requirements list this schema is pretty much ready. Just add the messages field on the User model to declare its side of the relationship.

It would be like this:

model User {
  id            String         @id @default(uuid())
  conversations Conversation[]
  messages      Message[]
}

model Message {
  id             String       @id @default(uuid())
  authorId       String
  conversationId String
  author         User         @relation(fields: [authorId], references: [id])
  conversation   Conversation @relation(fields: [conversationId], references: [id])
}

model Conversation {
  id           String    @id @default(uuid())
  participants User[]
  messages     Message[]
}

Do you have any specific issues that occur when using Nexus with it?

I have a video tutorial that might help you with some extra guidance: https://www.youtube.com/watch?v=sWlzqRB5Xro

Answer 2

I believe this schema would solve it to you. If you want to know more, I gave a talk about this topic a while back.

model User {
  id            String         @id @default(uuid())
  messages      Message[]
  conversations Conversation[]
}

model Message {
  id             String       @id @default(uuid())
  author         User         @relation(fields: [authorId], references: [id])
  authorId       String
  conversation   Conversation @relation(fields: [conversationId], references: [id])
  conversationId String
}

model Conversation {
  id       String    @id @default(uuid())
  messages Message[]
  members  User[]
}