Table: collection_field_value

Connected to

This table references:

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

Columns

Column	Type	Nullable	Notes
collection_id	uuid	no	References collections(id)
field_id	uuid	no	References field_definition(id)
value_text	text	yes	—
value_num	double	yes	—
value_date	timestamp	yes	—
value_options	text[]	yes	—
value_ref	uuid	yes	—
set_by	text	no	Default 'manual'::text
set_at	timestamp	no	Default now()
set_by_user_ref	bigint	yes	—

Constraints

• CONSTRAINT collection_field_value_set_by_check CHECK ((set_by = ANY (ARRAY['manual'::text, 'api'::text, 'import'::text, 'computed'::text])))

Full DDL

CREATE TABLE public.collection_field_value (
    collection_id uuid NOT NULL,
    field_id uuid NOT NULL,
    value_text text,
    value_num double precision,
    value_date timestamp with time zone,
    value_options text[],
    value_ref uuid,
    set_by text DEFAULT 'manual'::text NOT NULL,
    set_at timestamp with time zone DEFAULT now() NOT NULL,
    set_by_user_ref bigint,
    CONSTRAINT collection_field_value_set_by_check CHECK ((set_by = ANY (ARRAY['manual'::text, 'api'::text, 'import'::text, 'computed'::text])))
);

---

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