box-nestjs-monorepo/prisma/mongo/schema/sys-role-menu.prisma

model SysRoleMenu {
  id           String      @id @map("_id") @default(auto()) @db.ObjectId

  roleId       String      @map("role_id") @db.ObjectId
  menuId       String      @map("menu_id") @db.ObjectId

  canView      Int     @default(0) @db.Int
  canCreate    Int     @default(0) @db.Int
  canUpdate    Int     @default(0) @db.Int
  canDelete    Int     @default(0) @db.Int

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

  role SysRole @relation(fields: [roleId], references: [id], onDelete: NoAction, onUpdate: NoAction)
  menu SysMenu @relation(fields: [menuId], references: [id], onDelete: NoAction, onUpdate: NoAction)

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