Workflows Schema

ext_workflows - Workflows

Schema: ext_workflows | Auto-generated on 2026-03-30

---

workflows

Workflow definitions.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	—
name	text	NO	—
description	text	YES	—
is_active	boolean	NO	true
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

workflow_steps

Steps/stages in a workflow.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
workflow_id	uuid	NO	—
name	text	NO	—
order	integer	NO	0
created_at	timestamptz	NO	now()

workflow_transitions

Allowed transitions between steps.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
workflow_id	uuid	NO	—
from_step_id	uuid	NO	—
to_step_id	uuid	NO	—
name	text	NO	—
color	text	YES	—
order	integer	NO	0
is_first	boolean	NO	false
created_at	timestamptz	NO	now()

workflow_transition_permissions

Role-based permissions for transitions.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
transition_id	uuid	NO	—
permitted_user_id	uuid	YES	—
permitted_role	text	YES	—
created_at	timestamptz	NO	now()

workflow_instances

Active workflow instances.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
workflow_id	uuid	NO	—
target_id	uuid	NO	—
target_type	text	NO	—
current_step_id	uuid	NO	—
status	text	NO	'initiated'
started_by	uuid	NO	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

workflow_logs

Audit log for workflow actions.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
instance_id	uuid	NO	—
transition_id	uuid	YES	—
user_id	uuid	NO	—
action	text	NO	—
comment	text	YES	—
created_at	timestamptz	NO	now()