Table: workflow_states

Connected to

Referenced by:

• assets — column state_id
• posts — column state_id
• workflow_audit — columns from_state_id, to_state_id
• workflow_transitions — columns from_state_id, to_state_id

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
domain	text	no	—
code	text	no	—
label	text	no	—
sort_order	integer	no	Default 0
is_initial	boolean	no	Default false
is_terminal	boolean	no	Default false
visible_by_default	boolean	no	Default true
created_at	timestamp	no	Default now()
icon	text	no	Default ''::text
color	text	no	Default ''::text
requires_note	boolean	no	Default false

Full DDL

CREATE TABLE public.workflow_states (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    domain text NOT NULL,
    code text NOT NULL,
    label text NOT NULL,
    sort_order integer DEFAULT 0 NOT NULL,
    is_initial boolean DEFAULT false NOT NULL,
    is_terminal boolean DEFAULT false NOT NULL,
    visible_by_default boolean DEFAULT true NOT NULL,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    icon text DEFAULT ''::text NOT NULL,
    color text DEFAULT ''::text NOT NULL,
    requires_note boolean DEFAULT false NOT NULL
);

---

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