Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
id 🔑
version 🔑
activities
category_id
channel
created_date
defaults
definition_id
definition_type
description
entry_mode
execution_mode
exits
goals
key
last_published_date
meta_data
modified_date
name
notifiers
scheduled_status
stats
status
tags
triggers
workflow_api_version
JOURNEY ⇱
SUBSCRIBER ⇱
id 🔑
subscriber_key�created_date
email_address�email_type_preference�status
unsubscribed_date
id 🔑
_fivetran_start 🔑
_fivetran_active�_fivetran_end
asset_id
character_set
created_date
modified_date
name
pre_header
subject
text_body
EMAIL ⇱
id 🔑
_fivetran_start 🔑
list_id ➤ LIST
subscriber_key ➤ SUBSCRIBER
_fivetran_active�_fivetran_end
created_date
modified_date
status
LIST_SUBSCRIBER ⇱
id 🔑 �opt_in_subscriber_id ➤ SUBSCRIBER
send_id ➤ SEND
subscriber_key ➤ SUBSCRIBER
triggered_send_id ➤ TRIGGERED_SEND
unsubscribed_list ➤ LIST
batch_id
bounce_category
bounce_type
created_date
event_date
event_type
modified_date
question
smtp_code
smtp_reason
url
EVENT ⇱
id 🔑
email_id ➤ EMAIL
list_id ➤ LIST
auto_add_subscribers
auto_update_subscribers
bcc_email
created_date
modified_date
description
dynamic_email_subject
email_subject
from_address
from_name
is_multipart
is_wrapped
name
priority
send_limit
send_window_close
send_window_open
triggered_send_status
TRIGGERED_SEND ⇱
id 🔑
_fivetran_start 🔑
_fivetran_active�_fivetran_end
created_date
description
name
modified_date
type
LIST ⇱
id 🔑
email_id ➤ EMAIL
bcc_email
created_date
duplicates
email_name
existing_undeliverables
existing_unsubscribes
forwarded_emails
from_address
from_name
hard_bounces
invalid_addresses
is_always_on
is_multipart
missing_addresses
modified_date
number_delivered
number_errored
number_excluded
number_sent
number_targeted
other_bounces
preview_url
send_date
soft_bounces
status
subject
unique_clicks
unique_opens
unsubscribes
SEND ⇱
id 🔑
link_id ➤ LINK
send_id ➤ SEND
alias
total_clicks
unique_clicks
LINK_SEND ⇱
id 🔑
URL
LINK ⇱
Events of multiple types (bounce_event, click_event etc.) are put in this table, so some fields like question, url etc. may be null.
key 🔑
journey_id 🔑 ➤ JOURNEY
journey_version 🔑
triggered_send_id ➤ TRIGGERED_SEND
arguments
configuration_arguments
description
id
meta_data
name
outcomes
schema
triggered_send_key
type
ACTIVITY ⇱
_fivetran_start 🔑
id 🔑
_fivetran_active�_fivetran_end
campaign_code
color
created_date
description
favorite
modified_date
name
CAMPAIGN ⇱
id 🔑
campaign_id ➤ CAMPAIGN�email_asset_id ➤ EMAIL.asset_id�email_id ➤ EMAIL�list_id ➤ LIST�triggered_send_id ➤ TRIGGERED_SEND
created_date
item_id�object_id�type
CAMPAIGN_ASSET ⇱
contact_key 🔑 �device_id 🔑
request_id 🔑
message_id ➤ PUSH_MESSAGE
date_time_send
inbox_message_downloaded
inbox_message_opened
message_opened
open_date
platform
platform_version
push_job_id
service_response
status
system_token
time_in_app
MOBILE_PUSH_DETAIL_EXTRACT ⇱
send_identifier 🔑
status 🔑 �activity_id ➤ ACTIVITY�channel_id ➤ OTT_REGISTRATION
journey_definition_id ➤ JOURNEY�activity_name
asset_id
contact_key
eid
event_date
message_type_id
mid
mobile_number
reason
tracking_type
CHAT_TRACKING ⇱
id 🔑
channel_id ➤ OTT_REGISTRATION
date_created
message_data
mobile_number
CHAT_INBOUND_MESSAGE_LOG ⇱
contact_key 🔑
eid 🔑
mid 🔑�channel_id 🔑 ➤ OTT_REGISTRATION
first_date
last_date
mobile_number
potential_bounce_count
CHAT_POTENTIAL_UNSUBS ⇱
id 🔑�apns_enabled
configuration_custom_keys
configuration_custom_sound
configuration_message_categories
configuration_open_direct
configuration_payload_editor
created_date
description
device_endpoint
gcm_enabled
key
modified_date
name
PUSH_APPLICATION ⇱
id 🔑
application_id
channel_name
created_date
default_response
default_response_last_updated
is_active
is_customer_secret_set
is_test_channel
is_transactional
modified_date
phone_number_id
provider_name
waba_id
OTT_REGISTRATION ⇱
id 🔑
app_name ➤ PUSH_APPLICATION
campaign ➤ CAMPAIGN
android_media_url
format
geofence_name
ios_media_url
media_alt
message_content
message_name
page_name
template
PUSH_MESSAGE ⇱
id🔑
activity_id➤ ACTIVITY
campaign_id➤ CAMPAIGN
journey_definition_id➤ JOURNEY
action_date_time
code_id
conversation_id
conversation_state_id
create_date_time
delivered
description
enterprise_id
from_name
inbound
invalidation_code
is_test
is_valid
keyword_id
message_id
message_text
member_id
mobile
mobile_message_recurrence_id
modified_date_time
name
ordinal
outbound
response_to_mobile_message_tracking_id
send_group_id
send_id
send_job_id
send_person_id
send_segment_id
send_split_id
sent
shared_keyword
short_code
sms_batch_id
sms_job_id
sms_standard_status_code_id
subscriber_id
subscriber_key
undelivered
SMS_MESSAGE_TRACKING ⇱
Data Extensions
You can find tables in your destination with the following prefixes based on the type of table that is being synced: