Table: field_definition

Connected to

This table references:

• field_definition(id) via column deprecated_replacement_id

Referenced by:

• asset_field_value — column field_id
• collection_field_value — column field_id
• collection_field_value_history — column field_id
• field_definition — column deprecated_replacement_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
code	text	no	—
label	text	no	—
description	text	no	Default ''::text
type	text	no	—
options	jsonb	no	Default '{}'::jsonb
required	boolean	no	Default false
searchable	boolean	no	Default true
applies_to	bigint[]	no	Default '{}'::bigint[]
field_set_id	uuid	yes	—
read_capability	text	yes	—
write_capability	text	yes	—
display_order	integer	no	Default 100
display_group	text	no	Default 'general'::text
source	jsonb	yes	—
status	text	no	Default 'active'::text
deprecated_replacement_id	uuid	yes	References field_definition(id)
origin_server_id	uuid	yes	—
created_at	timestamp	no	Default now()
updated_at	timestamp	no	Default now()
created_by_user_ref	bigint	yes	—
updated_by_user_ref	bigint	yes	—
subject_kind	text	no	Default 'asset'::text
extraction_source	text	no	Default ''::text
extraction_mode	text	no	Default 'skip_if_set'::text

Constraints

• CONSTRAINT field_definition_extraction_mode_check CHECK ((extraction_mode = ANY (ARRAY['skip_if_set'::text, 'replace'::text, 'append'::text, 'prepend'::text])))
• CONSTRAINT field_definition_status_check CHECK ((status = ANY (ARRAY['active'::text, 'deprecated'::text, 'archived'::text])))
• CONSTRAINT field_definition_subject_kind_check CHECK ((subject_kind = ANY (ARRAY['asset'::text, 'collection'::text])))
• CONSTRAINT field_definition_type_check CHECK ((type = ANY (ARRAY['text'::text, 'longtext'::text, 'rich_text'::text, 'number'::text, 'boolean'::text, 'date'::text, 'datetime'::text, 'select'::text, 'multi_select'::text, 'tree'::text, 'reference'::text])))

Full DDL

CREATE TABLE public.field_definition (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    code text NOT NULL,
    label text NOT NULL,
    description text DEFAULT ''::text NOT NULL,
    type text NOT NULL,
    options jsonb DEFAULT '{}'::jsonb NOT NULL,
    required boolean DEFAULT false NOT NULL,
    searchable boolean DEFAULT true NOT NULL,
    applies_to bigint[] DEFAULT '{}'::bigint[] NOT NULL,
    field_set_id uuid,
    read_capability text,
    write_capability text,
    display_order integer DEFAULT 100 NOT NULL,
    display_group text DEFAULT 'general'::text NOT NULL,
    source jsonb,
    status text DEFAULT 'active'::text NOT NULL,
    deprecated_replacement_id uuid,
    origin_server_id uuid,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    updated_at timestamp with time zone DEFAULT now() NOT NULL,
    created_by_user_ref bigint,
    updated_by_user_ref bigint,
    subject_kind text DEFAULT 'asset'::text NOT NULL,
    extraction_source text DEFAULT ''::text NOT NULL,
    extraction_mode text DEFAULT 'skip_if_set'::text NOT NULL,
    CONSTRAINT field_definition_extraction_mode_check CHECK ((extraction_mode = ANY (ARRAY['skip_if_set'::text, 'replace'::text, 'append'::text, 'prepend'::text]))),
    CONSTRAINT field_definition_status_check CHECK ((status = ANY (ARRAY['active'::text, 'deprecated'::text, 'archived'::text]))),
    CONSTRAINT field_definition_subject_kind_check CHECK ((subject_kind = ANY (ARRAY['asset'::text, 'collection'::text]))),
    CONSTRAINT field_definition_type_check CHECK ((type = ANY (ARRAY['text'::text, 'longtext'::text, 'rich_text'::text, 'number'::text, 'boolean'::text, 'date'::text, 'datetime'::text, 'select'::text, 'multi_select'::text, 'tree'::text, 'reference'::text])))
);

---

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