Table: metadata_batch_preview

Connected to

This table references:

• field_definition(id) via column field_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
token_hash	bytea	no	—
caller_user_ref	bigint	no	—
field_id	uuid	no	References field_definition(id)
mode	text	no	—
would_change	integer	no	—
payload	jsonb	no	Default '{}'::jsonb
created_at	timestamp	no	Default now()
expires_at	timestamp	no	—
consumed_at	timestamp	yes	—

Constraints

• CONSTRAINT metadata_batch_preview_mode_check CHECK ((mode = ANY (ARRAY['overwrite'::text, 'fill_empties'::text, 'append'::text, 'remove'::text])))
• CONSTRAINT metadata_batch_preview_would_change_check CHECK ((would_change >= 0))

Full DDL

CREATE TABLE public.metadata_batch_preview (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    token_hash bytea NOT NULL,
    caller_user_ref bigint NOT NULL,
    field_id uuid NOT NULL,
    mode text NOT NULL,
    would_change integer NOT NULL,
    payload jsonb DEFAULT '{}'::jsonb NOT NULL,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    expires_at timestamp with time zone NOT NULL,
    consumed_at timestamp with time zone,
    CONSTRAINT metadata_batch_preview_mode_check CHECK ((mode = ANY (ARRAY['overwrite'::text, 'fill_empties'::text, 'append'::text, 'remove'::text]))),
    CONSTRAINT metadata_batch_preview_would_change_check CHECK ((would_change >= 0))
);

---

Please see the schema overview for context. This document was last regenerated on 2026-09-23T03:23:00.434Z.