Slack
Explore the interactive ERD
Table & Field Reference
user_group_user
| Column | Type | Keys |
|---|---|---|
user_group_id | String | PKFK |
user_id | String | PKFK |
user_group_prefs_channel
| Column | Type | Keys |
|---|---|---|
public_channel_id | String | PK |
user_group_id | String | PKFK |
user_group_prefs_group
| Column | Type | Keys |
|---|---|---|
private_channel_id | String | PK |
user_group_id | String | PKFK |
user_group
| Column | Type | Keys |
|---|---|---|
id | String | PK |
created_by | String | FK |
deleted_by | String | FK |
updated_by | String | FK |
auto_type | String | |
date_create | Instant | |
date_delete | Instant | |
date_update | Instant | |
description | String | |
handle | String | |
is_external | Boolean | |
is_user_group | Boolean | |
name | String | |
team_id | String | |
user_count | Unknown |
channel_member
| Column | Type | Keys |
|---|---|---|
channel_id | String | PKFK |
user_id | String | PKFK |
team_preference
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
allow_message_deletion | Boolean | |
disable_file_uploads | String | |
display_real_names | Boolean | |
msg_edit_window_mins | Unknown | |
who_can_post_general | String |
dnd_info
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
user_id | String | FK |
dnd_enabled | Boolean | |
next_dnd_end_ts | Instant | |
next_dnd_start_ts | Instant | |
snooze_enabled | Boolean | |
snooze_endtime | Instant | |
snooze_is_indefinite | Boolean | |
snooze_remaining | Unknown |
remote_file_channel
| Column | Type | Keys |
|---|---|---|
remote_file_channel | String | PK |
remote_file_id | String | PKFK |
remote_file
| Column | Type | Keys |
|---|---|---|
id | String | PK |
channel_id | String | PKFK |
user_id | String | FK |
created | Instant | |
deanimate_gif | String | |
display_as_bot | Boolean | |
editable | Boolean | |
external_type | String | |
filetype | String | |
image_exif_rotation | String | |
is_external | Boolean | |
is_public | Boolean | |
mimetype | String | |
mode | String | |
name | String | |
original_h | String | |
original_w | String | |
permalink | String | |
permalink_public | String | |
pjpeg | String | |
pretty_type | String | |
public_url_shared | Boolean | |
size | Unknown | |
thumb_160 | String | |
thumb_360 | String | |
thumb_360_gif | String | |
thumb_360_h | String | |
thumb_360_w | String | |
thumb_64 | String | |
thumb_80 | String | |
timestamps | Instant | |
title | String | |
url_private | String | |
url_private_download | String | |
username | String |
message_reply_user
| Column | Type | Keys |
|---|---|---|
message_channel_id | String | PKFK |
message_ts | String | PKFK |
parent_message_ts | String | PKFK |
reply_user_id | String | PKFK |
message_block_element
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
message_channel_id | String | PKFK |
message_ts | String | PKFK |
parent_message_ts | String | PKFK |
message_block_index | Unknown | FK |
elements | String | |
type | String |
message_block
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
message_channel_id | String | PKFK |
message_ts | String | PKFK |
parent_message_ts | String | PKFK |
block_id | String | |
type | String |
message_file
| Column | Type | Keys |
|---|---|---|
id | String | PK |
message_channel_id | String | FK |
message_ts | String | FK |
parent_message_ts | String | FK |
user_id | String | FK |
created | Instant | |
display_as_bot | Boolean | |
edit_link | String | |
editable | Boolean | |
external_type | String | |
filetype | String | |
has_rich_preview | Boolean | |
is_external | Boolean | |
is_public | Boolean | |
is_starred | Boolean | |
lines | Unknown | |
lines_more | Unknown | |
mimetype | String | |
mode | String | |
name | String | |
permalink | String | |
permalink_public | String | |
pretty_type | String | |
preview | String | |
preview_highlight | String | |
preview_is_truncated | Boolean | |
public_url_shared | Boolean | |
size | Unknown | |
timestamps | Instant | |
title | String | |
url_private | String | |
url_private_download | String |
message_attachment
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
message_channel_id | String | FK |
message_ts | String | FK |
parent_message_ts | String | FK |
fallback | String | |
from_url | String | |
id | Unknown | |
image_bytes | Unknown | |
image_height | String | |
image_url | String | |
image_width | String | |
original_url | String | |
service_name | String | |
text | String | |
title | String | |
title_link | String |
message_reaction_user
| Column | Type | Keys |
|---|---|---|
message_channel_id | String | PKFK |
message_reaction_name | String | PKFK |
message_ts | String | PKFK |
parent_message_ts | String | PKFK |
user_id | String | PKFK |
message_reaction
| Column | Type | Keys |
|---|---|---|
name | String | PK |
message_channel_id | String | PKFK |
message_ts | String | PKFK |
parent_message_ts | String | PKFK |
count | String |
message
| Column | Type | Keys |
|---|---|---|
ts | String | PK |
message_channel_id | String | PKFK |
parent_message_ts | String | PKFK |
user_id | String | FK |
edited_ts | Unknown | |
edited_user | String | |
is_locked | String | |
last_read | String | |
latest_reply | Unknown | |
reply_count | Unknown | |
reply_users_count | Unknown | |
source_team | String | |
subscribed | String | |
subtype | String | |
team | String | |
text | String | |
thread_ts | Unknown | |
type | String |
bookmark
| Column | Type | Keys |
|---|---|---|
id | String | PK |
channel_id | String | FK |
last_updated_by_user_id | String | FK |
app_id | String | |
date_created | Instant | |
date_updated | Instant | |
emoji | String | |
entity_id | String | |
icon_url | String | |
last_updated_by_team_id | String | |
link | String | |
rank | String | |
shortcut_id | String | |
title | String | |
type | String |
scheduled_message
| Column | Type | Keys |
|---|---|---|
id | String | PK |
channel_id | String | FK |
date_created | Instant | |
post_at | Instant | |
text | String |
chat_permalink
| Column | Type | Keys |
|---|---|---|
permalink | String | PK |
channel_id | String | PKFK |
message_ts | String | PKFK |
profile_field_possible_value
| Column | Type | Keys |
|---|---|---|
possible_value | String | PK |
profile_field_id | String | PKFK |
profile_field_option
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
profile_field_id | String | PKFK |
value | Unknown |
profile_field
| Column | Type | Keys |
|---|---|---|
id | String | PK |
hint | String | |
is_hidden | Unknown | |
label | String | |
options_is_protected | Unknown | |
ordering | Unknown | |
type | String |
pin
| Column | Type | Keys |
|---|---|---|
channel_id | String | PKFK |
message_ts | String | PKFK |
created_by | String | FK |
pinned_time | String |
channel_pending_shared
| Column | Type | Keys |
|---|---|---|
pending_shared_id | String | PK |
channel_id | String | PKFK |
channel_shared_team
| Column | Type | Keys |
|---|---|---|
shared_team_id | String | PK |
channel_id | String | PKFK |
channel_internal_team
| Column | Type | Keys |
|---|---|---|
internal_team_id | String | PK |
channel_id | String | PKFK |
channel_pending_connected_team
| Column | Type | Keys |
|---|---|---|
pending_connected_team_id | String | PK |
channel_id | String | PKFK |
previous_channel_name
| Column | Type | Keys |
|---|---|---|
previous_name | String | PK |
channel_id | String | PKFK |
channel
| Column | Type | Keys |
|---|---|---|
id | String | PK |
creator | String | FK |
created | Instant | |
is_archived | Boolean | |
is_channel | Boolean | |
is_ext_shared | Boolean | |
is_general | Boolean | |
is_group | Boolean | |
is_im | Boolean | |
is_moved | Unknown | |
is_mpim | Boolean | |
is_org_shared | Boolean | |
is_pending_ext_shared | Boolean | |
is_private | Boolean | |
is_shared | Boolean | |
name | String | |
name_normalized | String | |
parent_conversation | Boolean | |
purpose_creator | String | |
purpose_last_set | Instant | |
purpose_value | String | |
topic_creator | String | |
topic_last_set | Instant | |
topic_value | String | |
unlinked | Unknown |
team_billing
| Column | Type | Keys |
|---|---|---|
plan | String | PK |
users
| Column | Type | Keys |
|---|---|---|
id | String | PK |
always_active | Unknown | |
app_api_id | Unknown | |
avatar_hash | String | |
bot_id | Unknown | |
color | String | |
deleted | Boolean | |
display_name | String | |
display_name_normalized | String | |
email | Unknown | |
first_name | String | |
image_192 | String | |
image_24 | String | |
image_32 | String | |
image_48 | String | |
image_512 | String | |
image_72 | String | |
is_admin | Boolean | |
is_app_user | Boolean | |
is_bot | Boolean | |
is_email_confirmed | Boolean | |
is_owner | Boolean | |
is_primary_owner | Boolean | |
is_restricted | Boolean | |
is_ultra_restricted | Boolean | |
last_name | String | |
locale | String | |
name | String | |
phone | String | |
real_name | String | |
real_name_normalized | String | |
skype | String | |
start_date | Unknown | |
status_emoji | String | |
status_emoji_display_info | Json | |
status_expiration | Unknown | |
status_text | String | |
status_text_canonical | String | |
team | Unknown | |
team_id | String | |
time_zone | String | |
time_zone_label | String | |
time_zone_offset | String | |
title | String | |
updated | Unknown | |
who_can_share_contact_card | String |