Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
list_id 🔑 ➤ LIST
recipient_id 🔑 ➤ RECIPIENT
RECIPIENT_LIST
id 🔑
created_at
updated_at
last_emailed
last_clicked
last_opened
first_name
last_name�custom_*
RECIPIENT ⇱
id 🔑
nickname
from_email
from_name
address
address_2
city
reply_to_email
reply_to_name
state
zip
country
verified_status
verified_reason
updated_at
created_at
locked
SENDER ⇱
id 🔑
name
description
last_email_sent_at
is_default
unsubscribes
UNSUBSCRIBE_GROUP ⇱
id 🔑
sender_id ➤ SENDER
unsubscribe_group_id ➤ UNSUBSCRIBE_GROUP
title
subject
custom_unsubscribe_url
ip_pool
status
html_content
plain_content
editor
CAMPAIGN ⇱
segment_id 🔑 ➤ SEGMENT
campaign_id 🔑 ➤ CAMPAIGN
CAMPAIGN_SEGMENT
field 🔑
segment_id 🔑 ➤ SEGMENT
value
operator
SEGMENT_CONDITION
id 🔑
list_id ➤ LIST
name
SEGMENT ⇱
id 🔑
name
LIST ⇱
campaign_id 🔑 ➤ CAMPAIGN
list_id 🔑 ➤ LIST
CAMPAIGN_LIST
_fivetran_id 🔑
campaign_id ➤ CAMPAIGN
email ➤ RECIPIENT.email
attempt
sg_event_id
timestamp
smtp_id
sg_message_id
ip
url
useragent
sg_user_id
event
cert_err
status
reason
type
response
tls
pool_name
pool_id
url_offset_index
url_offset_type
post_type
campaign_version
campaign_split_id
custom_*
EVENT ⇱
The email in the EVENT is the email of the RECIPIENT.
event_id 🔑 ➤ EVENT
index 🔑
campaign_id ➤ CAMPAIGN
category
CATEGORY