Tasks metadata

tasks_metadata

• Schema: public
• PK: task_metadata_id (uuid, default gen_random_uuid())

Columns

Column	Type	Nullable	Default	Notes
task_metadata_id	uuid	NOT NULL	gen_random_uuid()	PK
task_type	varchar	NOT NULL
options	jsonb	YES
created_time	timestamp	YES	now()
created_by	bigint	NOT NULL		User ID
last_modified_time	timestamp	YES	now()
last_modified_by	varchar	YES
body	varchar	YES
workspace_id	bigint	YES
next_execution_time	timestamp	YES
task_name	varchar	YES
is_in_process	bool	YES	false
is_shared_with_workspace	bool	YES	false
start_time	timestamp	YES
is_paused	bool	YES	false
process_start_time	timestamp	YES

Key indexes

• tasks_metadata_pk -- PK on task_metadata_id
• unique_workspace_task -- UNIQUE on (workspace_id, task_name) WHERE all columns NOT NULL and next_execution_time IS NOT NULL

---