Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
id 🔑
integration_id ➤ INTEGRATION
updated
name
created
METRIC ⇱
id 🔑
name
status
created
updated
customer_filter
trigger
FLOW ⇱
id 🔑
name�category
INTEGRATION ⇱
id 🔑
last_name
first_name
title
organization
latitude
longitude
address1
address2
city
region
country
zip
timezone
phone_number
created
updated
custom_* (!)
custom_fields (†)
PERSON ⇱
id 🔑
email_template_id ➤ EMAIL_TEMPLATE
status
updated
from_name
status_id
is_segmented
send_time
name
campaign_type
sent_at
created
status_label
from_email
subject
CAMPAIGN ⇱
id 🔑
is_writeable
updated
name
created
html
EMAIL_TEMPLATE ⇱
campaign_id 🔑 ➤ CAMPAIGN
list_id 🔑 ➤ LIST
CAMPAIGN_LIST ⇱
id
list_id 🔑 ➤ LIST
reason
created
LIST_EXCLUSION ⇱
id 🔑
updated
created
list_name
folder_name
LIST ⇱
id 🔑
metric_id ➤ METRIC
person_id ➤ PERSON
campaign_id ➤ CAMPAIGN
flow_id ➤ FLOW
datetime�flow_message_id
timestamp�type
uuid
property_* (!)�custom_property_fields (†)
EVENT ⇱
list_id 🔑 ➤ LIST
person_id 🔑 ➤ PERSON�joined_group_at
LIST_PERSON ⇱
! - If the packing mode is UNPACKED.
† - If the packing mode is PACKED.
For more information, please click here.