# ContactAutomations: ActiveCampaign Contact Automations - Catalog: `ActiveCampaign` - Schema: `V3` - Primary Keys: `id` - Label: Contact Automations Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `ContactAutomations` 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 | |---|:---:|---|:---:|---| | `adddate` | `datetime` | | ☑ | | | `automation` | `int64` | Automation | ☑ | | | `batchid` | `varchar2` | Batch ID | ☐ | | | `completed` | `int64` | Completed | ☑ | | | `completedElements` | `int64` | | ☑ | | | `completeValue` | `int64` | | ☑ | | | `contact` | `int64` | Contact | ☑ | | | `id` | `int64` | ID | ☑ | | | `lastblock` | `int64` | Last Block | ☑ | | | `lastdate` | `datetime` | Last Date | ☑ | | | `lastlogid` | `int64` | Last Log ID | ☑ | | | `remdate` | `datetime` | | ☐ | | | `seriesid` | `int64` | Series ID | ☑ | | | `startid` | `int64` | Start ID | ☑ | | | `status` | `int64` | Status | ☑ | | | `timespan` | `int64` | Timespan | ☐ | | | `totalElements` | `int64` | Total Elements | ☑ | |