# Lists: ActiveCampaign Lists - Catalog: `ActiveCampaign` - Schema: `V3` - Primary Keys: `id` - Label: Lists Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Lists` 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 | |---|:---:|---|:---:|---| | `analytics_domains` | `varchar2` | Analytics Domains | ☐ | | | `analytics_source` | `varchar2` | Analytics Source | ☐ | | | `analytics_ua` | `varchar2` | | ☐ | | | `carboncopy` | `varchar2` | Carbon Copy | ☐ | Comma-separated list of email addresses to send a copy of all mailings to upon send. | | `cdate` | `datetime` | Created | ☑ | | | `deletestamp` | `datetime` | Deleted | ☐ | | | `facebook_session` | `varchar2` | | ☐ | | | `fulladdress` | `varchar2` | Full Address | ☐ | | | `get_unsubscribe_reason` | `int64` | | ☑ | | | `id` | `int64` | ID | ☑ | Unique ID. | | `name` | `varchar2` | Name | ☑ | Name. | | `optinmessageid` | `int64` | Opt-in Message ID | ☑ | | | `optinoptout` | `int64` | Opt-in Opt-out | ☑ | | | `optoutconf` | `int64` | | ☑ | | | `p_embed_image` | `int64` | | ☑ | | | `p_use_analytics_link` | `int64` | | ☑ | | | `p_use_analytics_read` | `int64` | | ☑ | | | `p_use_captcha` | `int64` | | ☑ | | | `p_use_facebook` | `int64` | | ☑ | | | `p_use_tracking` | `int64` | | ☑ | | | `p_use_twitter` | `int64` | | ☑ | | | `private` | `int64` | Private | ☑ | | | `require_name` | `int64` | | ☑ | | | `send_last_broadcast` | `int64` | Send Last Broadcast | ☑ | | | `sender_addr1` | `varchar2` | Sender Address Line 1 | ☐ | | | `sender_addr2` | `varchar2` | Sender Address Line 2 | ☐ | | | `sender_city` | `varchar2` | Sender City | ☐ | | | `sender_country` | `varchar2` | Sender Country | ☐ | | | `sender_name` | `varchar2` | Sender Name | ☐ | | | `sender_phone` | `varchar2` | Sender Phone | ☐ | | | `sender_reminder` | `varchar2` | Sender Reminder | ☐ | A reminder for your contacts as to why they are on this list and you are messaging them. | | `sender_state` | `varchar2` | Sender State | ☐ | | | `sender_url` | `varchar2` | Sender URL | ☐ | Website URL this list is for. | | `sender_zip` | `varchar2` | Sender ZIP Code | ☐ | | | `stringid` | `varchar2` | String ID | ☑ | URL-safe list name. | | `subscription_notify` | `varchar2` | Subscription Notify | ☐ | Comma-separated list of email addresses to notify when a new subscriber joins this list. | | `to_name` | `varchar2` | To Name | ☑ | | | `twitter_token_secret` | `varchar2` | Twitter Token Secret | ☐ | | | `twitter_token` | `varchar2` | Twitter Token | ☐ | | | `udate` | `datetime` | Last Updated | ☐ | | | `unsubscription_notify` | `varchar2` | Unsubscription Notify | ☐ | Comma-separated list of email addresses to notify when a subscriber unsubscribes from this list. | | `user` | `int64` | User | ☐ | | | `userid` | `int64` | User ID | ☑ | |