box-nestjs-monorepo/prisma/mysql/schema/role-menu.prisma

model RoleMenu {
  id         Int      @id @default(autoincrement())
  roleId     Int      @map("role_id")
  menuId     Int      @map("menu_id")

  // add 查增删改  0: disabled; 1: enabled; 2: NOT applicable
  canView      Int @default(0)
  canCreate    Int @default(0)
  canUpdate    Int @default(0)
  canDelete    Int @default(0)

  createTime DateTime @default(now()) @map("create_time") @db.DateTime(3)
  updateTime DateTime @default(now()) @updatedAt @map("update_time") @db.DateTime(3)

  role Role @relation(fields: [roleId], references: [id])
  menu Menu @relation(fields: [menuId], references: [id])

  @@unique([roleId, menuId])
  @@map("sys_role_menu")
}