Table: extraction_failure

Connected to

This table references:

• assets(id) via column asset_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
asset_id	uuid	no	References assets(id)
format	text	no	—
error_kind	text	no	—
message	text	no	—
field_key	text	no	Default ''::text
raw_value	jsonb	no	Default '{}'::jsonb
occurred_at	timestamp	no	Default now()
dismissed_at	timestamp	yes	—

Constraints

• CONSTRAINT extraction_failure_error_kind_check CHECK ((error_kind = ANY (ARRAY['unsupported_format'::text, 'malformed_file'::text, 'library_panic'::text, 'validation'::text, 'no_metadata'::text])))

Full DDL

CREATE TABLE public.extraction_failure (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    asset_id uuid NOT NULL,
    format text NOT NULL,
    error_kind text NOT NULL,
    message text NOT NULL,
    field_key text DEFAULT ''::text NOT NULL,
    raw_value jsonb DEFAULT '{}'::jsonb NOT NULL,
    occurred_at timestamp with time zone DEFAULT now() NOT NULL,
    dismissed_at timestamp with time zone,
    CONSTRAINT extraction_failure_error_kind_check CHECK ((error_kind = ANY (ARRAY['unsupported_format'::text, 'malformed_file'::text, 'library_panic'::text, 'validation'::text, 'no_metadata'::text])))
);

---

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