# Messages: ActiveCampaign Messages - Catalog: `ActiveCampaign` - Schema: `V3` - Primary Keys: `id` - Label: Messages Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Messages` 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 | ☐ | | | `charset` | `varchar2` | Character Set | ☑ | | | `ed_instanceid` | `int64` | | ☑ | | | `ed_version` | `int64` | | ☑ | | | `encoding` | `varchar2` | Encoding | ☑ | | | `format` | `varchar2` | Format | ☑ | | | `fromemail` | `varchar2` | | ☐ | | | `fromname` | `varchar2` | From Name | ☐ | | | `hidden` | `int64` | Hidden | ☑ | | | `html` | `varchar2` | HTML | ☐ | | | `htmlfetch` | `varchar2` | | ☑ | | | `id` | `int64` | ID | ☑ | | | `mdate` | `datetime` | Last Modified | ☐ | | | `name` | `varchar2` | Name | ☐ | | | `preheader_text` | `varchar2` | Pre Header Text | ☐ | | | `preview_data` | `varchar2` | Preview Data | ☐ | | | `preview_mime` | `varchar2` | Preview MIME Type | ☐ | | | `priority` | `int64` | Priority | ☑ | | | `reply2` | `varchar2` | | ☐ | | | `subject` | `varchar2` | Subject | ☐ | | | `text` | `varchar2` | Text | ☐ | | | `textfetch` | `varchar2` | | ☑ | | | `user` | `int64` | User | ☐ | | | `userid` | `int64` | User ID | ☑ | |