model User {
  id         String  @id @default(cuid())
  name       String

}

model Chat {
  id String @id @default(cuid())

  user_id String
  user    User   @relation(fields: [user_id], references: [id])

  to_user_id String
  to_user    User   @relation(fields: [to_user_id], references: [id], name: "toUser")

  created_at DateTime @default(now())
  updated_at DateTime @updatedAt
}

hi how can I define a model chat relation to User . but i don't want User have reference to Chat

Hey 👋 You cannot have a relation field on only one side, it’s required to have relation fields on both models. Here’s how you could define models, please note that relation fields do not exist in the database so the chat column will not be in the User table and the user column will not be in the Chat table. Here’s a reference to relations guide.

model User {
  id   String @id @default(cuid())
  name String

  chat Chat[]
}

model Chat {
  id         String   @id @default(cuid())
  user_id    String
  user       User?    @relation(fields: [user_id], references: [id])
  created_at DateTime @default(now())
  updated_at DateTime @updatedAt
}