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

enum MenuType {
  DIRECTORY
  MENU
  SUBMENU
  BUTTON
}

model SysMenu {
  id           String      @id @map("_id") @default(auto()) @db.ObjectId
  parentId     String?     @map("parent_id") @db.ObjectId
  mId          Int?      @unique
  title        String
  status       Boolean   @default(true)
  type         MenuType
  order        Int       @db.Int

  frontendAuth String?   @unique @map("frontend_auth")

  parent       SysMenu?  @relation("MenuToChildren", fields: [parentId], references: [id], onDelete: NoAction, onUpdate: NoAction)
  children     SysMenu[] @relation("MenuToChildren")
  path         String?   @map("path")
  name         String?   @map("name")
  icon         String?   @map("icon")
  redirect     String?   @map("redirect")
  componentKey String?   @map("component_key")
  meta         Json?

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

  roleMenus      SysRoleMenu[]
  apiPermissions SysApiPermission[]

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

  @@map("sys_menu")
}