asana_tasks
Details of Asana tasks.
-
id
Primary key - Unique identifier for the row.
-
source_id
Foreign key - Asana ID of the task.
-
workspace_id
Foreign key - ID of the workspace associated with the task.
-
assignee_id
Foreign key - ID of the user assigned to the task.
-
name
string - Name of the task.
-
approval_status
string - Approval status of the task.
-
created_at
date - Timestamp when the task was created.
-
started_at
date - Timestamp when the task was started this is interpreted from stories and section changes.
-
completed_at
date - Timestamp when the task was completed.
-
updated_at
date - Timestamp when the task was last updated.
-
started_to_finished
number - Time taken to complete the task (in seconds).
-
synced_at
date - Timestamp when the task was last synced.