Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
id 🔑
created_at
description
name
updated_at
...custom fields
ACCOUNT ⇱
id 🔑
created_by ➤ USER_INFO
updated_by ➤ USER_INFO
account_name�address_1
address_2
address_3
bounceback_date
business_phone
city
country
current_status
created_at
email_address
first_name�fax
is_bounceback
is_subscribed
last_name�mobile_phone
name
postal_code
province
sales_person
subscription_date
title
unsubscription_date
updated_at
...custom fields
CONTACT ⇱
id 🔑
created_at
current_status
name
processing_type
updated_at
...custom fields
FORM ⇱
id 🔑
form_id ➤ FORM
submitted_by_contact_id ➤ CONTACT
submitted_at
...custom fields
FORM_SUBMISSION ⇱
id 🔑
account_id ➤ ACCOUNT
contact_id ➤ CONTACT
created_at
name
updated_at
...custom fields
[CUSTOM OBJECT] ⇱
Each Custom Object is created as a separate table
id 🔑� activity_type 🔑
campaign_id ➤ CAMPAIGN
form_id ➤ FORM
contact_id ➤ CONTACT
visitor_id ➤ VISITOR
activity_date
asset_id
asset_name
asset_type
contact_id_ext
deployment_id
duration
email_address
email_clicked_thru_link
email_recipient_id
email_send_type
email_web_link
external_id
first_page_view_url
ip_address
is_web_tracking_opted_in
number_of_pages
raw_data
referrer_url
smtp_error_code
smtp_message
smtp_status_code
subject_line
url
visitor_external_id
web_visit_id
CONTACT_ACTIVITY ⇱
id 🔑
last_visit_date_and_time 🔑
contact_id ➤ CONTACT
browser_type
city_from_ip
company_dns_name
company_name_from_ip1
country_from_ip
country_name
created_at
current_status
current_total_pages
current_visit_length
external_id
first_page_in_visit
first_visit_date_and_time
host_name
ip_address
isp_from_ip
last_page_in_visit
latitude_from_ip
longitude_from_ip
name
province_from_ip
time_zone
time_zone_offset_min
total_pages
total_time
total_visits
type
zip_code_from_ip
VISITOR ⇱
id 🔑
created_by ➤ USER_INFO
updated_by ➤ USER_INFO
accessed_at
actual_cost
badge_id
budgeted_cost
campaign_category
campaign_type
clr_end_date
crm_id
created_at
current_status
description
end_at
first_activation
folder_id� is_email_marketing_campaign
is_included_in_roi
is_member_allowed_re_entry
is_read_only
is_synced_with_crm
member_count
name
product
region
run_as_user_id
start_at
scheduled_for
source_template_id
updated_at
...custom fields
CAMPAIGN ⇱
id 🔑
created_by ➤ USER_INFO
updated_by ➤ USER_INFO
archived
bounce_back_email
created_at
current_status
html_content_type
html_content_content_source
html_content_html
is_content_protected
is_plain_text_editable
is_private
is_tracked
name
plain_text
render_mode
reply_to_email
reply_to_name
sender_email
sender_name
send_plain_text_only
subject
updated_at
EMAIL ⇱
email_id 🔑 ➤ EMAIL
forml_id 🔑 ➤ FORM
EMAIL_FORM ⇱
id 🔑
email_id 🔑 ➤ EMAIL
href
name
type
EMAIL_HYPERLINK ⇱
id 🔑
segment_id 🔑 ➤ SEGMENT
contact_list_id ➤ CONTACT_LIST
count
is_included
last_calculated_at
type
CONTACT_LIST_SEGMENT_ELEMENT ⇱
id 🔑
created_by ➤ USER_INFO
updated_by ➤ USER_INFO
created_at
current_status
data_lookup_id
folder_id
name
scope
type
updated_at
CONTACT_LIST ⇱
id 🔑
segment_id 🔑 ➤ SEGMENT
contact_filter_id ➤ CONTACT_FILTER
count
is_included
last_calculated_at
type
CONTACT_FILTER_SEGMENT_ELEMENT ⇱
id 🔑
created_by ➤ USER_INFO
updated_by ➤ USER_INFO
count
created_at
current_status
folder_id
is_stale
name
type
updated_at
SEGMENT ⇱
id 🔑
created_by ➤ USER_INFO
updated_by ➤ USER_INFO
created_at
current_status
folder_id
name
scope
statement
type
updated_at
CONTACT_FILTER ⇱
contact_list_id 🔑 ➤ CONTACT_LIST
contact_id 🔑 ➤ CONTACT
CONTACT_LIST_CONTACT ⇱
segment_id 🔑 ➤ SEGMENT
contact_id 🔑 ➤ CONTACT
CONTACT_SEGMENT ⇱
id 🔑
city
company_display_name
company_url
country
created_at
created_by
department
description
digital_signature_id
email_address
first_name
folder_id
is_disabled
job_title
last_name
login_name
name
reply_to_address
sender_display_name
sender_email_address
state
type
updated_at
updated_by
zip_code
USER_INFO ⇱