Table: jobs

Connected to

Referenced by:

• ai_provider_call — column job_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
type	text	no	—
payload	jsonb	no	Default '{}'::jsonb
status	text	no	Default 'pending'::text
priority	integer	no	Default 100
attempts	integer	no	Default 0
max_attempts	integer	no	Default 3
claimed_by	text	yes	—
claimed_at	timestamp	yes	—
lease_expires_at	timestamp	yes	—
last_error	text	yes	—
result	jsonb	yes	—
origin_server_id	uuid	yes	—
scheduled_for	timestamp	yes	—
enqueued_at	timestamp	no	Default now()
started_at	timestamp	yes	—
finished_at	timestamp	yes	—
idempotency_key	text	yes	—

Constraints

• CONSTRAINT jobs_status_check CHECK ((status = ANY (ARRAY['pending'::text, 'running'::text, 'done'::text, 'failed'::text, 'cancelled'::text])))

Full DDL

CREATE TABLE public.jobs (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    type text NOT NULL,
    payload jsonb DEFAULT '{}'::jsonb NOT NULL,
    status text DEFAULT 'pending'::text NOT NULL,
    priority integer DEFAULT 100 NOT NULL,
    attempts integer DEFAULT 0 NOT NULL,
    max_attempts integer DEFAULT 3 NOT NULL,
    claimed_by text,
    claimed_at timestamp with time zone,
    lease_expires_at timestamp with time zone,
    last_error text,
    result jsonb,
    origin_server_id uuid,
    scheduled_for timestamp with time zone,
    enqueued_at timestamp with time zone DEFAULT now() NOT NULL,
    started_at timestamp with time zone,
    finished_at timestamp with time zone,
    idempotency_key text,
    CONSTRAINT jobs_status_check CHECK ((status = ANY (ARRAY['pending'::text, 'running'::text, 'done'::text, 'failed'::text, 'cancelled'::text])))
);

---

Please see the schema overview for context. This document was last regenerated on 2026-07-26T08:25:29.520Z.