Table: storage_sweep_findings

Connected to

This table references:

• storage_sweep_runs(id) via column run_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	—
run_id	uuid	no	References storage_sweep_runs(id)
finding	text	no	—
object_hash	text	no	—
variant_key	text	no	—
detail	text	no	Default ''::text
detected_at	timestamp	no	Default now()
resolved_at	timestamp	yes	—

Constraints

• CONSTRAINT storage_sweep_findings_finding_check CHECK ((finding = ANY (ARRAY['missing_object'::text, 'orphan_object'::text, 'checksum_mismatch'::text, 'size_mismatch'::text])))

Full DDL

CREATE TABLE public.storage_sweep_findings (
    id uuid NOT NULL,
    run_id uuid NOT NULL,
    finding text NOT NULL,
    object_hash text NOT NULL,
    variant_key text NOT NULL,
    detail text DEFAULT ''::text NOT NULL,
    detected_at timestamp with time zone DEFAULT now() NOT NULL,
    resolved_at timestamp with time zone,
    CONSTRAINT storage_sweep_findings_finding_check CHECK ((finding = ANY (ARRAY['missing_object'::text, 'orphan_object'::text, 'checksum_mismatch'::text, 'size_mismatch'::text])))
);

---

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