box-nestjs-monorepo/prisma/mongo/schema/video-media.prisma

model VideoMedia {
  /// Mongo ObjectId stored in `_id`
  id            String    @id @map("_id") @db.ObjectId

  srcId         Int       @default(0)
  title         String    @default("")
  checkSum      String    @default("")
  type          String    @default("")

  formatType    Int       @default(0)
  contentType   Int       @default(0)

  coverType     Int       @default(0)
  coverImg      String    @default("")
  coverImgNew   String    @default("")

  /// Duration in seconds
  videoTime     Int       @default(0)

  publish       String    @default("")
  country       String    @default("")
  firstTag      String    @default("")

  secondTags    String[]  @default([])

  mediaSet      String?   @default("")   // null allowed for legacy data

  preFileName   String    @default("")

  status        String    @default("")
  desc          String    @default("")

  /// File size can exceed 32-bit, but default still 0
  size          BigInt    @default(0)

  bango         String    @default("")

  actors        String[]  @default([])   // allow null for old data, default []

  studio        String    @default("")

  addedTime     DateTime
  createdAt     DateTime
  updatedAt     DateTime

  appids        Int[]     @default([])

  japanNames    String[]  @default([])

  filename      String    @default("")
  fieldNameFs   String    @default("")
  ext           String    @default("")
  taskId        String    @default("")

  width         Int       @default(0)
  height        Int       @default(0)
  ratio         Float     @default(0)

  frameRate     String    @default("")
  syBitRate     String    @default("")
  vidBitRate    String    @default("")

  proxyUpload   Int       @default(0)
  isAdd         Boolean   @default(false)
  retry         Int       @default(0)
  notifySignal  Boolean   @default(false)

  mergeRetry    Int       @default(0)
  compressRetry Int       @default(0)
  segmentRetry  Int       @default(0)
  linodeRetry   Int       @default(0)

  failReason    String    @default("")
  deleteDisk    Boolean   @default(false)
  infoTsName    String    @default("")

  @@map("videoMedia")
}