Table: ai_provider_call

Connected to

This table references:

• jobs(id) via column job_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
provider	text	no	—
model	text	no	—
concern	text	no	—
prompt_template	text	yes	—
prompt_version	text	yes	—
asset_id	uuid	yes	—
job_id	uuid	yes	References jobs(id)
input_hash	text	yes	—
input_tokens	integer	yes	—
output_tokens	integer	yes	—
duration_ms	integer	no	—
estimated_cost_usd_micros	bigint	yes	—
status	text	no	Default 'success'::text
error_message	text	yes	—
actor_user_ref	bigint	yes	—
triggered_at	timestamp	no	Default now()

Constraints

• CONSTRAINT ai_provider_call_concern_check CHECK ((concern = ANY (ARRAY['complete'::text, 'embed'::text, 'transcribe'::text, 'tag'::text, 'caption'::text])))
• CONSTRAINT ai_provider_call_status_check CHECK ((status = ANY (ARRAY['success'::text, 'rate_limited'::text, 'transient_error'::text, 'permanent_error'::text, 'budget_blocked'::text, 'privacy_blocked'::text])))

Full DDL

CREATE TABLE public.ai_provider_call (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    provider text NOT NULL,
    model text NOT NULL,
    concern text NOT NULL,
    prompt_template text,
    prompt_version text,
    asset_id uuid,
    job_id uuid,
    input_hash text,
    input_tokens integer,
    output_tokens integer,
    duration_ms integer NOT NULL,
    estimated_cost_usd_micros bigint,
    status text DEFAULT 'success'::text NOT NULL,
    error_message text,
    actor_user_ref bigint,
    triggered_at timestamp with time zone DEFAULT now() NOT NULL,
    CONSTRAINT ai_provider_call_concern_check CHECK ((concern = ANY (ARRAY['complete'::text, 'embed'::text, 'transcribe'::text, 'tag'::text, 'caption'::text]))),
    CONSTRAINT ai_provider_call_status_check CHECK ((status = ANY (ARRAY['success'::text, 'rate_limited'::text, 'transient_error'::text, 'permanent_error'::text, 'budget_blocked'::text, 'privacy_blocked'::text])))
);

---

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