代码之家 › 专栏 › 技术社区 › Xhris

`字段“User”已在模型“User”上定义。`保存schema.prisma文件时出现问题

prisma next.js postgresql

Xhris · 技术社区 · 2 年前

在我的 schema.prisma 文件,我设置了 User 模型,以便 User 可以是一个或多个团队的成员,也可以由一个或几个用户添加为成员,这里有一份我的模式副本来实现这一点,但在保存文件后,我会继续获得其中的几个 User User? @relation(fields: [userId], references: [id]) 关系填充文件时出错 Field "User" is already defined on model "User". 即使在移除它们并尝试再次保存之后。如何解决此问题?

model User :

model User {
  id                     String              @id @default(cuid())
  userId                 String?             @unique
  firstName          String?
  profileImage       String?
  password           String?
  image              String?
  lastName           String?
  invitedById        String?
      // ... other fields
  
     // Teams and Invites
  Teams        Team[] @relation("TeamMembers", fields: [userId], references: [id])
  CreatedTeams Team[] @relation("TeamCreator", fields: [id], references: [userId])
  InvitedBy    User[] @relation("UserInviter", fields: [invitedById], references: [id])
  Invites      User[] @relation("UserInvitee", fields: [id], references: [invitedById])
  
    // InvitedByUser and InviterUser
  InvitedByUser User @relation("InvitedByUser", fields: [invitedById], references: [id])
  InviterUser   User @relation("InviterUser", fields: [id], references: [invitedById])
  
   // Other relations
  UserRelationWith       User?  @relation("UserRelationWith", fields: [userId], 
  references: [id])
  UserRelationTwo        User[] @relation("UserRelationTwo", fields: [userId], 
  references: [id])
  UserArray              User[] @relation("UserArray", fields: [userId], references: 
  [id])


// Below `User` relations instances that continues to self-populate upon saving the file with error: `'Field "User" is already defined on model "User".'` This is preventing the file from being saved/migrated.


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

//model Team :

model Team {
  id         String      @unique @default(uuid())
  email      String      @unique
  name       String?
  firstName  String?
  lastName   String?
  isVerified Boolean?
  image      String?
  members    User[]      @relation("TeamMembers", fields: [userId], references: [id])
  createdBy  User        @relation("TeamCreator", fields: [userId], references: [id])
  userId     String?
  createdAt  DateTime    @default(now())
  updatedAt  DateTime    @updatedAt
  teamId     String?
  User       User?       @relation(fields: [userId], references: [id])
}