CREATE TABLE "scheduled_task" (
"id" integer PRIMARY KEY NOT NULL,
"jobId" integer NOT NULL,
"taskType" varchar(128) NOT NULL,
"payload" text NOT NULL DEFAULT ('{}'),
"scheduledFor" datetime(3) NOT NULL,
"runAt" datetime(3) NOT NULL,
"status" varchar(16) NOT NULL DEFAULT ('pending'),
"attempts" integer NOT NULL DEFAULT (0),
"maxAttempts" integer NOT NULL DEFAULT (1),
"claimedBy" varchar(255),
"leaseExpiresAt" datetime(3),
"leaseEpoch" integer NOT NULL DEFAULT (0),
"startedAt" datetime(3),
"finishedAt" datetime(3),
"errorMessage" text,
"createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
"dispatchedAt" datetime(3),
CONSTRAINT "CHK_scheduled_task_running_lease" CHECK ("status" <> 'running' OR "leaseExpiresAt" IS NOT NULL),
CONSTRAINT "CHK_scheduled_task_status" CHECK ("status" IN ('pending', 'running', 'succeeded', 'failed', 'missed', 'cancelled')),
CONSTRAINT "FK_scheduled_task_jobId" FOREIGN KEY ("jobId") REFERENCES "scheduled_job" ("id") ON DELETE CASCADE
)