Tasks queue

tasks_queue

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

Columns

Column	Type	Nullable	Default	Notes
task_id	uuid	NOT NULL	gen_random_uuid()	PK
task_metadata_id	uuid	YES		FK to tasks_metadata
input_variables	varchar	YES
process_start_time	timestamp	YES
created_time	timestamp	YES	now()
workspace_id	bigint	YES
options	jsonb	YES	{}
to_retry	bool	YES	false

Key indexes

• task_queue_pk -- PK on task_id
• idx_task_queue_partial -- on task_metadata_id WHERE process_start_time IS NOT NULL AND to_retry = false

---