Table: asset_field_value_history

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
asset_id	uuid	no	—
field_id	uuid	no	—
old_value	jsonb	yes	—
new_value	jsonb	yes	—
changed_at	timestamp	no	Default now()
changed_by_user_ref	bigint	yes	—
set_by	text	no	Default 'manual'::text

Full DDL

CREATE TABLE public.asset_field_value_history (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    asset_id uuid NOT NULL,
    field_id uuid NOT NULL,
    old_value jsonb,
    new_value jsonb,
    changed_at timestamp with time zone DEFAULT now() NOT NULL,
    changed_by_user_ref bigint,
    set_by text DEFAULT 'manual'::text NOT NULL
);

---

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