Workflows variables

workflows_variables

• Schema: public
• PK: variable_id (uuid, gen_random_uuid())

Columns

Column	Type	Nullable	Default	Notes
variable_id	uuid	NO	gen_random_uuid()	PK
workspace_id	bigint	NO		FK to workspaces
variable_name	varchar	NO
data	varchar	NO		Encrypted value
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()
variable_description	varchar	YES
variable_type	varchar	YES	'variable'	variable or secret
variable_resource_id	varchar	NO		Human-readable resource ID
parent_folders	jsonb	YES		Folder hierarchy path

Key indexes

• workflows_variables_pkey on (variable_id)
• unique_variable_name_per_workspace UNIQUE on (workspace_id, variable_name)

Notes

• Workspace-scoped key/value store; data is always encrypted regardless of variable_type.
• Referenced in workflow schemas via interpolation syntax.

---