id🔑
address
type
name
send_as
INBOX ⇱
id🔑
teammate_id ➤ TEAMMATE
subject
status
recipient_handle
recipient _role
created_at
CONVERSATION ⇱
id🔑
username
first_name
last_name
is_admin
Is_available
TEAMMATE ⇱
tag_id🔑 ➤ TAG
conversation_id 🔑 ➤ CONVERSATION
CONVERSATION_TAG ⇱
id🔑
author_id ➤ TEAMMATE
conversation_id ➤ CONVERSATION
type
is_inbound
created_at
blurb
body
text
metadata_intercom_url
metadata_duration
metadata_have_been_answered
metadata_twittter_url
metadata_is_retweet
metadata_have_been_retweeted
metadata_have_been_fovorited
metadata_thread_ref
metadata_headers
MESSAGE ⇱
id🔑
message_id 🔑 ➤ MESSAGE
contact_id ➤ CONTACT
handle
role
MESSAGE_RECIPIENT ⇱
id🔑
message_id 🔑 ➤ MESSAGE
filename
url
content_type
size
metadata_is_online
metadata_cid
ATTACHMENT ⇱
id🔑
address
type
send_as
settings
CHANNEL ⇱
id🔑
conversation_id ➤ CONVERSATION
author_id ➤ TEAMMATE
body
posted_at
COMMENT ⇱
comment_id🔑 ➤ COMMENT
teammate_id 🔑 ➤ TEAMMATE
COMMENT_MENTION ⇱
id🔑
account_id ➤ ACCOUNT
name
description
avatar_url
is_spammer
custom_*
CONTACT ⇱
id🔑
contact_id 🔑 ➤ CONTACT
link
CONTACT_LINK ⇱
id🔑
contact_id 🔑 ➤ CONTACT
handle
source
CONTACT_HANDLE ⇱
contact_id 🔑 ➤ CONTACT
group_id 🔑 ➤ GROUP
CONTACT_GROUP ⇱
id🔑
contact_id🔑 ➤ CONTACT
author_id ➤ TEAMMATE
created_at
body
CONTACT_NOTE ⇱
conversation_id 🔑 ➤ CONVERSATION
teammate_id 🔑 ➤ TEAMMATE
FOLLOWER ⇱
inbox_id 🔑 ➤ INBOX
teammate_id 🔑 ➤ TEAMMATE
INBOX_TEAMMATE ⇱
conversationid 🔑 ➤ CONVERSATION
inbox_id 🔑 ➤ INBOX
CONVERSATION_INBOX ⇱
inbox_id 🔑 ➤ INBOX
channel_id 🔑 ➤ CHANNEL
INBOX_CHANNEL ⇱
id 🔑
name
RULE ⇱
id 🔑
rule_id 🔑 ➤ RULE
action
RULE_ACTION ⇱
id🔑
created_at
highlight
is_private
name
parent_tag_id
updated_at
TAG ⇱
status🔑
updated_at 🔑
conversation_id 🔑 ➤ CONVERSATION
target_teammate_id ➤ TEAMMATE
source_teammate_id ➤ TEAMMATE
source_rule_id ➤ RULE
source_type
CONVERSATION_STATUS_HISTORY ⇱
tag_id🔑 ➤ TAG
updated_at 🔑
conversation_id 🔑 ➤ CONVERSATION
source_teammate_id ➤ TEAMMATE
source_rule_id ➤ RULE
source_type
event_type
CONVERSATION_TAG_HISTORY ⇱
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
id🔑
name
GROUP ⇱
id🔑
name
TEAM ⇱
team_id 🔑 ➤ TEAM
teammate_id 🔑 ➤ TEAMMATE
TEAM_TEAMMATE ⇱
id🔑
created_at
name
times
timezone
updated_at
SHIFT ⇱
shift_id 🔑 ➤ SHIFT
teammate_id 🔑 ➤ TEAMMATE
SHIFT_TEAMMATE ⇱
team_id 🔑 ➤ TEAM
inbox_id 🔑 ➤ INBOX
TEAM_INBOX ⇱
id🔑
created_at
description
domains
external_id
logo_url
name
updated_at
custom_*
ACCOUNT ⇱
contact_id 🔑 ➤ CONTACT
list_id 🔑 ➤ LIST
CONTACT_LIST ⇱
id🔑
name
LIST ⇱