clickup_tasks

Details about ClickUp tasks

id

Primary key

Unique identifier for the row.

source_id

Foreign key

ID of the task in ClickUp

list_id

Foreign key

ID of the list to which the task belongs

creator_id

Foreign key

ID of the user who created the task

name

string

Name of the task

status

string

Custom status label of the task (e.g., "product backlog", "in progress", "done")

status_type

string

Normalized status type (e.g., "to do", "open", "done", "closed", "canceled", "backlog")

created_at

date

Creation timestamp of the task

updated_at

date

Last updated timestamp of the task

started_at

date

Timestamp of when the task began

finished_at

date

Timestamp of when the task was finished

closed_at

date

Timestamp of when the task was closed

started_to_finished

number

Difference (in seconds) of finished_at and started_at

source_url

string

URL of the task