Aller au contenu

Table: asset_field_value

Ce contenu n’est pas encore disponible dans votre langue.

This table references:

ColumnTypeNullableNotes
asset_iduuidnoReferences assets(id)
field_iduuidnoReferences field_definition(id)
value_texttextyes-
value_numdoubleyes-
value_datetimestampyes-
value_optionstext[]yes-
value_refuuidyesUUID value for reference-typed fields. One of the table’s per-type value columns alongside value_text, value_num, value_date and value_options; the _ref suffix here doesn’t follow the schema-wide convention of _ref for BIGINT foreign keys.
set_bytextnoDefault 'manual'::text
set_attimestampnoDefault now()
set_by_user_refbigintyes-
  • CONSTRAINT asset_field_value_set_by_check CHECK ((set_by = ANY (ARRAY['manual'::text, 'exif'::text, 'iptc'::text, 'xmp'::text, 'api'::text, 'import'::text, 'computed'::text, 'default'::text])))

This is the table’s CREATE TABLE statement. Constraints added with separate ALTER TABLE statements, including foreign-key ON DELETE rules, and indexes are defined elsewhere in the dump; see the complete app/schema.sql.

CREATE TABLE public.asset_field_value (
asset_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 asset_field_value_set_by_check CHECK ((set_by = ANY (ARRAY['manual'::text, 'exif'::text, 'iptc'::text, 'xmp'::text, 'api'::text, 'import'::text, 'computed'::text, 'default'::text])))
);

See the schema overview for context.