Table: storage_sweep_runs

Connected to

Referenced by:

• storage_sweep_findings — column run_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	—
kind	text	no	—
status	text	no	Default 'running'::text
cursor	text	yes	—
objects_scanned	bigint	no	Default 0
findings_count	bigint	no	Default 0
started_at	timestamp	no	Default now()
finished_at	timestamp	yes	—
error	text	yes	—
triggered_by_user_ref	bigint	yes	—

Constraints

• CONSTRAINT storage_sweep_runs_counts_check CHECK (((objects_scanned >= 0) AND (findings_count >= 0)))
• CONSTRAINT storage_sweep_runs_kind_check CHECK ((kind = ANY (ARRAY['orphan_scan'::text, 'checksum_verify'::text])))
• CONSTRAINT storage_sweep_runs_status_check CHECK ((status = ANY (ARRAY['running'::text, 'completed'::text, 'failed'::text])))

Full DDL

CREATE TABLE public.storage_sweep_runs (
    id uuid NOT NULL,
    kind text NOT NULL,
    status text DEFAULT 'running'::text NOT NULL,
    cursor text,
    objects_scanned bigint DEFAULT 0 NOT NULL,
    findings_count bigint DEFAULT 0 NOT NULL,
    started_at timestamp with time zone DEFAULT now() NOT NULL,
    finished_at timestamp with time zone,
    error text,
    triggered_by_user_ref bigint,
    CONSTRAINT storage_sweep_runs_counts_check CHECK (((objects_scanned >= 0) AND (findings_count >= 0))),
    CONSTRAINT storage_sweep_runs_kind_check CHECK ((kind = ANY (ARRAY['orphan_scan'::text, 'checksum_verify'::text]))),
    CONSTRAINT storage_sweep_runs_status_check CHECK ((status = ANY (ARRAY['running'::text, 'completed'::text, 'failed'::text])))
);

---

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