channel_id 🔑 ➤ CHANNEL
user_id🔑 ➤ USERS
CHANNEL_MEMBER ⇱
previous_name🔑
channel_id 🔑 ➤ CHANNEL
PERVIOUS_CHANNEL_NAME ⇱
internal_team_id 🔑
channel_id🔑 ➤ CHANNEL
CHANNEL_INTERNAL_TEAM ⇱
pending_connected_team_id 🔑
channel_id 🔑 ➤ CHANNEL
CHANNEL_PENDING_CONNECTED_TEAM ⇱
shared_team_id 🔑
channel_id 🔑 ➤ CHANNEL
CHANNEL_SHARED_TEAM ⇱
id 🔑
channel_id 🔑 ➤ CHANNEL
last_updated_by_user_id ➤ USERS
app_id
date_created
date_updated
emoji
entity_id
icon_url
last_updated_by_team_id
link
rank
shortcut_id
title
type
BOOKMARK ⇱
id 🔑
channel_id 🔑 ➤ CHANNEL
date_created
post_at
text
SCHEDULED_MESSAGE ⇱
id 🔑
user_id ➤ USERS
creator ➤ USERS
complete_ts
item
recurrence
recurrence_frequency
recurring
text
time
REMINDER ⇱
id🔑
color
deleted
is_admin
is_app_user
is_bot
is_email_confirmed
is_owner
is_primary_owner
is_restricted
Is_ultra_restricted
locale
name
profile_email
profile_always_active
profile_api_app_id
profile_avatar_hash
profile_bot_id
profile_display_name
profile_display_name_normalized
profile_fields
profile_first_name
profile_image_192
profile_image_24
profile_image_32
profile_image_48
profile_image_512
profile_image_72
profile_last_name
profile_phone
profile_real_name
profile_real_name_normalized
profile_skype
profile_status_emoji
profile_status_emoji_display_info
profile_status_expiration
profile_status_text
profile_status_text_canonical
profile_team
profile_title
real_name
team_id
time_zone
time_zone_label
time_zone_offset
updated
who_can_share_contact_card
USERS ⇱
id🔑
created_by➤ USERS
deleted_by➤ USERS
updated_by➤ USERS
auto_type
date_create
date_delete
date_update
description
handle
is_external
is_usergroup
name
team_id
USERGROUP ⇱
user_id 🔑 ➤ USERS
usergroup_id ➤ USERGROUP
USERGROUP_USER ⇱
public_channel_id 🔑
usergroup_id 🔑 ➤ USERGROUP
USERGROUP_PREFS_CHANNEL ⇱
private_channel_id 🔑
usergroup_id 🔑 ➤ USERGROUP
USERGROUP_PREFS_GROUP ⇱
_fivetran_id🔑
user_id ➤ USERS
dnd_enabled
next_dnd_end_ts
next_dnd_start_ts
snooze_enabled
snooze_endtime
snooze+is_idenfinite
snooze_remaining
DND_INFO ⇱
id🔑
creator ➤ USERS
created
is_archived
is_channel
is_ext_shared
is_general
is_group
is_im
is_member
is_mpim
is_org_shared
is_pending_ext_shared
is_private
is_shared
name
name_normalized
num_members
parent_conversation
purpose_creator
purpose_last_set
purpose_value
topic_creator
topic_last_set
topic_value
unlinked
CHANNEL ⇱
id 🔑
hint
is_hidden
label
options_is_protected
ordering
type
PROFILE_FIELD ⇱
possible_value🔑
profile_field_id🔑 ➤ PROFILE_FIELD
PROFILE_FIELD_POSSIBLE_VALUE ⇱
name 🔑
profile_field_id 🔑 ➤ PROFILE_FIELD
value
PROFILE_FIELD_OPTION ⇱
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
pending_shared_id 🔑
channel_id🔑 ➤ CHANNEL
CHANNEL_PENDING_SHARED ⇱
ts🔑
channel_id🔑 ➤ CHANNEL
edited_user ➤ USERS
user ➤ USERS
client_msg_id
display_as_bot
edited_ts
is_starred
source_team
team
text
type
upload
user_team
MESSAGE ⇱
id🔑
message_channel_id ➤ MESSAGE
message_ts ➤ MESSAGE
user_id➤ USERS
created
display_as_bot
editable
external_type
filetype
has_rich_preview
image_exif_rotation
is_external
is_public
is_starred
media_display_type
mime_type
mode
name
permalink
permalink_public
pretty_type
public_url_shared
size
thumb_160
thumb_360
thumb_360_h
thumb_360_w
thumb_480
thumb_480_h
thumb_480_w
thumb_64
thumb_80
thumb_tiny
timestamps
title
url_private
url_private_download
MESSAGE_FILE ⇱
name🔑
message_ts🔑 ➤ MESSAGE
message_channel_id🔑 ➤ MESSAGE
count
MESSAGE_REACTION ⇱
channel_id🔑
message_channel_id🔑 ➤ MESSAGE
message_ts🔑 ➤ PINNED_ MESSAGE
MESSAGE_PINNED_TO ⇱
pinned_ts🔑
message_ts🔑 ➤ MESSAGE
message_channel_id🔑 ➤ MESSAGE
pinned_by ➤ USERS
PINNED_MESSAGE ⇱
id 🔑
message_ts ➤MESSAGE
message_channel_id ➤ MESSAGE
fallback
from_url
image_bytes
image_height
image_url
image_width
original_url
service_name
text
title
title_link
MESSAGE_ATTACHMENT ⇱
message_channel_id🔑 ➤ MESSAGE_REACTION
message_ts 🔑 ➤ MESSAGE_REACTION
message_reaction_name 🔑 ➤ MESSAGE_REACTION
user_id 🔑 ➤ USERS
MESSAGE_REACTION_USER ⇱
index 🔑
message_channel_id🔑 ➤ CHANNEL
message_ts🔑 ➤ MESSAGE
block_id
type
MESSAGE_BLOCK ⇱
index 🔑
message_block_index🔑 ➤ MESSAGE_BLOCK
message_block_message_ts🔑 ➤ MESSAGE_BLOCK
message_channel_id🔑 ➤ MESSAGE_BLOCK
elements
type
MESSAGE_BLOCK_ELEMENT ⇱
ts🔑
channel_id🔑 ➤ CHANNEL
parent_message_ts🔑 ➤ MESSAGE
user_id ➤ USERS
client_msg_id
is_locked
last_reply
last_read
source_team
subscribed
subtype
thread_ts
team
text
type
MESSAGE_REPLY ⇱
name 🔑 ➤ MESSAGE_REPLY_REACTION
message_reply_channel_id🔑 ➤ MESSAGE_REPLY_REACTION
message_reply_ts🔑 ➤ MESSAGE_REPLY_REACTION
parent_message_ts🔑 ➤ MESSAGE_REPLY_REACTION
user_id 🔑 ➤ USERS
MESSAGE_REPLY_REACTION_USER ⇱
index 🔑
message_reply_channel_id🔑 ➤ MESSAGE_REPLY
message_reply_ts🔑 ➤ MESSAGE_REPLY
parent_message_ts🔑 ➤ MESSAGE_REPLY
block_id
type
MESSAGE_REPLY_BLOCK ⇱
index 🔑
message_reply_block_index🔑 ➤ MESSAGE_REPLY_BLOCK
message_reply_channel_id🔑 ➤ MESSAGE_REPLY_BLOCK
message_reply_ts🔑 ➤ MESSAGE_REPLY_BLOCK
parent_message_ts🔑 ➤ MESSAGE_REPLY_BLOCK
elements
type
MESSAGE_REPLY_BLOCK_ELEMENT ⇱
id🔑
message_reply_channel_id ➤ MESSAGE_REPLY
message_reply_ts ➤ MESSAGE_REPLY
parent_message_ts ➤ MESSAGE_REPLY
user_id ➤ USERS
created
display_as_bot
editable
external_type
filetype
has_rich_preview
image_exif_rotation
is_external
is_public
is_starred
media_display_type
mime_type
mode
name
permalink
permalink_public
pretty_type
public_url_shared
size
thumb_160
thumb_360
thumb_360_h
thumb_360_w
thumb_480
thumb_480_h
thumb_480_w
thumb_64
thumb_80
thumb_tiny
timestamp
title
url_private
url_private_download
username
MESSAGE_REPLY_FILE ⇱
name🔑
message_reply_channel_id🔑 ➤ MESSAGE_REPLY
message_reply_ts🔑 ➤ MESSAGE_REPLY
parent_message_ts🔑 ➤ MESSAGE_REPLY
count
MESSAGE_REPLY_REACTION ⇱
channel_id🔑 ➤ MESSAGE_REPLY
message_reply_channel_id🔑 ➤ MESSAGE_REPLY
message_reply_ts🔑 ➤ MESSAGE_REPLY
parent_message_ts🔑 ➤ MESSAGE_REPLY
MESSAGE_REPLY_PINNED_TO ⇱
pinned_ts🔑
message_reply_channel_id🔑 ➤ MESSAGE_REPLY
message_reply_ts🔑 ➤ MESSAGE_REPLY
parent_message_ts🔑 ➤ MESSAGE_REPLY
pinned_by ➤ USERS
PINNED_MESSAGE_REPLY ⇱
_fivetran_id 🔑
id
message_reply_channel_id ➤ MESSAGE_REPLY
message_reply_ts ➤ MESSAGE_REPLY
parent_message_ts ➤ MESSAGE_REPLY
fallback
from_url
image_bytes
image_height
image_url
image_width
original_url
service_name
text
title
title_link
MESSAGE_REPLY_ATTACHMENT ⇱
message_reply_channel_id🔑 ➤ MESSAGE_REPLY
message_reply_ts🔑 ➤ MESSAGE_REPLY
parent_message_ts🔑 ➤ MESSAGE_REPLY
reply_user_id 🔑 ➤ USERS
MESSAGE_REPLY_USER⇱