Background Jobs

1import { integer, jsonb, pgTable, text, timestamp, uuid } from "drizzle-orm/pg-core";
2 
3export const backgroundJobs = pgTable("background_jobs", {
4  id: uuid("id").primaryKey().defaultRandom(),
5  name: text("name").notNull(),
6  status: text("status").notNull().default("queued"),
7  payload: jsonb("payload").$type<Record<string, unknown>>().notNull().default({}),
8  attempts: integer("attempts").notNull().default(0),
9  maxAttempts: integer("max_attempts").notNull().default(3),
10  runAfter: timestamp("run_after", { withTimezone: true }).defaultNow().notNull(),
11  lockedAt: timestamp("locked_at", { withTimezone: true }),
12  completedAt: timestamp("completed_at", { withTimezone: true }),
13  failedAt: timestamp("failed_at", { withTimezone: true }),
14  createdAt: timestamp("created_at", { withTimezone: true }).defaultNow().notNull(),
15});