Constant Contact

Explore the interactive ERD

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	PKFK
`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	PKFK
`custom_field_id`	Unknown	PKFK
`value`	Unknown

contact_phone_number

Column	Type	Keys
`id`	Unknown	PK
`contact_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`list_id`	Unknown	PKFK

contact_tagging

Column	Type	Keys
`contact_id`	Unknown	PKFK
`tag_id`	Unknown	PKFK

contact_note

Column	Type	Keys
`id`	Unknown	PK
`contact_id`	Unknown	PKFK
`content`	Unknown
`created_at`	Unknown

contact_sms_channel_consent

Column	Type	Keys
`index`	Unknown	PK
`contact_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`contact_id`	Unknown	PKFK
`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	PKFK
`segment_id`	Unknown	PKFK

campaign_activity_contact_list

Column	Type	Keys
`campaign_activity_id`	Unknown	PKFK
`contact_list_id`	Unknown	PKFK

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	PKFK
`contact_id`	Unknown	PKFK
`created_time`	Unknown
`deleted_at`	Unknown
`device_type`	Unknown
`tracking_activity_type`	Unknown

email_opt_out_report

Column	Type	Keys
`campaign_activity_id`	Unknown	PKFK
`contact_id`	Unknown	PKFK
`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	PKFK
`campaign_id`	Unknown	PKFK
`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	PKFK
`contact_id`	Unknown	PKFK
`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	PKFK
`contact_id`	Unknown	PKFK
`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	PKFK
`contact_id`	Unknown	PKFK
`created_time`	Unknown
`deleted_at`	Unknown
`tracking_activity_type`	Unknown

email_open_report

Column	Type	Keys
`campaign_activity_id`	Unknown	PKFK
`contact_id`	Unknown	PKFK
`created_time`	Unknown
`deleted_at`	Unknown
`device_type`	Unknown
`tracking_activity_type`	Unknown

email_unique_open_report

Column	Type	Keys
`campaign_activity_id`	Unknown	PKFK
`contact_id`	Unknown	PKFK
`created_time`	Unknown
`deleted_at`	Unknown
`device_type`	Unknown
`tracking_activity_type`	Unknown

send_history_contact_list

Column	Type	Keys
`contact_list_id`	Unknown	PKFK
`send_id`	Unknown	PKFK

send_history_segment

Column	Type	Keys
`segment_id`	Unknown	PKFK
`send_id`	Unknown	PKFK

send_history

Column	Type	Keys
`send_id`	Unknown	PK
`campaign_activity_id`	Unknown	PKFK
`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	PKFK
`contact_id`	Unknown	PKFK
`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	PKFK
`contact_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`contact_id`	Unknown	PKFK
`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	PKFK
`contact_id`	Unknown	PKFK
`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	PKFK
`contact_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`delay_days`	Unknown
`delay_minutes`	Unknown
`resend_status`	Unknown
`resend_subject`	Unknown

email_did_not_open_report

Column	Type	Keys
`campaign_activity_id`	Unknown	PKFK
`contact_id`	Unknown	PKFK
`created_time`	Unknown
`deleted_at`	Unknown
`tracking_activity_type`	Unknown