# Constant Contact schema ERD

Table and field reference for the Fivetran Constant Contact connector.

## Table & Field Reference

### custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| label | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### email_campaign_summary_report

| Column | Type | Keys |
| --- | --- | --- |
| campaign_type | Unknown | PK |
| last_sent_date | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| unique_counts_abuse | Unknown |  |
| unique_counts_bounces | Unknown |  |
| unique_counts_clicks | Unknown |  |
| unique_counts_forwards | Unknown |  |
| unique_counts_not_opened | Unknown |  |
| unique_counts_opens | Unknown |  |
| unique_counts_optouts | Unknown |  |
| unique_counts_sends | Unknown |  |

### segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| criteria | Unknown |  |
| edited_at | Unknown |  |
| name | Unknown |  |

### contact_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contacts_count | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| tag_source | Unknown |  |
| updated_at | Unknown |  |

### contact_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| favorite | Unknown |  |
| membership_count | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### contact_custom

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Unknown | PK, FK |
| custom_field_id | Unknown | PK, FK |
| value | Unknown |  |

### contact_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | PK, FK |
| create_source | Unknown |  |
| created_at | Unknown |  |
| kind | Unknown |  |
| phone_number | Unknown |  |
| update_source | Unknown |  |
| updated_at | Unknown |  |

### contact_street_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| kind | Unknown |  |
| postal_code | Unknown |  |
| state | Unknown |  |
| street | Unknown |  |
| updated_at | Unknown |  |

### contact_membership

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Unknown | PK, FK |
| list_id | Unknown | PK, FK |

### contact_tagging

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Unknown | PK, FK |
| tag_id | Unknown | PK, FK |

### contact_note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | PK, FK |
| content | Unknown |  |
| created_at | Unknown |  |

### contact_sms_channel_consent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_id | Unknown | PK, FK |
| advertised_frequency | Unknown |  |
| advertised_interval | Unknown |  |
| consent_type | Unknown |  |
| created_at | Unknown |  |
| opt_in_date | Unknown |  |
| opt_out_date | Unknown |  |
| sms_consent_permission | Unknown |  |
| updated_at | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| anniversary | Unknown |  |
| birthday_day | Unknown |  |
| birthday_month | Unknown |  |
| company_name | Unknown |  |
| create_source | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| email_address | Unknown |  |
| email_confirm_status | Unknown |  |
| email_created_at | Unknown |  |
| email_opt_in_date | Unknown |  |
| email_opt_in_source | Unknown |  |
| email_opt_out_date | Unknown |  |
| email_opt_out_reason | Unknown |  |
| email_opt_out_source | Unknown |  |
| email_permission_to_send | Unknown |  |
| email_updated_at | Unknown |  |
| first_name | Unknown |  |
| job_title | Unknown |  |
| last_name | Unknown |  |
| sms_channel_address | Unknown |  |
| sms_channel_country_code | Unknown |  |
| sms_channel_create_source | Unknown |  |
| sms_channel_dial_code | Unknown |  |
| sms_channel_id | Unknown |  |
| sms_channel_update_source | Unknown |  |
| update_source | Unknown |  |
| updated_at | Unknown |  |

### contact_sms_engagement_history

| Column | Type | Keys |
| --- | --- | --- |
| insert_time | Unknown | PK |
| sms_channel_history_id | Unknown | PK |
| sms_channel_id | Unknown | PK |
| contact_id | Unknown | PK, FK |
| history_details_advertised_frequency | Unknown |  |
| history_details_advertised_interval | Unknown |  |
| history_details_consent_action_time | Unknown |  |
| history_details_consent_action_type | Unknown |  |
| history_details_consent_medium_type | Unknown |  |
| history_details_consent_type | Unknown |  |
| history_details_source | Unknown |  |
| history_details_source_consent_timestamp | Unknown |  |
| history_details_source_ip | Unknown |  |
| history_details_source_sms_number | Unknown |  |
| history_details_state | Unknown |  |

### email_campaign_stat_report

| Column | Type | Keys |
| --- | --- | --- |
| last_refresh_time | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| percents_bounce | Unknown |  |
| percents_click | Unknown |  |
| percents_desktop_click | Unknown |  |
| percents_desktop_open | Unknown |  |
| percents_did_not_open | Unknown |  |
| percents_mobile_click | Unknown |  |
| percents_mobile_open | Unknown |  |
| percents_open | Unknown |  |
| percents_unsubscribe | Unknown |  |
| stats_em_bounces | Unknown |  |
| stats_em_clicks | Unknown |  |
| stats_em_clicks_all | Unknown |  |
| stats_em_clicks_all_computer | Unknown |  |
| stats_em_clicks_all_mobile | Unknown |  |
| stats_em_clicks_all_none | Unknown |  |
| stats_em_clicks_all_other | Unknown |  |
| stats_em_clicks_all_tablet | Unknown |  |
| stats_em_forwards | Unknown |  |
| stats_em_not_opened | Unknown |  |
| stats_em_opens | Unknown |  |
| stats_em_opens_all | Unknown |  |
| stats_em_opens_all_computer | Unknown |  |
| stats_em_opens_all_mobile | Unknown |  |
| stats_em_opens_all_none | Unknown |  |
| stats_em_opens_all_other | Unknown |  |
| stats_em_opens_all_tablet | Unknown |  |
| stats_em_optouts | Unknown |  |
| stats_em_sends | Unknown |  |

### email_campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| current_status | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| type_code | Unknown |  |
| updated_at | Unknown |  |

### email_bounce_report

| Column | Type | Keys |
| --- | --- | --- |
| campaign_activity_id | Unknown | PK, FK |
| contact_id | Unknown | PK, FK |
| bounce_code | Unknown |  |
| created_time | Unknown |  |
| current_email_address | Unknown |  |
| deleted_at | Unknown |  |
| tracking_activity_type | Unknown |  |

### campaign_activity_segment

| Column | Type | Keys |
| --- | --- | --- |
| campaign_activity_id | Unknown | PK, FK |
| segment_id | Unknown | PK, FK |

### campaign_activity_contact_list

| Column | Type | Keys |
| --- | --- | --- |
| campaign_activity_id | Unknown | PK, FK |
| contact_list_id | Unknown | PK, FK |

### campaign_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| address_line_3 | Unknown |  |
| address_optional | Unknown |  |
| city | Unknown |  |
| country_code | Unknown |  |
| country_name | Unknown |  |
| current_status | Unknown |  |
| format_type | Unknown |  |
| forward_email_link_enabled | Unknown |  |
| forward_email_link_name | Unknown |  |
| from_email | Unknown |  |
| from_name | Unknown |  |
| greeting_name_type | Unknown |  |
| greeting_salutation | Unknown |  |
| greeting_secondary | Unknown |  |
| html_content | Unknown |  |
| letter_format | Unknown |  |
| organization_name | Unknown |  |
| permalink_url | Unknown |  |
| permission_reminder | Unknown |  |
| permission_reminder_enabled | Unknown |  |
| postal_code | Unknown |  |
| preheader | Unknown |  |
| reply_to_email | Unknown |  |
| role | Unknown |  |
| state_code | Unknown |  |
| state_name | Unknown |  |
| state_non_us_name | Unknown |  |
| style_content | Unknown |  |
| subject | Unknown |  |
| subscribe_link_enabled | Unknown |  |
| subscribe_link_name | Unknown |  |
| template_id | Unknown |  |
| text_content | Unknown |  |
| view_as_webpage_enabled | Unknown |  |
| view_as_webpage_link_name | Unknown |  |
| view_as_webpage_text | Unknown |  |

### email_forward_report

| Column | Type | Keys |
| --- | --- | --- |
| campaign_activity_id | Unknown | PK, FK |
| contact_id | Unknown | PK, FK |
| created_time | Unknown |  |
| deleted_at | Unknown |  |
| device_type | Unknown |  |
| tracking_activity_type | Unknown |  |

### email_opt_out_report

| Column | Type | Keys |
| --- | --- | --- |
| campaign_activity_id | Unknown | PK, FK |
| contact_id | Unknown | PK, FK |
| created_time | Unknown |  |
| deleted_at | Unknown |  |
| device_type | Unknown |  |
| opt_out_reason | Unknown |  |
| tracking_activity_type | Unknown |  |

### email_campaign_activity_stat_report

| Column | Type | Keys |
| --- | --- | --- |
| last_refresh_time | Unknown | PK |
| campaign_activity_id | Unknown | PK, FK |
| campaign_id | Unknown | PK, FK |
| stats_em_abuse | Unknown |  |
| stats_em_bounces | Unknown |  |
| stats_em_bounces_blocked | Unknown |  |
| stats_em_bounces_mailbox_full | Unknown |  |
| stats_em_bounces_nonexistent_address | Unknown |  |
| stats_em_bounces_other | Unknown |  |
| stats_em_bounces_suspended | Unknown |  |
| stats_em_bounces_undeliverable | Unknown |  |
| stats_em_bounces_vacation | Unknown |  |
| stats_em_clicks | Unknown |  |
| stats_em_clicks_all | Unknown |  |
| stats_em_clicks_all_computer | Unknown |  |
| stats_em_clicks_all_mobile | Unknown |  |
| stats_em_clicks_all_none | Unknown |  |
| stats_em_clicks_all_other | Unknown |  |
| stats_em_clicks_all_tablet | Unknown |  |
| stats_em_forwards | Unknown |  |
| stats_em_not_opened | Unknown |  |
| stats_em_opens | Unknown |  |
| stats_em_opens_all | Unknown |  |
| stats_em_opens_all_computer | Unknown |  |
| stats_em_opens_all_mobile | Unknown |  |
| stats_em_opens_all_none | Unknown |  |
| stats_em_opens_all_other | Unknown |  |
| stats_em_opens_all_tablet | Unknown |  |
| stats_em_optouts | Unknown |  |
| stats_em_sends | Unknown |  |

### unique_contact_add_landing_page_report

| Column | Type | Keys |
| --- | --- | --- |
| campaign_activity_id | Unknown | PK, FK |
| contact_id | Unknown | PK, FK |
| created_time | Unknown |  |
| deleted_at | Unknown |  |
| sms_channel_country_code | Unknown |  |
| sms_channel_formatted_international | Unknown |  |
| sms_channel_formatted_national | Unknown |  |
| sms_channel_state | Unknown |  |
| tracking_activity_type | Unknown |  |

### email_click_report

| Column | Type | Keys |
| --- | --- | --- |
| campaign_activity_id | Unknown | PK, FK |
| contact_id | Unknown | PK, FK |
| created_time | Unknown |  |
| deleted_at | Unknown |  |
| device_type | Unknown |  |
| link_url | Unknown |  |
| tracking_activity_type | Unknown |  |
| url_id | Unknown |  |

### email_send_report

| Column | Type | Keys |
| --- | --- | --- |
| campaign_activity_id | Unknown | PK, FK |
| contact_id | Unknown | PK, FK |
| created_time | Unknown |  |
| deleted_at | Unknown |  |
| tracking_activity_type | Unknown |  |

### email_open_report

| Column | Type | Keys |
| --- | --- | --- |
| campaign_activity_id | Unknown | PK, FK |
| contact_id | Unknown | PK, FK |
| created_time | Unknown |  |
| deleted_at | Unknown |  |
| device_type | Unknown |  |
| tracking_activity_type | Unknown |  |

### email_unique_open_report

| Column | Type | Keys |
| --- | --- | --- |
| campaign_activity_id | Unknown | PK, FK |
| contact_id | Unknown | PK, FK |
| created_time | Unknown |  |
| deleted_at | Unknown |  |
| device_type | Unknown |  |
| tracking_activity_type | Unknown |  |

### send_history_contact_list

| Column | Type | Keys |
| --- | --- | --- |
| contact_list_id | Unknown | PK, FK |
| send_id | Unknown | PK, FK |

### send_history_segment

| Column | Type | Keys |
| --- | --- | --- |
| segment_id | Unknown | PK, FK |
| send_id | Unknown | PK, FK |

### send_history

| Column | Type | Keys |
| --- | --- | --- |
| send_id | Unknown | PK |
| campaign_activity_id | Unknown | PK, FK |
| count | Unknown |  |
| reason_code | Unknown |  |
| run_date | Unknown |  |
| send_status | Unknown |  |

### unique_contact_click_landing_page_report

| Column | Type | Keys |
| --- | --- | --- |
| url_id | Unknown | PK |
| campaign_activity_id | Unknown | PK, FK |
| contact_id | Unknown | PK, FK |
| created_time | Unknown |  |
| deleted_at | Unknown |  |
| device_type | Unknown |  |
| link_url | Unknown |  |
| sms_channel_country_code | Unknown |  |
| sms_channel_formatted_international | Unknown |  |
| sms_channel_formatted_national | Unknown |  |
| sms_channel_state | Unknown |  |
| tracking_activity_type | Unknown |  |

### unique_contact_sms_opt_in_landing_page_report

| Column | Type | Keys |
| --- | --- | --- |
| campaign_activity_id | Unknown | PK, FK |
| contact_id | Unknown | PK, FK |
| created_time | Unknown |  |
| deleted_at | Unknown |  |
| sms_channel_country_code | Unknown |  |
| sms_channel_formatted_international | Unknown |  |
| sms_channel_formatted_national | Unknown |  |
| sms_channel_state | Unknown |  |
| tracking_activity_type | Unknown |  |

### html_preview_email_campaign_activity

| Column | Type | Keys |
| --- | --- | --- |
| campaign_activity_id | Unknown | PK, FK |
| from_email | Unknown |  |
| from_name | Unknown |  |
| preheader | Unknown |  |
| preview_html_content | Unknown |  |
| preview_text_content | Unknown |  |
| reply_to_email | Unknown |  |
| subject | Unknown |  |

### unique_contact_open_landing_page_report

| Column | Type | Keys |
| --- | --- | --- |
| campaign_activity_id | Unknown | PK, FK |
| contact_id | Unknown | PK, FK |
| created_time | Unknown |  |
| deleted_at | Unknown |  |
| device_type | Unknown |  |
| sms_channel_country_code | Unknown |  |
| sms_channel_formatted_international | Unknown |  |
| sms_channel_formatted_national | Unknown |  |
| sms_channel_state | Unknown |  |
| tracking_activity_type | Unknown |  |

### contact_open_landing_page_report

| Column | Type | Keys |
| --- | --- | --- |
| created_time | Unknown | PK |
| campaign_activity_id | Unknown | PK, FK |
| contact_id | Unknown | PK, FK |
| deleted_at | Unknown |  |
| device_type | Unknown |  |
| sms_channel_country_code | Unknown |  |
| sms_channel_formatted_international | Unknown |  |
| sms_channel_formatted_national | Unknown |  |
| sms_channel_state | Unknown |  |
| tracking_activity_type | Unknown |  |

### unique_contact_update_landing_page_report

| Column | Type | Keys |
| --- | --- | --- |
| campaign_activity_id | Unknown | PK, FK |
| contact_id | Unknown | PK, FK |
| created_time | Unknown |  |
| deleted_at | Unknown |  |
| sms_channel_country_code | Unknown |  |
| sms_channel_formatted_international | Unknown |  |
| sms_channel_formatted_national | Unknown |  |
| sms_channel_state | Unknown |  |
| tracking_activity_type | Unknown |  |

### email_link_report

| Column | Type | Keys |
| --- | --- | --- |
| url_id | Unknown | PK |
| campaign_activity_id | Unknown | PK, FK |
| list_id | Unknown | FK |
| link_tag | Unknown |  |
| link_url | Unknown |  |
| list_action | Unknown |  |
| unique_clicks | Unknown |  |

### non_opener_resend_campaign_activity

| Column | Type | Keys |
| --- | --- | --- |
| resend_date | Unknown | PK |
| resend_request_id | Unknown | PK |
| campaign_activity_id | Unknown | PK, FK |
| delay_days | Unknown |  |
| delay_minutes | Unknown |  |
| resend_status | Unknown |  |
| resend_subject | Unknown |  |

### email_did_not_open_report

| Column | Type | Keys |
| --- | --- | --- |
| campaign_activity_id | Unknown | PK, FK |
| contact_id | Unknown | PK, FK |
| created_time | Unknown |  |
| deleted_at | Unknown |  |
| tracking_activity_type | Unknown |  |

## Relationships

- email_campaign_summary_report(campaign_id) → email_campaign(id)
- contact_custom(custom_field_id) → custom_field(id)
- contact_custom(contact_id) → contact(id)
- contact_phone_number(contact_id) → contact(id)
- contact_street_address(contact_id) → contact(id)
- contact_membership(list_id) → contact_list(id)
- contact_membership(contact_id) → contact(id)
- contact_tagging(tag_id) → contact_tag(id)
- contact_tagging(contact_id) → contact(id)
- contact_note(contact_id) → contact(id)
- contact_sms_channel_consent(contact_id) → contact(id)
- contact_sms_engagement_history(contact_id) → contact(id)
- email_campaign_stat_report(campaign_id) → email_campaign(id)
- email_bounce_report(contact_id) → contact(id)
- email_bounce_report(campaign_activity_id) → campaign_activity(id)
- campaign_activity_segment(segment_id) → segment(id)
- campaign_activity_segment(campaign_activity_id) → campaign_activity(id)
- campaign_activity_contact_list(contact_list_id) → contact_list(id)
- campaign_activity_contact_list(campaign_activity_id) → campaign_activity(id)
- campaign_activity(campaign_id) → email_campaign(id)
- email_forward_report(contact_id) → contact(id)
- email_forward_report(campaign_activity_id) → campaign_activity(id)
- email_opt_out_report(contact_id) → contact(id)
- email_opt_out_report(campaign_activity_id) → campaign_activity(id)
- email_campaign_activity_stat_report(campaign_id) → email_campaign(id)
- email_campaign_activity_stat_report(campaign_activity_id) → campaign_activity(id)
- unique_contact_add_landing_page_report(contact_id) → contact(id)
- unique_contact_add_landing_page_report(campaign_activity_id) → campaign_activity(id)
- email_click_report(contact_id) → contact(id)
- email_click_report(campaign_activity_id) → campaign_activity(id)
- email_send_report(contact_id) → contact(id)
- email_send_report(campaign_activity_id) → campaign_activity(id)
- email_open_report(contact_id) → contact(id)
- email_open_report(campaign_activity_id) → campaign_activity(id)
- email_unique_open_report(contact_id) → contact(id)
- email_unique_open_report(campaign_activity_id) → campaign_activity(id)
- send_history_contact_list(contact_list_id) → contact_list(id)
- send_history_contact_list(send_id) → send_history(send_id)
- send_history_segment(segment_id) → segment(id)
- send_history_segment(send_id) → send_history(send_id)
- send_history(campaign_activity_id) → campaign_activity(id)
- unique_contact_click_landing_page_report(contact_id) → contact(id)
- unique_contact_click_landing_page_report(campaign_activity_id) → campaign_activity(id)
- unique_contact_sms_opt_in_landing_page_report(contact_id) → contact(id)
- unique_contact_sms_opt_in_landing_page_report(campaign_activity_id) → campaign_activity(id)
- html_preview_email_campaign_activity(campaign_activity_id) → campaign_activity(id)
- unique_contact_open_landing_page_report(contact_id) → contact(id)
- unique_contact_open_landing_page_report(campaign_activity_id) → campaign_activity(id)
- contact_open_landing_page_report(contact_id) → contact(id)
- contact_open_landing_page_report(campaign_activity_id) → campaign_activity(id)
- unique_contact_update_landing_page_report(contact_id) → contact(id)
- unique_contact_update_landing_page_report(campaign_activity_id) → campaign_activity(id)
- email_link_report(list_id) → contact_list(id)
- email_link_report(campaign_activity_id) → campaign_activity(id)
- non_opener_resend_campaign_activity(campaign_activity_id) → campaign_activity(id)
- email_did_not_open_report(contact_id) → contact(id)
- email_did_not_open_report(campaign_activity_id) → campaign_activity(id)