# Tasks: ActiveCampaign Tasks - Catalog: `ActiveCampaign` - Schema: `V3` - Primary Keys: `id` - Label: Tasks 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 | |---|:---:|---|:---:|---| | `assignee` | `int64` | Assignee | ☐ | | | `automation` | `int64` | Automation | ☐ | | | `cdate` | `datetime` | Created | ☐ | | | `dealTasktype` | `int64` | Task Type | ☑ | | | `doneAutomation` | `int64` | | ☐ | | | `duedate` | `datetime` | Due Date | ☑ | | | `edate` | `datetime` | | ☐ | | | `id` | `int64` | ID | ☑ | | | `note` | `varchar2` | Note | ☐ | | | `owner_id` | `int64` | Owner ID | ☑ | | | `owner_type` | `varchar2` | Owner Type | ☑ | | | `relid` | `int64` | Relationship ID | ☑ | | | `reltype` | `varchar2` | Relationship Type | ☑ | | | `status` | `int64` | Status | ☑ | | | `title` | `varchar2` | Title | ☐ | | | `udate` | `datetime` | Last Updated | ☐ | | | `user` | `int64` | User | ☑ | |