Database structure
https://excalidraw.com/#token#json=XYLUkZaVmv0MpDtw2fQKk6583019510956032,3U8twxl8OgyBScD1yXFTXQ
...
New additions are colored green.
Table | Column | Definition |
|---|---|---|
Channels | TotalMsgCountRoot | Total number of root messages |
ChannelMembers | MsgCountRoot | Number of seen root messages |
MentionCountRoot | Number of unread mentions in root messages | |
Threads | PostId | Id of the root post |
ChannelId | ||
ReplyCount | Number or reply posts in this thread | |
LastReplyAt | Timestamp of the last reply | |
Participants | json array of all thread member IDs | |
ThreadMemberships | PostId | Id of the root post |
UserId | Id of the user | |
Following | Is the thread followed | |
UnreadMentions | Number of unread mentions for this user in the thread | |
LastViewed | Timestamp of when the thread was last viewed | |
LastUpdated | Timestamp of the last change to the thread (follow state, mentions, etc) |
...