# Tasks ## Documentation The tasks of the projects. Each request costs 10 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Projects` - Primary Keys: `id` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Tasks` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `add_time` | `datetime` | | ☐ | The creation date and time of the task in ISO 8601 format. | | `assignee_id` | `int64` | | ☐ | The ID of the user assigned to the task. Only taken when writing; empty when read. | | `assignee_ids` | `varchar2` | | ☐ | The IDs of users assigned to the task. | | `creator_id` | `int64` | | ☐ | The ID of the user who created the task. | | `description` | `varchar2` | | ☐ | The description of the task. | | `done` | `int64` | | ☐ | Whether the task is done or not. Only taken when writing; empty when read. | | `due_date` | `datetime` | | ☐ | The due date of the task. | | `id` | `int64` | | ☑ | The ID of the task. | | `is_done` | `char` | | ☐ | Whether the task is done or not. | | `is_milestone` | `char` | | ☐ | Whether the task is a milestone or not. | | `marked_as_done_time` | `datetime` | | ☐ | The date and time the task was marked as done in ISO 8601 format. | | `milestone` | `int64` | | ☐ | Whether the task is a milestone or not. Only taken when writing; empty when read. | | `parent_task_id` | `int64` | | ☐ | The ID of the parent task. | | `priority` | `int64` | | ☐ | The priority of the task. | | `project_id` | `int64` | | ☐ | The ID of the project this task is associated with. | | `start_date` | `datetime` | | ☐ | The start date of the task. | | `title` | `varchar2` | | ☐ | The title of the task. | | `update_time` | `datetime` | | ☐ | The update date and time of the task in ISO 8601 format. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `assignee_id` | [[Users-Users\|Users.Users]] | `id` | Declared by the connector, not enforced by the platform | | `creator_id` | [[Users-Users\|Users.Users]] | `id` | Declared by the connector, not enforced by the platform | | `parent_task_id` | [[Projects-Tasks\|Projects.Tasks]] | `id` | Declared by the connector, not enforced by the platform | | `project_id` | [[Projects-Projects\|Projects.Projects]] | `id` | In words only: The project, in Projects or, once archived, in ArchivedProjects. | | `project_id` | [[Projects-ArchivedProjects\|Projects.ArchivedProjects]] | `id` | In words only: The project, in Projects or, once archived, in ArchivedProjects. | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Notes-Notes\|Notes.Notes]] | `task_id` | Declared by the connector, not enforced by the platform | | [[Projects-Tasks\|Projects.Tasks]] | `parent_task_id` | Declared by the connector, not enforced by the platform |