Table: search_reindex_run

Connected to

This table references:

• user(ref) via column started_by_user_ref

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
started_at	timestamp	no	Default now()
completed_at	timestamp	yes	—
cancelled_at	timestamp	yes	—
scope	jsonb	no	Default '{}'::jsonb
target	text	no	—
total_estimated	bigint	yes	—
processed	bigint	no	Default 0
succeeded	bigint	no	Default 0
failed	bigint	no	Default 0
started_by_user_ref	bigint	yes	References user(ref)
last_error	text	yes	—

Constraints

• CONSTRAINT search_reindex_run_target_check CHECK ((target = ANY (ARRAY['tsvector'::text, 'embedding'::text, 'both'::text])))

Full DDL

CREATE TABLE public.search_reindex_run (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    started_at timestamp with time zone DEFAULT now() NOT NULL,
    completed_at timestamp with time zone,
    cancelled_at timestamp with time zone,
    scope jsonb DEFAULT '{}'::jsonb NOT NULL,
    target text NOT NULL,
    total_estimated bigint,
    processed bigint DEFAULT 0 NOT NULL,
    succeeded bigint DEFAULT 0 NOT NULL,
    failed bigint DEFAULT 0 NOT NULL,
    started_by_user_ref bigint,
    last_error text,
    CONSTRAINT search_reindex_run_target_check CHECK ((target = ANY (ARRAY['tsvector'::text, 'embedding'::text, 'both'::text])))
);

---

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