# Notes: ActiveCampaign Notes - Catalog: `ActiveCampaign` - Schema: `V3` - Primary Keys: `id` - Label: Notes - Retrieve: True - Insert: True - Update: True - Delete: False ## Table Columns The columns of the table `Notes` 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 | ☐ | Moment of creation. | | `id` | `int64` | ID | ☑ | Unique ID. | | `is_draft` | `int64` | Is Draft | ☐ | Whether the note has not been finished yet. | | `listId` | `int64` | List ID | ☐ | List the note is limited to. Can be given when a note on a contact is recorded and is never answered back, so it is always empty when read. | | `mdate` | `datetime` | Last Modified | ☐ | Moment of last change. | | `note` | `varchar2` | Note | ☑ | Text of the note. | | `relid` | `int64` | Relationship ID | ☑ | ID of the record the note belongs to. | | `reltype` | `varchar2` | Relationship Type | ☑ | Kind of record the note belongs to, such as Subscriber for a contact, Deal, CustomerAccount or Activity. | | `user` | `int64` | User | ☐ | ID of the user that wrote the note. | | `userid` | `int64` | User ID | ☐ | ID of the user that wrote the note. |