Table: field_definition

Connected to

This table references:

• field_definition(id) via column deprecated_replacement_id

Referenced by:

• asset_field_value — column field_id
• asset_field_value_history — column field_id
• collection_field_value — column field_id
• collection_field_value_history — column field_id
• field_default_override — column field_id
• field_definition — column deprecated_replacement_id
• metadata_batch_preview — column field_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[]
read_capability	text	yes	—
write_capability	text	yes	—
display_order	integer	no	Default 100
display_group	text	no	Default 'general'::text
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
default_value	jsonb	yes	—
open_vocabulary	boolean	no	Default false
mirrors_column	text	yes	—
show_on_card	boolean	no	Default false
show_in_advanced_search	boolean	no	Default true
show_on_upload	boolean	no	Default true
edit_tab	text	yes	—
read_only	boolean	no	Default false
regexp_filter	text	yes	—
display_condition	jsonb	yes	—

Constraints

• CONSTRAINT field_definition_display_condition_shape_check CHECK (((display_condition IS NULL) OR ((jsonb_typeof(display_condition) = 'array'::text) AND (jsonb_array_length(display_condition) > 0) AND (NOT jsonb_path_exists(display_condition, '$[*]?(@.type() != "string")'::jsonpath)) AND (NOT jsonb_path_exists(display_condition, '$[*]?(@ like_regex "^\\s*$")'::jsonpath)))))
• CONSTRAINT field_definition_edit_tab_nonblank_check CHECK (((edit_tab IS NULL) OR (btrim(edit_tab) <> ''::text)))
• CONSTRAINT field_definition_extraction_mode_check CHECK ((extraction_mode = ANY (ARRAY['skip_if_set'::text, 'replace'::text, 'append'::text, 'prepend'::text])))
• CONSTRAINT field_definition_mirrors_column_check CHECK (((mirrors_column IS NULL) OR (mirrors_column = ANY (ARRAY['title'::text, 'description'::text]))))
• CONSTRAINT field_definition_mirrors_column_subject_check CHECK (((mirrors_column IS NULL) OR (subject_kind = 'asset'::text)))
• CONSTRAINT field_definition_mirrored_input_rules_check CHECK (((mirrors_column IS NULL) OR ((read_only IS FALSE) AND (regexp_filter IS NULL))))
• CONSTRAINT field_definition_regexp_filter_nonempty_check CHECK (((regexp_filter IS NULL) OR (regexp_filter <> ''::text)))
• CONSTRAINT field_definition_show_on_card_ungated_check CHECK ((NOT (show_on_card AND (COALESCE(read_capability, ''::text) <> ''::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,
    read_capability text,
    write_capability text,
    display_order integer DEFAULT 100 NOT NULL,
    display_group text DEFAULT 'general'::text NOT NULL,
    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,
    default_value jsonb,
    open_vocabulary boolean DEFAULT false NOT NULL,
    mirrors_column text,
    show_on_card boolean DEFAULT false NOT NULL,
    show_in_advanced_search boolean DEFAULT true NOT NULL,
    show_on_upload boolean DEFAULT true NOT NULL,
    edit_tab text,
    read_only boolean DEFAULT false NOT NULL,
    regexp_filter text,
    display_condition jsonb,
    CONSTRAINT field_definition_display_condition_shape_check CHECK (((display_condition IS NULL) OR ((jsonb_typeof(display_condition) = 'array'::text) AND (jsonb_array_length(display_condition) > 0) AND (NOT jsonb_path_exists(display_condition, '$[*]?(@.type() != "string")'::jsonpath)) AND (NOT jsonb_path_exists(display_condition, '$[*]?(@ like_regex "^\\s*$")'::jsonpath))))),
    CONSTRAINT field_definition_edit_tab_nonblank_check CHECK (((edit_tab IS NULL) OR (btrim(edit_tab) <> ''::text))),
    CONSTRAINT field_definition_extraction_mode_check CHECK ((extraction_mode = ANY (ARRAY['skip_if_set'::text, 'replace'::text, 'append'::text, 'prepend'::text]))),
    CONSTRAINT field_definition_mirrors_column_check CHECK (((mirrors_column IS NULL) OR (mirrors_column = ANY (ARRAY['title'::text, 'description'::text])))),
    CONSTRAINT field_definition_mirrors_column_subject_check CHECK (((mirrors_column IS NULL) OR (subject_kind = 'asset'::text))),
    CONSTRAINT field_definition_mirrored_input_rules_check CHECK (((mirrors_column IS NULL) OR ((read_only IS FALSE) AND (regexp_filter IS NULL)))),
    CONSTRAINT field_definition_regexp_filter_nonempty_check CHECK (((regexp_filter IS NULL) OR (regexp_filter <> ''::text))),
    CONSTRAINT field_definition_show_on_card_ungated_check CHECK ((NOT (show_on_card AND (COALESCE(read_capability, ''::text) <> ''::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-09-23T03:23:00.434Z.