/** * `plugin_jobs` table — registration and runtime configuration for * scheduled jobs declared by plugins in their manifests. * * Each row represents one scheduled job entry for a plugin. The * `job_key` matches the key declared in the manifest's `jobs` array. * The `schedule` column stores the cron expression or interval string * used by the job scheduler to decide when to fire the job. * * Status values: * - `active` — job is enabled and will run on schedule * - `paused` — job is temporarily disabled by the operator * - `error` — job has been disabled due to repeated failures * * @see PLUGIN_SPEC.md §21.3 — `plugin_jobs` */ export declare const pluginJobs: import("drizzle-orm/pg-core").PgTableWithColumns<{ name: "plugin_jobs"; schema: undefined; columns: { id: import("drizzle-orm/pg-core").PgColumn<{ name: "id"; tableName: "plugin_jobs"; dataType: "string"; columnType: "PgUUID"; data: string; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: true; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}, {}>; pluginId: import("drizzle-orm/pg-core").PgColumn<{ name: "plugin_id"; tableName: "plugin_jobs"; dataType: "string"; columnType: "PgUUID"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}, {}>; jobKey: import("drizzle-orm/pg-core").PgColumn<{ name: "job_key"; tableName: "plugin_jobs"; dataType: "string"; columnType: "PgText"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}, {}>; schedule: import("drizzle-orm/pg-core").PgColumn<{ name: "schedule"; tableName: "plugin_jobs"; dataType: "string"; columnType: "PgText"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}, {}>; status: import("drizzle-orm/pg-core").PgColumn<{ name: "status"; tableName: "plugin_jobs"; dataType: "string"; columnType: "PgText"; data: "active" | "paused" | "failed"; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}, { $type: "active" | "paused" | "failed"; }>; lastRunAt: import("drizzle-orm/pg-core").PgColumn<{ name: "last_run_at"; tableName: "plugin_jobs"; dataType: "date"; columnType: "PgTimestamp"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}, {}>; nextRunAt: import("drizzle-orm/pg-core").PgColumn<{ name: "next_run_at"; tableName: "plugin_jobs"; dataType: "date"; columnType: "PgTimestamp"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}, {}>; createdAt: import("drizzle-orm/pg-core").PgColumn<{ name: "created_at"; tableName: "plugin_jobs"; dataType: "date"; columnType: "PgTimestamp"; data: Date; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}, {}>; updatedAt: import("drizzle-orm/pg-core").PgColumn<{ name: "updated_at"; tableName: "plugin_jobs"; dataType: "date"; columnType: "PgTimestamp"; data: Date; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}, {}>; }; dialect: "pg"; }>; /** * `plugin_job_runs` table — immutable execution history for plugin-owned jobs. * * Each row is created when a job run begins and updated when it completes. * Rows are never modified after `status` reaches a terminal value * (`succeeded` | `failed` | `cancelled`). * * Trigger values: * - `scheduled` — fired automatically by the cron/interval scheduler * - `manual` — triggered by an operator via the admin UI or API * * @see PLUGIN_SPEC.md §21.3 — `plugin_job_runs` */ export declare const pluginJobRuns: import("drizzle-orm/pg-core").PgTableWithColumns<{ name: "plugin_job_runs"; schema: undefined; columns: { id: import("drizzle-orm/pg-core").PgColumn<{ name: "id"; tableName: "plugin_job_runs"; dataType: "string"; columnType: "PgUUID"; data: string; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: true; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}, {}>; jobId: import("drizzle-orm/pg-core").PgColumn<{ name: "job_id"; tableName: "plugin_job_runs"; dataType: "string"; columnType: "PgUUID"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}, {}>; pluginId: import("drizzle-orm/pg-core").PgColumn<{ name: "plugin_id"; tableName: "plugin_job_runs"; dataType: "string"; columnType: "PgUUID"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}, {}>; trigger: import("drizzle-orm/pg-core").PgColumn<{ name: "trigger"; tableName: "plugin_job_runs"; dataType: "string"; columnType: "PgText"; data: "manual" | "schedule" | "retry"; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}, { $type: "manual" | "schedule" | "retry"; }>; status: import("drizzle-orm/pg-core").PgColumn<{ name: "status"; tableName: "plugin_job_runs"; dataType: "string"; columnType: "PgText"; data: "pending" | "queued" | "running" | "cancelled" | "failed" | "succeeded"; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}, { $type: "pending" | "queued" | "running" | "cancelled" | "failed" | "succeeded"; }>; durationMs: import("drizzle-orm/pg-core").PgColumn<{ name: "duration_ms"; tableName: "plugin_job_runs"; dataType: "number"; columnType: "PgInteger"; data: number; driverParam: string | number; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}, {}>; error: import("drizzle-orm/pg-core").PgColumn<{ name: "error"; tableName: "plugin_job_runs"; dataType: "string"; columnType: "PgText"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}, {}>; logs: import("drizzle-orm/pg-core").PgColumn<{ name: "logs"; tableName: "plugin_job_runs"; dataType: "json"; columnType: "PgJsonb"; data: string[]; driverParam: unknown; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}, { $type: string[]; }>; startedAt: import("drizzle-orm/pg-core").PgColumn<{ name: "started_at"; tableName: "plugin_job_runs"; dataType: "date"; columnType: "PgTimestamp"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}, {}>; finishedAt: import("drizzle-orm/pg-core").PgColumn<{ name: "finished_at"; tableName: "plugin_job_runs"; dataType: "date"; columnType: "PgTimestamp"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}, {}>; createdAt: import("drizzle-orm/pg-core").PgColumn<{ name: "created_at"; tableName: "plugin_job_runs"; dataType: "date"; columnType: "PgTimestamp"; data: Date; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}, {}>; }; dialect: "pg"; }>; //# sourceMappingURL=plugin_jobs.d.ts.map