Table: slack_conversation_histories

This table shows data for Slack Conversation Histories.

https://api.slack.com/methods/conversations.history (opens in a new tab)

The composite primary key for this table is (channel_id, team_id, ts).

Relations

This table depends on slack_conversations.

The following tables depend on slack_conversation_histories:

Columns

NameType
_cq_source_nameString
_cq_sync_timeTimestamp
_cq_idUUID
_cq_parent_idUUID
channel_id (PK)String
team_id (PK)String
ts (PK)String
thread_tsString
client_msg_idString
typeString
channelString
userString
textString
is_starredBool
pinned_toStringArray
attachmentsJSON
editedJSON
last_readString
subscribedBool
unread_countInt
subtypeString
hiddenBool
deleted_tsString
event_tsString
bot_idString
usernameString
iconsJSON
bot_profileJSON
inviterString
topicString
purposeString
nameString
old_nameString
membersStringArray
reply_countInt
parent_user_idString
latest_replyString
filesJSON
uploadBool
commentJSON
item_typeString
reply_toInt
teamString
reactionsJSON
response_typeString
replace_originalBool
delete_originalBool
metadataJSON
permalinkString