schema.prisma

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

generator client {
  provider = "prisma-client"
  output   = "./client"
}

datasource db {
  provider = "postgresql"
}

model QueueJob {
  id          BigInt    @id @default(autoincrement()) @db.BigInt
  queue       String
  key         String?
  cron        String?
  payload     Json?
  result      Json?
  error       Json?
  progress    Int       @default(0)
  priority    Int       @default(0)
  attempts    Int       @default(0)
  maxAttempts Int?
  runAt       DateTime  @default(now())
  notBefore   DateTime?
  finishedAt  DateTime?
  processedAt DateTime?
  failedAt    DateTime?
  createdAt   DateTime  @default(now())
  updatedAt   DateTime  @updatedAt

  @@unique([key, runAt])
  @@index([queue, finishedAt, processedAt, priority, runAt])
  @@map("queue_jobs")
}