# ActiveCampaign schema ERD

Table and field reference for the Fivetran ActiveCampaign connector.

## 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 | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |

### 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 |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| c_date | Unknown |  |
| created_by | String |  |
| created_timestamp | String |  |
| description | String |  |
| subscriber_count | String |  |
| tag_type | String |  |
| tags | String |  |
| updated_by | String |  |
| updated_timestamp | 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 | PK, FK |
| labels_plural | String |  |
| labels_singular | String |  |
| required | Boolean |  |
| scale | Unknown |  |
| type | String |  |

### schema_relationship

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| schema_id | String | PK, FK |
| 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 | PK, FK |

### 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 | PK, FK |
| contact_id | Unknown | PK, FK |
| 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 | PK, FK |
| campaign_report_link_id | Unknown | PK, FK |
| contact_id | Unknown | FK |
| time | Unknown |  |
| tstamp | Unknown |  |

### campaign_report_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| hash | Unknown |  |
| tstamp | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### pipeline_deal_stage

| Column | Type | Keys |
| --- | --- | --- |
| deal_stage_id | String | PK |
| deal_group_id | String | PK, FK |

### 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 |  |

## Relationships

- branding(group_id) → groups(id)
- account_contact(contact_id) → contact(id)
- contact_tag(contact) → contact(id)
- contact_list(list) → list(id)
- contact_list(contact_id) → contact(id)
- contact_custom_field_value(contact) → contact(id)
- contact_custom_field_value(custom_field_id) → contact_custom_field(id)
- automation(user_id) → users(id)
- deal_custom_field_option(deal_custom_field_id) → deal_custom_field(id)
- deal_activity(deal_stage_id) → stage(id)
- deal_activity(user_id) → users(id)
- deal_activity(deal_id) → deal(id)
- user_group(group_id) → groups(id)
- user_group(user_id) → users(id)
- list(user_id) → users(id)
- order_product(e_com_order) → e_com_order(id)
- order_product(connection_id) → connection(id)
- task(user_id) → users(id)
- task(owner_id) → contact(id)
- custom_account_field_value(account_id) → account(id)
- custom_account_field_value(custom_field_id) → custom_account_field(id)
- campaign(user_id) → users(id)
- campaign(address_id) → address(id)
- e_com_order_product(e_com_order_id) → e_com_order(id)
- e_com_order(connection) → connection(id)
- e_com_order(customer_id) → e_com_customer(id)
- deal_custom_field_value(custom_field_id) → deal_custom_field(id)
- deal_custom_field_value(deal_id) → deal(id)
- group_limit(group_id) → groups(id)
- e_com_customer(connection_id) → connection(id)
- schema_field(schema_id) → schema(id)
- schema_relationship(schema_id) → schema(id)
- note(user_id) → users(id)
- note(owner_id) → contact(id)
- deal(owner) → users(id)
- deal(next_deal_id) → deal(id)
- deal(next_task_id) → task(id)
- deal(account) → account(id)
- deal(contact) → contact(id)
- email_activity(user_id) → users(id)
- email_activity(deal_id) → deal(id)
- email_activity(connection_id) → connection(id)
- email_activity(rel_id) → contact_tracking_log(id)
- email_activity(contact_id) → contact(id)
- email_activity(message_id) → message(id)
- saved_response(last_sent_user_id) → users(id)
- custom_field_option(custom_account_field_id) → custom_account_field(id)
- campaign_report_open(contact_id) → contact(id)
- campaign_report_open(campaign_id) → campaign(id)
- secondary_contact(contact) → contact(id)
- secondary_contact(deal) → deal(id)
- calendar(user_id) → users(id)
- campaign_report_link_info(contact_id) → contact(id)
- campaign_report_link_info(campaign_report_link_id) → campaign_report_link(id)
- campaign_report_link_info(campaign_report_link_campaign_id) → campaign_report_link(campaign_id)
- campaign_report_link(campaign_id) → campaign(id)
- campaign_list(user_id) → users(id)
- campaign_list(list_id) → list(id)
- campaign_list(campaign_id) → campaign(id)
- message(user_id) → users(id)
- contact_tracking_log(contact_id) → contact(id)
- pipeline_deal_stage(deal_group_id) → pipeline(id)
- form_action_data(form_id) → form(id)
- form_c_field(form_id) → form(id)
- form(user_id) → users(id)
- form(address_id) → address(id)
- stage(group) → pipeline(id)
- account(owner) → users(id)
- account_association(account) → account(id)
- account_association(contact) → contact(id)