ActiveCampaign

Explore the interactive ERD

Table & Field Reference

branding

Column	Type	Keys
`id`	String	PK
`group_id`	String	FK
`admin_template_css`	String
`admin_template_css_backup`	String
`admin_template_htm`	String
`admin_template_htm_backup`	String
`copyright`	String
`favicon`	String
`footer_html_value`	String
`footer_text_value`	String
`header_html_value`	String
`header_text_value`	String
`help`	String
`license`	String
`links`	String
`public_template_css`	String
`public_template_htm`	String
`site_logo`	String
`site_logo_small`	String
`site_name`	String
`version`	String

account_contact

Column	Type	Keys
`account_contact`	Unknown	PK
`contact_id`	Unknown	PKFK

contact

Column	Type	Keys
`id`	Unknown	PK
`a_date`	Unknown
`anonymized`	Unknown
`bounced_date`	Unknown
`bounced_hard`	Unknown
`bounced_soft`	Unknown
`c_date`	Unknown
`created_by`	Unknown
`created_timestamp`	Unknown
`created_utc_timestamp`	Unknown
`deleted`	Unknown
`deleted_at`	Unknown
`e_date`	Unknown
`email`	Unknown
`email_domain`	Unknown
`email_local`	Unknown
`first_name`	Unknown
`gravatar`	Unknown
`hash`	Unknown
`ip`	Unknown
`last_name`	Unknown
`mpp_tracking`	Unknown
`org_name`	Unknown
`organization`	Unknown
`phone`	Unknown
`rating_tstamp`	Unknown
`score_value`	Json
`segmentio_id`	Unknown
`sentcnt`	Unknown
`socialdata_lastcheck`	Unknown
`u_date`	Unknown
`ua`	Unknown
`updated_by`	Unknown
`updated_timestamp`	Unknown
`updated_utc_timestamp`	Unknown

contact_tag

Column	Type	Keys
`id`	Unknown	PK
`contact`	Unknown	FK
`c_date`	Unknown
`created_by`	Unknown
`created_timestamp`	Unknown
`tags`	Unknown
`updated_by`	Unknown
`updated_timestamp`	Unknown

contact_list

Column	Type	Keys
`id`	Unknown	PK
`contact_id`	Unknown	PKFK
`list`	Unknown	FK
`automation`	Unknown
`autosync_log`	Unknown
`campaign`	Unknown
`created_by`	Unknown
`created_timestamp`	Unknown
`first_name`	Unknown
`form`	Unknown
`ip_4_last`	Unknown
`ip_4_sub`	Unknown
`ip_4_unsub`	Unknown
`last_name`	Unknown
`links_automation`	Unknown
`links_autosync_log`	Unknown
`links_campaign`	Unknown
`links_contact`	Unknown
`links_form`	Unknown
`links_list`	Unknown
`links_message`	Unknown
`links_unsubscribe_automation`	Unknown
`message`	Unknown
`responder`	Unknown
`s_date`	Unknown
`series_id`	Unknown
`source_id`	Unknown
`status`	Unknown
`sync`	Unknown
`u_date`	Unknown
`unsubreason`	Unknown
`unsubscribe_automation`	Unknown
`updated_by`	Unknown
`updated_timestamp`	Unknown

contact_custom_field_value

Column	Type	Keys
`id`	String	PK
`contact`	String	FK
`custom_field_id`	String	FK
`c_date`	Unknown
`u_date`	Unknown
`value`	String

score

Column	Type	Keys
`id`	String	PK
`c_date`	Unknown
`descript`	String
`links`	Json
`m_date`	Unknown
`name`	String
`rel_type`	String
`status`	String

automation

Column	Type	Keys
`id`	String	PK
`user_id`	String	FK
`c_date`	Unknown
`default_screenshot`	String
`entered`	String
`entitlements_violation`	String
`exited`	String
`hidden`	String
`m_date`	Unknown
`name`	String
`screenshot`	String
`status`	String

segment

Column	Type	Keys
`id`	String	PK
`created_by`	String
`created_timestamp`	String
`hidden`	String
`logic`	String
`name`	String
`segment_id_v_2`	String
`series_id`	String
`updated_by`	String
`updated_timestamp`	String

deal_custom_field_option

Column	Type	Keys
`field_option`	String	PK
`deal_custom_field_id`	String	PKFK

deal_custom_field

Column	Type	Keys
`id`	String	PK
`created_timestamp`	String
`display_order`	String
`field_default`	String
`field_default_currency`	String
`field_label`	String
`field_type`	String
`hide_field_flag`	String
`is_form_visible`	String
`is_required`	String
`known_field_id`	String
`personalization`	String
`updated_timestamp`	String

connection

Column	Type	Keys
`id`	String	PK
`c_date`	Unknown
`external_id`	String
`is_internal`	String
`last_sync`	String
`link_url`	String
`logo_url`	String
`name`	String
`service`	String
`status`	String
`sync_status`	String
`u_date`	Unknown

deal_activity

Column	Type	Keys
`id`	Unknown	PK
`deal_id`	Unknown	FK
`deal_stage_id`	Unknown	FK
`user_id`	Unknown	FK
`automation`	Unknown
`c_date`	Unknown
`data_action`	Unknown
`data_id`	Unknown
`data_oldval`	Unknown
`data_type`	Unknown
`deleted`	Unknown
`is_add_task`	Unknown
`series_id`	Unknown
`sort_date`	Unknown
`stage`	Unknown

user_group

Column	Type	Keys
`id`	String	PK
`group_id`	String	FK
`user_id`	String	FK
`c_date`	String
`u_date`	Unknown

list

Column	Type	Keys
`id`	String	PK
`user_id`	String	FK
`analytics_domains`	String
`analytics_source`	String
`analytics_ua`	String
`c_date`	Unknown
`carbon_copy`	String
`created_by`	String
`created_timestamp`	String
`delete_stamp`	String
`facebook_session`	String
`full_address`	String
`get_unsubscribe_reason`	String
`name`	String
`optin_message_id`	String
`optin_optout`	String
`optout_conf`	String
`p_embed_image`	String
`p_use_analytics_link`	String
`p_use_analytics_read`	String
`p_use_captcha`	String
`p_use_facebook`	String
`p_use_tracking`	String
`p_use_twitter`	String
`private`	String
`require_name`	String
`send_last_broadcast`	String
`sender_addr_1`	String
`sender_addr_2`	String
`sender_city`	String
`sender_country`	String
`sender_name`	String
`sender_phone`	String
`sender_reminder`	String
`sender_state`	String
`sender_url`	String
`sender_zip`	String
`stringid`	String
`subscription_notify`	String
`to_name`	String
`twitter_token`	String
`twitter_token_secret`	String
`u_date`	Unknown
`unsubscription_notify`	String
`updated_by`	String
`updated_timestamp`	String

users

Column	Type	Keys
`id`	String	PK
`c_date`	Unknown
`email`	String
`first_name`	String
`lang`	String
`last_name`	String
`local_zone_id`	String
`mfa_enabled`	String
`phone`	String
`signature`	String
`u_date`	Unknown
`username`	String

order_product

Column	Type	Keys
`id`	String	PK
`connection_id`	String	FK
`e_com_order`	Unknown	FK
`category`	String
`created_date`	String
`description`	String
`external_id`	String
`image_url`	String
`name`	String
`order_id`	String
`price`	String
`product_url`	String
`quantity`	String
`sku`	String
`tstamp`	String
`updated_date`	String

task

Column	Type	Keys
`id`	String	PK
`owner_id`	String	FK
`user_id`	String	FK
`assigned_date`	String
`assignee`	String
`automation`	String
`c_date`	String
`created_utc_timestamp`	String
`deal_task_type`	String
`done_automation`	String
`done_by`	String
`done_date`	String
`done_utc_timestamp`	String
`due_date`	String
`duration`	String
`e_date`	Unknown
`note`	String
`outcome_id`	String
`outcome_info`	String
`owner_type`	String
`rel_id`	String
`rel_title`	String
`rel_type`	String
`status`	String
`title`	String
`trigger_automation_on_create`	String
`u_date`	Unknown
`updated_by`	String
`updated_utc_timestamp`	String

custom_account_field_value

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`custom_field_id`	String	FK
`account_custom_field_metum_id`	String
`created_timestamp`	String
`field_value`	String
`updated_timestamp`	String

campaign

Column	Type	Keys
`id`	String	PK
`address_id`	String	FK
`user_id`	String	FK
`activerss_interval`	String
`activerss_items`	String
`activerss_url`	String
`analytics_campaign_name`	String
`automation`	String
`base_message_id`	String
`base_template_id`	String
`bounce_id`	String
`c_date`	Unknown
`campaign_message_id`	String
`can_skip_approval`	String
`created_by`	String
`created_timestamp`	String
`delete_stamp`	String
`ed_version`	String
`embed_images`	String
`facebook`	String
`form_id`	String
`forwards`	String
`hard_bounces`	String
`has_predictive_content`	String
`html_un_sub`	String
`html_un_sub_data`	String
`ip`	String
`ip_4`	String
`l_date`	Unknown
`last_step`	String
`link_clicks`	String
`m_date`	Unknown
`mail_cleanup`	String
`mail_send`	String
`mail_transfer`	String
`mailer_log_file`	String
`manage_text`	String
`message_id`	String
`name`	String
`opens`	String
`public`	String
`realc_id`	String
`recurring`	String
`reminder_field`	String
`reminder_format`	String
`reminder_last_cron_run`	String
`reminder_offset`	String
`reminder_offset_sign`	String
`reminder_offset_type`	String
`reminder_type`	String
`replies`	String
`replysys`	String
`responder_existing`	String
`responder_offset`	String
`responder_type`	String
`s_date`	Unknown
`schedule`	String
`scheduled_date`	String
`screenshot`	String
`segment_id`	String
`segment_name`	String
`send_amt`	String
`send_id`	String
`series_id`	String
`series_send_lock_time`	String
`social_shares`	String
`soft_bounces`	String
`source`	String
`split_content`	String
`split_offset`	String
`split_offset_type`	String
`split_type`	String
`split_winner_awaiting`	String
`split_winner_messageid`	String
`status`	String
`subscriber_clicks`	String
`survey`	String
`text_unsub`	String
`text_unsub_data`	String
`thread_id`	String
`total_amt`	String
`track_links`	String
`track_links_analytics`	String
`track_reads`	String
`track_reads_analytics`	String
`tweet`	String
`type`	String
`unique_forwards`	String
`unique_link_clicks`	String
`unique_opens`	String
`unique_replies`	String
`unsub_reasons`	String
`unsubscribes`	String
`updated_by`	String
`updated_timestamp`	String
`updates`	String
`use_quartz_scheduler`	String
`wait_preview`	String
`will_recur`	String

e_com_order_product

Column	Type	Keys
`_fivetran_id`	String	PK
`e_com_order_id`	String	FK
`product_id`	String

e_com_order

Column	Type	Keys
`id`	String	PK
`connection`	String	FK
`customer_id`	String	FK
`created_date`	String
`currency`	String
`discount_amount`	String
`email`	String
`external_created_date`	String
`external_id`	String
`order_date`	String
`order_url`	String
`shipping_amount`	String
`shipping_method`	String
`source`	String
`state`	String
`tax_amount`	String
`total_price`	String
`total_products`	String
`tstamp`	String
`updated_date`	String

deal_custom_field_value

Column	Type	Keys
`id`	String	PK
`custom_field_id`	String	FK
`deal_id`	String	FK
`created_timestamp`	String
`deal_custom_field_metum_id`	String
`field_value`	String
`updated_timestamp`	String

group_limit

Column	Type	Keys
`id`	String	PK
`group_id`	String	FK
`abuse_ratio`	String
`force_sender_info`	String
`limit_attachment`	String
`limit_campaign`	String
`limit_campaign_type`	String
`limit_contact`	String
`limit_list`	String
`limit_mail`	String
`limit_mail_type`	String
`limit_user`	String

e_com_customer

Column	Type	Keys
`id`	String	PK
`connection_id`	String	FK
`avg_product_category`	String
`avg_revenue_perorder`	String
`email`	String
`external_id`	String
`time_stamp`	String
`total_orders`	String
`total_products`	String
`total_revenue`	String

schema_field

Column	Type	Keys
`id`	String	PK
`schema_id`	String	PKFK
`labels_plural`	String
`labels_singular`	String
`required`	Boolean
`scale`	Unknown
`type`	String

schema_relationship

Column	Type	Keys
`id`	String	PK
`schema_id`	String	PKFK
`description`	String
`has_many`	String
`labels_plural`	String
`labels_singular`	String
`namespace`	String

schema

Column	Type	Keys
`id`	String	PK
`created_timestamp`	String
`description`	String
`icons_default`	String
`labels_plural`	String
`labels_singular`	String
`slug`	String
`updated_timestamp`	String
`visibility`	String

note

Column	Type	Keys
`id`	String	PK
`owner_id`	String	FK
`user_id`	String	FK
`c_date`	Unknown
`is_draft`	String
`m_date`	Unknown
`note`	String
`owner_type`	String
`rel_id`	String
`rel_type`	String

deal

Column	Type	Keys
`id`	String	PK
`account`	String	FK
`contact`	String	FK
`next_deal_id`	String	FK
`next_task_id`	String	FK
`owner`	String	FK
`activity_count`	String
`c_date`	String
`currency`	String
`customer_account`	String
`description`	String
`e_date`	String
`groups`	String
`hash`	String
`is_disabled`	Boolean
`m_date`	String
`next_date`	String
`organization`	String
`percentage`	String
`stage`	String
`status`	String
`title`	String
`value`	String
`win_probability`	String
`win_probability_mdate`	String

contact_custom_field

Column	Type	Keys
`id`	String	PK
`c_date`	Unknown
`cols`	String
`defval`	String
`descript`	String
`is_required`	String
`options`	Json
`order_num`	String
`perstag`	String
`relations`	Json
`rows`	String
`service`	String
`show_in_list`	String
`title`	String
`type`	String
`u_date`	Unknown
`visible`	String

task_outcome

Column	Type	Keys
`id`	String	PK
`created_by`	String
`created_utc_timestamp`	String
`deal_tasktype_ids`	Json
`disabled`	String
`sentiment`	String
`title`	String
`updated_by`	String
`updated_utc_timestamp`	String

role

Column	Type	Keys
`id`	String	PK
`created_timestamp`	String
`title`	String
`updated_timestamp`	String

email_activity

Column	Type	Keys
`id`	Unknown	PK
`connection_id`	Unknown	FK
`contact_id`	Unknown	FK
`deal_id`	Unknown	FK
`message_id`	Unknown	FK
`rel_id`	Unknown	FK
`user_id`	Unknown	FK
`account`	Unknown
`automation_name`	Unknown
`cc_address`	Unknown
`file`	Unknown
`from_address`	Unknown
`from_name`	Unknown
`message`	Unknown
`series_id`	Unknown
`service_provider`	Unknown
`subject`	Unknown
`subscriber_series_id`	Unknown
`to_address`	Unknown
`tstamp`	Unknown

saved_response

Column	Type	Keys
`id`	String	PK
`last_sent_user_id`	String	FK
`body`	String
`c_date`	Unknown
`l_date`	Unknown
`m_date`	Unknown
`subject`	String
`title`	String

custom_field_option

Column	Type	Keys
`field_option`	String	PK
`custom_account_field_id`	String	PKFK

custom_account_field

Column	Type	Keys
`id`	String	PK
`created_by`	String
`created_timestamp`	String
`display_order`	Unknown
`field_default`	String
`field_default_currency`	String
`field_label`	String
`field_type`	String
`hide_field_flag`	Unknown
`is_form_visible`	Unknown
`is_required`	Unknown
`known_field_id`	Unknown
`personalization`	String
`updated_by`	String
`updated_timestamp`	String

campaign_report_open

Column	Type	Keys
`tstamp`	Unknown	PK
`campaign_id`	Unknown	PKFK
`contact_id`	Unknown	PKFK
`time`	Unknown

secondary_contact

Column	Type	Keys
`id`	String	PK
`contact`	String	FK
`deal`	String	FK
`c_date`	Unknown

calendar

Column	Type	Keys
`id`	String	PK
`user_id`	String	FK
`c_date`	String
`m_date`	Unknown
`notification`	String
`title`	String
`token`	String
`type`	String

campaign_report_link_info

Column	Type	Keys
`index`	Unknown	PK
`campaign_report_link_campaign_id`	Unknown	PKFK
`campaign_report_link_id`	Unknown	PKFK
`contact_id`	Unknown	FK
`time`	Unknown
`tstamp`	Unknown

campaign_report_link

Column	Type	Keys
`id`	Unknown	PK
`campaign_id`	Unknown	PKFK
`link`	Unknown
`name`	Unknown
`tracked`	Unknown

address

Column	Type	Keys
`id`	String	PK
`address_1`	String
`address_2`	String
`allgroup`	String
`city`	String
`company_name`	String
`country`	String
`created_by`	String
`created_timestamp`	String
`district`	String
`is_default`	String
`sms_name`	String
`state`	String
`updated_by`	String
`updated_timestamp`	String
`zip`	String

campaign_list

Column	Type	Keys
`id`	Unknown	PK
`campaign_id`	Unknown	PKFK
`list_id`	Unknown	FK
`user_id`	Unknown	FK
`c_date`	Unknown
`campaign`	Unknown
`links_campaign`	Unknown
`links_list`	Unknown
`links_user`	Unknown
`list`	Unknown
`list_amt`	Unknown
`name`	Unknown
`u_date`	Unknown
`users`	Unknown

groups

Column	Type	Keys
`id`	String	PK
`descript`	String
`optin_confirm`	String
`p_admin`	String
`pg_account_add`	String
`pg_account_delete`	String
`pg_account_edit`	String
`pg_account_export`	String
`pg_account_import`	String
`pg_account_manage_custom_field`	String
`pg_account_note_add`	String
`pg_account_note_delete`	String
`pg_account_note_edit`	String
`pg_automation_manage`	String
`pg_contact_actions`	String
`pg_contact_add`	String
`pg_contact_approve`	String
`pg_contact_delete`	String
`pg_contact_edit`	String
`pg_contact_export`	String
`pg_contact_fields`	String
`pg_contact_filters`	String
`pg_contact_import`	String
`pg_contact_merge`	String
`pg_contact_resubscribe`	String
`pg_contact_sync`	String
`pg_deal`	String
`pg_deal_delete`	String
`pg_deal_export`	String
`pg_deal_fields`	String
`pg_deal_group_add`	String
`pg_deal_group_delete`	String
`pg_deal_group_edit`	String
`pg_deal_import`	String
`pg_deal_list_all`	String
`pg_deal_manage_roles`	String
`pg_deal_note_add`	String
`pg_deal_note_delete`	String
`pg_deal_note_edit`	String
`pg_deal_reassign`	String
`pg_form_edit`	String
`pg_group_add`	String
`pg_group_delete`	String
`pg_group_edit`	String
`pg_landing_pages_access`	String
`pg_list_add`	String
`pg_list_bounce`	String
`pg_list_delete`	String
`pg_list_edit`	String
`pg_list_email_account`	String
`pg_list_headers`	String
`pg_message_add`	String
`pg_message_delete`	String
`pg_message_edit`	String
`pg_message_send`	String
`pg_mfa_admin`	String
`pg_personalization_add`	String
`pg_personalization_delete`	String
`pg_personalization_edit`	String
`pg_reports_campaign`	String
`pg_reports_deal`	String
`pg_reports_list`	String
`pg_reports_trend`	String
`pg_reports_user`	String
`pg_saved_responses_manage`	String
`pg_startup_getting_started`	String
`pg_startup_reports`	String
`pg_tag_manage`	String
`pg_template_add`	String
`pg_template_delete`	String
`pg_template_edit`	String
`pg_user_add`	String
`pg_user_delete`	String
`pg_user_edit`	String
`pg_web_personalization_manage`	String
`req_approval`	String
`req_approval_1_st`	String
`req_approval_notify`	String
`s_date`	Unknown
`social_data`	String
`title`	String
`unsubscribe_link`	String

message

Column	Type	Keys
`id`	String	PK
`user_id`	String	FK
`c_date`	Unknown
`charset`	String
`ed_instance_id`	String
`ed_version`	String
`encoding`	String
`format`	String
`from_email`	String
`from_name`	String
`has_predictive_content`	String
`hidden`	String
`html`	String
`html_fetch`	String
`m_date`	Unknown
`name`	String
`preheader_text`	String
`preview_data`	String
`preview_mime`	String
`priority`	String
`reply_2`	String
`subject`	String
`text`	String
`text_fetch`	String

contact_tracking_log

Column	Type	Keys
`id`	Unknown	PK
`contact_id`	Unknown	PKFK
`hash`	Unknown
`tstamp`	Unknown
`type`	Unknown
`value`	Unknown

pipeline_deal_stage

Column	Type	Keys
`deal_stage_id`	String	PK
`deal_group_id`	String	PKFK

pipeline

Column	Type	Keys
`id`	String	PK
`all_groups`	String
`all_users`	String
`auto_assign`	String
`c_date`	Unknown
`currency`	String
`title`	String
`u_date`	Unknown
`win_probability_initialize_date`	String

form_action_data

Column	Type	Keys
`_fivetran_id`	String	PK
`form_id`	String	FK
`email`	String
`list`	String
`type`	String

form_c_field

Column	Type	Keys
`_fivetran_id`	String	PK
`form_id`	String	FK
`class`	String
`default_text`	String
`header`	String
`required`	String
`type`	String

form

Column	Type	Keys
`id`	String	PK
`address_id`	String	FK
`user_id`	String	FK
`ac_branding`	String
`action`	String
`address`	String
`aid`	String
`body`	String
`button`	String
`c_date`	String
`contacts`	String
`deals`	String
`default_screenshot`	String
`entries`	String
`layout`	String
`name`	String
`options_blanks_overwrite`	Boolean
`options_confaction`	String
`options_confform`	String
`options_optin_created`	Boolean
`options_optin_id`	Unknown
`options_sendoptin`	Boolean
`parent_form_id`	String
`recent`	Json
`style_ac_branding`	Boolean
`style_background`	String
`style_border_color`	String
`style_border_radius`	Unknown
`style_border_style`	String
`style_border_width`	Unknown
`style_button_background`	String
`style_button_border_color`	String
`style_button_border_radius`	Unknown
`style_button_border_style`	String
`style_button_border_width`	Unknown
`style_button_fontcolor`	String
`style_button_padding`	Unknown
`style_dark`	Boolean
`style_font_color`	String
`style_layout`	String
`style_width`	Unknown
`submit`	String
`submit_data_url`	String
`thanks`	String
`title`	String
`u_date`	Unknown
`url`	String
`width`	String

stage

Column	Type	Keys
`id`	String	PK
`group`	Unknown	FK
`c_date`	Unknown
`card_region_1`	String
`card_region_2`	String
`card_region_3`	String
`card_region_4`	String
`card_region_5`	String
`color`	String
`deal_order`	String
`groups`	String
`orders`	String
`title`	String
`u_date`	Unknown
`width`	String

task_type

Column	Type	Keys
`id`	String	PK
`c_date`	String
`def_duration`	String
`status`	String
`title`	String
`u_date`	Unknown

account

Column	Type	Keys
`id`	String	PK
`owner`	String	FK
`account_url`	String
`contact_count`	String
`created_timestamp`	String
`deal_count`	String
`name`	String
`updated_timestamp`	String

account_association

Column	Type	Keys
`id`	String	PK
`account`	String	FK
`contact`	String	FK
`created_timestamp`	String
`job_title`	String
`updated_timestamp`	String

ActiveCampaign

Explore the interactive ERD

Table & Field Reference

branding

account_contact

contact

contact_tag

contact_list

contact_custom_field_value

score

automation

segment

deal_custom_field_option

deal_custom_field

connection

deal_activity

user_group

list

users

tags

order_product

task

custom_account_field_value

campaign

e_com_order_product

e_com_order

deal_custom_field_value

group_limit

e_com_customer

schema_field

schema_relationship

schema

note

deal

contact_custom_field

task_outcome

role

email_activity

saved_response

custom_field_option

custom_account_field

campaign_report_open

secondary_contact

calendar

campaign_report_link_info

campaign_report_link

address

campaign_list

groups

message

contact_tracking_log

pipeline_deal_stage

pipeline

form_action_data

form_c_field

form

stage

task_type

account

account_association