Workflows versions

workflows_versions

• Schema: public
• PK: id (varchar)

Columns

Column	Type	Nullable	Default	Notes
id	varchar	NO		PK (composite key string)
workflow_id	uuid	NO		FK to workflows
workflow_status	varchar	NO		Version-level status
workflow_schema	jsonb	YES	(default template)	Full workflow graph definition
options	jsonb	YES
workflow_version	varchar	NO		Semantic or ordinal version
created_by	bigint	NO		FK to users
created_time	timestamp	YES	now()
last_modified_by	bigint	NO		FK to users
last_modified_time	timestamp	YES	now()
is_draft	bool	YES	true
is_deployed	bool	YES	false
workflow_pending_updates	jsonb	YES	[]	Queued schema changes not yet deployed

Key indexes

• workflows_versions_pkey on (id)

Notes

• Each workflow can have multiple versions; is_deployed marks the live version.
• workflow_schema contains the full module graph (nodes, edges, configs).

---