Workflows modules

workflows_modules

• Schema: public
• PK: module_id (varchar)

Columns

Column	Type	Nullable	Default	Notes
module_id	varchar	NO		PK
app_type	varchar	NO		Integration type slug
module_type	varchar	NO		e.g. trigger, action, transform
module_category	varchar	NO		Grouping category
module_name	varchar	NO		Display name
module_version	varchar	NO
module_schema	jsonb	NO		Base module configuration
module_input_schema	jsonb	NO		JSON Schema for inputs
module_input_ui_schema	jsonb	YES		UI rendering hints
module_output_schema	jsonb	NO		JSON Schema for outputs
module_actions_schema	jsonb	NO		Available actions definition
module_errorhandling_schema	jsonb	NO		Error handling options
options	jsonb	YES
created_by	bigint	NO
created_time	timestamp	YES	now()
last_modified_by	bigint	NO
last_modified_time	timestamp	YES	now()
module_description	varchar	YES
is_archived	bool	YES	false

Key indexes

• workflows_modules_pkey on (module_id)

Notes

• Module registry -- defines every available building block for the workflow editor.
• Schemas drive both backend validation and frontend form rendering.

---