# Automations: ActiveCampaign Automations - Catalog: `ActiveCampaign` - Schema: `V3` - Primary Keys: `id` - Label: Automations Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Automations` 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 | |---|:---:|---|:---:|---| | `cdate` | `datetime` | Created | ☑ | | | `defaultscreenshot` | `varchar2` | Default Screenshot | ☑ | | | `entered` | `varchar2` | | ☑ | | | `exited` | `varchar2` | | ☑ | | | `hidden` | `varchar2` | Hidden | ☑ | | | `mdate` | `datetime` | Last Modified | ☑ | | | `name` | `varchar2` | Name | ☑ | | | `screenshot` | `varchar2` | Screenshot | ☑ | | | `status` | `varchar2` | Status | ☑ | | | `userid` | `varchar2` | User ID | ☑ | |