Database 在Prisma中建立关系

您需要添加关系来解决此问题，如下所示 教练关系为一对多，课程用户关系为多对多

// schema.prisma
generator client {
  provider = "prisma-client-js"
}

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

enum LessonState {
    ACTIVE
    CLOSED
}

model Lesson {
    id          String      @id @default(uuid()) @map("_id") @db.Uuid
    date        DateTime    @default(now())
    subject     String
    description String
    state       LessonState @default(ACTIVE)
    users       User[]   @relation(name: "lesson_users")
    coachId     String   @db.Uuid
    coach User  @relation(name: "coach", fields: [coachId], references: [id])
}

enum UserRoles {
    ADMIN
    USER
}

model User {
    id        String    @id @default(uuid()) @map("_id") @db.Uuid
    name      String
    surname   String
    password  String
    login     String    @unique
    birthDate DateTime
    role      UserRoles @default(USER)
    createdAt DateTime  @default(now())
    myLessons   Lesson[] @relation(name: "lesson_users")
    lessonsITeach    Lesson[] @relation(name: "coach")
}

以下查询返回所有课程，其中包含参与该课程的用户和培训者的列表

await prisma.lesson.findMany({
  include: {
    users: true,
    coach: true,
  },
});

获取该课程参与的用户的ID

await prisma.lesson.findFirst({
      include: {
        users: { select: { id: true } },
        coach: true,
      },
    });

获取用户参与的所有课程以及用户教授的课程

await prisma.user.findFirst({
  include: {
    myLessons: true,
    lessonsITeach: true,
  },
});

仅获取ID的步骤

await prisma.user.findFirst({
  include: {
    myLessons: { select: { id: true } },
    lessonsITeach: { select: { id: true } },
  },
});