Skip to content

Workflows Schema

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


Workflow definitions.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNO—
nametextNO—
descriptiontextYES—
is_activebooleanNOtrue
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Steps/stages in a workflow.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
workflow_iduuidNO—
nametextNO—
orderintegerNO0
created_attimestamptzNOnow()

Allowed transitions between steps.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
workflow_iduuidNO—
from_step_iduuidNO—
to_step_iduuidNO—
nametextNO—
colortextYES—
orderintegerNO0
is_firstbooleanNOfalse
created_attimestamptzNOnow()

Role-based permissions for transitions.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
transition_iduuidNO—
permitted_user_iduuidYES—
permitted_roletextYES—
created_attimestamptzNOnow()

Active workflow instances.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
workflow_iduuidNO—
target_iduuidNO—
target_typetextNO—
current_step_iduuidNO—
statustextNO'initiated'
started_byuuidNO—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Audit log for workflow actions.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
instance_iduuidNO—
transition_iduuidYES—
user_iduuidNO—
actiontextNO—
commenttextYES—
created_attimestamptzNOnow()