Table: asset_field_value
Ce contenu n’est pas encore disponible dans votre langue.
Connected to
Section titled “Connected to”This table references:
assets(id) via columnasset_idfield_definition(id) via columnfield_id
Columns
Section titled “Columns”| Column | Type | Nullable | Notes |
|---|---|---|---|
asset_id | uuid | no | References assets(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 | UUID 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_by | text | no | Default 'manual'::text |
set_at | timestamp | no | Default now() |
set_by_user_ref | bigint | yes | - |
Constraints
Section titled “Constraints”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])))
Full DDL
Section titled “Full DDL”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.