index 🔑
company_id 🔑 ➤ COMPANY
type
verified
COMPANY_EMAIL ⇱
index 🔑
company_id 🔑 ➤ COMPANY
phone
type
verified
COMPANY_PHONE ⇱
index 🔑
company_id 🔑 ➤ COMPANY
type
url
user_id
user_name
verified
COMPANY_SOCIAL ⇱
index 🔑
company_id 🔑 ➤ COMPANY
type
url
COMPANY_URL ⇱
index 🔑
company_id 🔑 ➤ COMPANY
address
address2
address3
area_code
city_name
country_code
country_name
latitude
longitude
name
region_code
region_name
type
zip_code
COMPANY_LOCATION ⇱
id 🔑�sla_id 🔑➤ SLA
created_by ➤ USER
created_at�name�version�description�hours
SLA_VERSION ⇱
id 🔑
created_by ➤ USER
created_at�current_version
SLA ⇱
_fivetran_id 🔑
sla_version_id ➤ SLA_VERSION
created_at�name�priority�commitment�enabled
SLA_METRIC ⇱
_fivetran_id 🔑
sla_version_id ➤ SLA_VERSION
matchType�fieldType�field�operator�value
SLA_CRITERIA ⇱
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
id 🔑
created_by ➤ USER
modified_by ➤ USER
display_color
dispaly_name
external_id
gender
local
name
progressive_status
verified
modified_at
deleted_at
last_activity_at
default_lang
deleted
first_name
last_name
last_message_at
progressive_status
verified
conversation_count_*
last_conversation_*
last_message_out_*
sentiment_*
CUSTOMER ⇱
id 🔑
deleted
deleted_at
display_name
email_signature
mobile
name
USER ⇱
id 🔑
created_by ➤ USER
deleted_by ➤ USER
modified_by ➤ USER
deleted
display_name
name
TEAM ⇱
team_id 🔑 ➤ TEAM
user_id 🔑 ➤ USER
TEAM_MEMBER ⇱
id 🔑
created_by ➤ USER
deleted_by ➤ USER
modified_by ➤ USER
color
name
TAG ⇱
id 🔑
created_by ➤ USER
modified_by ➤ USER
cconversation_deleted
conversation_direction
conversation_first_response
conversation_last_message_in
conversation_message_count
conversation_name
conversation_note_count
conversation_outbound_message_count
conversation_satisfaction
conversation_sentiment_confidence
conversation_sentiment_polarity
conversation_status
conversation_rev
draft
name
payload
SHORTCUT ⇱
id 🔑
deleted_by ➤ USER
conversation_id ➤ CONVERSATION
created_by ➤ USER
customer_id ➤ CUSTOMER
modified_by ➤ USER
body
deleted
external_id
NOTE ⇱
note_id 🔑 ➤ NOTE
user_id 🔑 ➤ USER
NOTE_USER_MENTION ⇱
id 🔑
conversation_id ➤ CONVERSATION
created_by ➤ USER
customer_id ➤ CUSTOMER
modified_by ➤ USER
app
source
channel
direction
preview
sent_at
size
status
subject
first_delivered_*
MESSAGE ⇱
id 🔑
assistant_id ➤ ASSISTANT.public_id
brand_id ➤BRAND
deleted_by ➤ USER
created_by ➤ USER
customer_id ➤ CUSTOMER
modified_by ➤ USER
queue_id ➤ QUEUE
sla_version_id ➤ SLA_VERSION
assistant_status�assistant_emulation�assistant_transferred_at
assistant_type
deleted
direction
ended_at
ended_by
ended_reason
external_id
message_count
name
note_count
outbound_message_count
reopen_count
replay_channel
rev
satisfaction
sentiment_polarity
sentiment_confidence
snooze_count
status
first_message_in_channel
first_message_in_createdAt
first_message_in_id
first_message_in_meta_recipient_email
first_message_in_meta_recipient_mailboxhash
first_message_in_meta_to
first_message_in_sentAt
first_response_created_at
first_response_created_by
first_response_id
first_response_response_time
first_response_sent_at
first_response_time
sentiment_
spam�sla_version�sla_version_id
first_company_*
satisfaction_level_*
last_message_in_*
last_message_out_*
sla_*
CONVERSATION_HISTORY ⇱
conversation_id 🔑 ➤ CONVERSATION_HISTORY
user_id 🔑 ➤ USER
CONVERSATION_ASSIGNED_USER_HISTORY ⇱
conversation_id 🔑 ➤ CONVERSATION_HISTORY
team_id 🔑 ➤ TEAM
CONVERSATION_ASSIGNED_TEAM_HISTORY ⇱
id 🔑
description
name
url
CARD ⇱
id 🔑
card_id 🔑 ➤ CARD
name
CARD_CONTEXT ⇱
conversation_id 🔑 ➤ CONVERSATION_HISTORY
name 🔑
CONVERSATION_CHANNEL_HISTORY ⇱
index 🔑
user_id 🔑 ➤ USER
name
USER_ROLE ⇱
id 🔑
created_by ➤ USER
modified_by ➤ USER
enabled
name
type
value
value_day
value_day_type
value_time
SNOOZE ⇱
id 🔑
user ➤ USER
event
name
status
NOTIFICATION ⇱
id 🔑
created_by ➤ USER
modified_by ➤ USER
external_id
name
COMPANY ⇱
id 🔑
customer_id ➤ CUSTOMER
title
custom_*
KOBJECT ⇱
id 🔑
shortcut_id 🔑 ➤ SHORTCUT
name
SHORTCUT_CHANNEL ⇱
shortcut_id 🔑 ➤ SHORTCUT
user_id 🔑 ➤ USER
SHORTCUT_ASSIGNED_USERS ⇱
shortcut_id 🔑 ➤ SHORTCUT
team_id 🔑 ➤ TEAM
SHORTCUT_ASSIGNED_TEAMS ⇱
customer_id 🔑 ➤ CUSTOMER
user_id 🔑 ➤ USER
CUSTOMER_ACTIVE_USER ⇱
customer_id 🔑 ➤ CUSTOMER
user_id 🔑 ➤ USER
CUSTOMER_WATCHER ⇱
* For readability, some foreign key relationships have been omitted
message_id 🔑 ➤ MESSAGE
user_id 🔑 ➤ USER
MESSAGE_ASSIGNED_USER ⇱
message_id 🔑 ➤ MESSAGE
team_id 🔑 ➤ TEAM
MESSAGE_ASSIGNED_TEAM ⇱
message_id 🔑 ➤ MESSAGE
team_id 🔑 ➤ TEAM
MESSAGE_CREATED_BY_TEAM ⇱
note_id 🔑 ➤ NOTE
team_id 🔑 ➤ TEAM
NOTE_TEAM_MENTION ⇱
message_id 🔑 ➤ MESSAGE
shortcut_id 🔑 ➤ SHORTCUT
MESSAGE_SHORTCUT ⇱
index 🔑
customer_id 🔑 ➤ CUSTOMER
type
verified
CUSTOMER_EMAIL ⇱
index 🔑
customer_id 🔑 ➤ CUSTOMER
phone
type
verified
CUSTOMER_PHONE ⇱
index 🔑
customer_id 🔑 ➤ CUSTOMER
type
url
user_id
user_name
verified
CUSTOMER_SOCIAL ⇱
index 🔑
customer_id 🔑 ➤ CUSTOMER
type
url
CUSTOMER_URL ⇱
index 🔑
customer_id 🔑 ➤ CUSTOMER
address
address2
address3
area_code
city_name
country_code
country_name
latitude
longitude
name
region_code
region_name
type
zip_code
CUSTOMER_LOCATION ⇱
index 🔑
customer_id 🔑 ➤ CUSTOMER
phone
type
verified
CUSTOMER_SHARED_PHONE ⇱
index 🔑
customer_id 🔑 ➤ CUSTOMER
type
url
user_id
user_name
verified
CUSTOMER_SHARED_SOCIAL ⇱
index 🔑
customer_id 🔑 ➤ CUSTOMER
type
verified
CUSTOMER_SHARED_EMAIL ⇱
index 🔑
customer_id 🔑 ➤ CUSTOMER
external_id
verified
CUSTOMER_EXTERNAL_LINK ⇱
index 🔑
customer_id 🔑 ➤ CUSTOMER
type
url
CUSTOMER_SHARED_EXTERNAL_ID ⇱
id 🔑
message_id ➤ MESSAGE
created_by ➤ USER
modified_by ➤ USER
name
content_length
content_type
created_at
redacted
self
related
updated_at
MESSAGE_ATTACHMENT ⇱
company_id 🔑 ➤ COMPANY
tag_id 🔑 ➤ TAG
COMPANY_TAG ⇱
shortcut_id 🔑 ➤ SHORTCUT
tag_id 🔑 ➤ TAG
SHORTCUT_TAG ⇱
conversation_id 🔑 ➤ CONVERSATION_HISTORY
tag_id 🔑 ➤ TAG
CONVERSATION_SUGGESTED_TAG_HISTORY ⇱
conversation_id 🔑 ➤ CONVERSATION_HISTORY
tag_id 🔑 ➤ TAG
CONVERSATION_TAG_HISTORY ⇱
customer_id 🔑 ➤ CUSTOMER
tag_id 🔑 ➤ TAG
CUSTOMER_TAG ⇱
customer_id 🔑 ➤ CUSTOMER
tag_id 🔑 ➤ TAG
CUSTOMER_LAST_CONVERSATION_TAG ⇱
kobject_id 🔑 ➤ KOBJECT
tag_id 🔑 ➤ TAG
KOBJECT_TAG ⇱
id 🔑
created_by ➤ USER
display_name
priority
item_size
system
description
created_at
name
restrict_transfers_by_user
updated_at
_fivetran_deleted
QUEUE ⇱
team_id 🔑 ➤ TEAM
queue_id 🔑 ➤ QUEUE
TEAM_QUEUE ⇱
id 🔑
resource🔑
display_name
modified_by�type
updated_at
CUSTOM_ATTRIBUTE_METADATA ⇱
index 🔑
customer_id 🔑 ➤ CUSTOMER
phone
type
verified
CUSTOMER_SHARED_WHATSAPP ⇱
index 🔑
customer_id 🔑 ➤ CUSTOMER
phone
type
verified
CUSTOMER_WHATSAPP ⇱
id 🔑
conversation_id🔑 ➤ CONVERSATION_HISTORY
created_by ➤ USER
customer_id ➤ CUSTOMER
created_at
handle_at
handle_time
message_at
message_time
note_at
note_time
CONVERSATION_TIME ⇱
conversation_id 🔑 ➤ CONVERSATION
conversation_time_id 🔑 ➤ CONVERSATION_TIME
team_id🔑
CONVERSATION_TIME_CREATED_BY_TEAM ⇱
id 🔑
created_by ➤ USER
modified_by ➤ USER
avatar_url
channel
created_at
description
modified_at
name
public_id
public_name
start
status
template
type
updated_at
version
settings_*
ASSISTANT ⇱
id 🔑�assistant_id 🔑 ➤ ASSISTANT
name
ASSISTANT_DIALOG ⇱
id 🔑
assistant_id 🔑 ➤ ASSISTANT
assistant_dialog_id 🔑 ➤ ASSISTANT_DIALOG�type
ASSISTANT_DIALOG_NODE ⇱
id🔑
created_by ➤ USER
modified_by ➤ USER
name
default
created_at
updated_at
modified_at
BRAND ⇱
*contains more columns as key-value pair
conversation_id 🔑 ➤ CONVERSATION
conversation_time_id 🔑 ➤ CONVERSATION_TIME
channel🔑
CONVERSATION_TIME_CHANNEL ⇱