Table: collection_field_value_history

Connected to

This table references:

• collections(id) via column collection_id
• field_definition(id) via column field_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
collection_id	uuid	no	References collections(id)
field_id	uuid	no	References field_definition(id)
old_value	jsonb	yes	—
new_value	jsonb	yes	—
set_by	text	no	Default 'manual'::text
changed_by_user_ref	bigint	yes	—
changed_at	timestamp	no	Default now()

Full DDL

CREATE TABLE public.collection_field_value_history (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    collection_id uuid NOT NULL,
    field_id uuid NOT NULL,
    old_value jsonb,
    new_value jsonb,
    set_by text DEFAULT 'manual'::text NOT NULL,
    changed_by_user_ref bigint,
    changed_at timestamp with time zone DEFAULT now() NOT NULL
);

---

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