CREATE TABLE "scheduled_job" (
"id" integer PRIMARY KEY NOT NULL,
"name" varchar(255) NOT NULL,
"workflowId" varchar(36),
"nodeId" varchar(36),
"taskType" varchar(128) NOT NULL,
"payload" text NOT NULL DEFAULT ('{}'),
"kind" varchar(16) NOT NULL,
"cronExpression" varchar(255),
"timezone" varchar(64),
"intervalSeconds" integer,
"fireAt" datetime(3),
"enabled" boolean NOT NULL DEFAULT (true),
"nextRunAt" datetime(3),
"lastFiredAt" datetime(3),
"maxAttempts" integer NOT NULL DEFAULT (1),
"createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
"updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
"recurrenceUnit" varchar(16),
"recurrenceSize" int,
CONSTRAINT "CHK_scheduled_job_recurrence_unit" CHECK (("recurrenceUnit" IN ('hours', 'days', 'weeks', 'months'))),
CONSTRAINT "CHK_scheduled_job_recurrence_size" CHECK (("recurrenceSize" >= 2)),
CONSTRAINT "CHK_scheduled_job_cron_expression" CHECK (("kind" <> 'cron' OR "cronExpression" IS NOT NULL)),
CONSTRAINT "CHK_scheduled_job_interval_seconds" CHECK (("kind" <> 'interval' OR "intervalSeconds" IS NOT NULL)),
CONSTRAINT "CHK_scheduled_job_fire_at" CHECK (("kind" <> 'one_off' OR "fireAt" IS NOT NULL)),
CONSTRAINT "CHK_scheduled_job_kind" CHECK ("kind" IN ('cron', 'interval', 'one_off', 'recurring_cron')),
CONSTRAINT "CHK_scheduled_job_recurring_cron" CHECK ("kind" <> 'recurring_cron' OR ("cronExpression" IS NOT NULL AND "recurrenceUnit" IS NOT NULL AND "recurrenceSize" IS NOT NULL)),
CONSTRAINT "FK_scheduled_job_workflowId" FOREIGN KEY ("workflowId") REFERENCES "workflow_published_version" ("workflowId") ON DELETE CASCADE ON UPDATE NO ACTION
)