Attirbute not known : "@relation". Error

[akshatg5]

Question

Given the schema.prisma file: // This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

// Looking for ways to speed up your queries, or scale easily with your serverless or edge functions?
// Try Prisma Accelerate: https://pris.ly/cli/accelerate-init

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}


enum Roles {
  ADMIN
  EDUCATOR
  INSTITUTE
  STUDENT
}

model Role {
  id    Int    @id @default(autoincrement())
  name  Roles
  users User[]
}

model Institute {
  id              Int    @id @default(autoincrement())
  nameOfInstitute String
  city            String
  state           String
  area            String
  pincode         Int
  country         String
}

model Follow {
  id          Int      @id @default(autoincrement())
  follower    User     @relation("UserFollowers", fields: [followerId], references: [id])
  followerId  Int
  following   User     @relation("UsersFollowing", fields: [followingId], references: [id])
  followingId Int
  createdAt   DateTime
  User        User?    @relation(fields: [userId], references: [id])
  userId      Int?

  @@unique([followerId, followingId])
}

// Tag model that will help the users organize and filter their notes according to their own tags
model Tag {
  id    Int    @id @default(autoincrement())
  name  String
  notes Note[]
}

model Note {
  id              Int       @id @default(autoincrement())
  title           String
  description     String
  content         String
  createdAt       DateTime  @default(now())
  createdBy       User      @relation(fields: [userId], references: [id])
  userId          Int
  isPublic        Boolean   @default(false)
  grade           Int?
  section         String?
  collegeSemester Int?
  subject         String?
  tags            Tag[]
  comments        Comment[]
  upvotes         Upvote[]
}

model User {
  id          Int       @id @default(autoincrement())
  email       String    @unique
  username    String    @unique
  password    String
  firstName   String
  lastName    String?
  bio         String?
  createdAt   DateTime  @default(now())
  updatedAt   DateTime  @updatedAt
  institution String?
  role        Role      @relation(fields: [roleId], references: [id])
  roleId      Int
  Notes       Note[]
  followers   Follow[]  @relation("UserFollowers")
  following   Follow[]  @relation("UsersFollowing")
  Follow      Follow[]
  comments    Comment[]
  upvotes     Upvote[]
}

model Comment {
  id        Int      @id @default(autoincrement())
  content   String
  createdAt DateTime @default(now())
  user      User     @relation(fields: [userId], references: [id])
  userId    Int
  note      Note     @relation(fields: [noteId], references: [id])
  noteId    Int

  @@relation(fields: [userId], references: [id])
}

model Upvote {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  user      User     @relation(fields: [userId], references: [id])
  userId    Int
  note      Note     @relation(fields: [noteId], references: [id])
  noteId    Int

  @@relation(fields: [userId], references: [id])
}

I am getting the errors :

How to reproduce (optional)

Expected behavior (optional)

No Errors?

Information about Prisma Schema, Client Queries and Environment (optional)

// Add your schema.prisma

// Add any relevant Prisma Client queries here

• OS:

• Database:

• Node.js version:

• Run prisma -v to see your Prisma version and paste it

[ludralph]

Hi @akshatg5 👋

The error is due to the incorrect use of the @relation attribute in your Comment and Upvote models. The @relation attribute is used to define relations between models in Prisma, and it should only be applied to relation fields, not to the model itself.

In your Comment and Upvote models, you have applied @@relation at the model level, which is incorrect. The @@relation attribute does not exist in Prisma. You should remove these lines from your Comment and Upvote models.

You can take a look at this section of the documentation on how to use relation fields.

[akshatg5]

Thankyouu!