Workflow email routes

workflow_email_routes

• Schema: public
• PK: workflow_email_route_id (uuid)

Columns

Column	Type	Nullable	Default	Notes
workflow_email_route_id	uuid	NO		PK
workspace_id	bigint	NO		FK to workspaces
workflow_id	uuid	NO		FK to workflows
workflow_module_instance_id	text	NO		Target module instance
workflow_version	text	YES
email_provider	text	NO		e.g. mailgun, ses
email_alias	text	YES		Inbound email address alias
status	text	YES	'active'
created_by	bigint	YES
created_time	timestamptz	YES	now()
last_modified_by	bigint	YES
last_modified_time	timestamptz	YES	now()

Key indexes

• workflow_email_routes_pkey on (workflow_email_route_id)
• workflow_email_routes_unique_trigger UNIQUE on (workspace_id, workflow_id, workflow_module_instance_id)
• uq_workflow_email_routes_email_alias UNIQUE on (email_alias) WHERE email_alias IS NOT NULL

Notes

• Maps inbound email addresses to workflow trigger modules.
• Each alias is globally unique to prevent routing collisions.

---