Table: workflow_audit

Connected to

This table references:

• workflow_states(id) via column from_state_id
• workflow_states(id) via column to_state_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
resource_kind	text	no	—
resource_id	uuid	no	—
from_state_id	uuid	yes	References workflow_states(id)
to_state_id	uuid	no	References workflow_states(id)
actor_user_ref	bigint	yes	—
note	text	no	Default ''::text
transitioned_at	timestamp	no	Default now()

Full DDL

CREATE TABLE public.workflow_audit (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    resource_kind text NOT NULL,
    resource_id uuid NOT NULL,
    from_state_id uuid,
    to_state_id uuid NOT NULL,
    actor_user_ref bigint,
    note text DEFAULT ''::text NOT NULL,
    transitioned_at timestamp with time zone DEFAULT now() NOT NULL
);

---

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