Folders

folders

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

Columns

Column	Type	Nullable	Default	Notes
folder_id	uuid	NO	gen_random_uuid()	PK
folder_name	varchar	NO
folder_resource_id	varchar	NO		Human-readable resource ID
workspace_id	bigint	YES		FK to workspaces
parent_folders	jsonb	YES		Folder hierarchy path
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()

Key indexes

• resource_folder_structure_pkey on (folder_id)
• unique_folder_resource_id UNIQUE on (folder_resource_id, workspace_id)

Notes

• Organizes syncs, workflows, connections, variables, and app queues into a tree.
• Hard-deleted (no soft-delete status column).

---