• MESSAGES The message itself

  • MESSAGE_FILES Any file included in a message → Added to message in the block section

  • THREADS The message grouping thread

  • USER_MESSAGE_BOOKMARKS To save a retrieve list of available bookmarks for a given user

  • MESSAGE_CHANNEL_REFS All messages per channels + threads

  • MESSAGE_CHANNEL_MARKED_REFS Pinned messages, threads and maybe more later

  • MESSAGE_FILE_REFS Files refs for user and channels

  • MESSAGE_USER_INBOX_REFS User inbox (list of threads for an user) → We use the MESSAGE_USER_INBOX_THREAD to get records by thread_id

  • MESSAGE_USER_INBOX_THREAD Used to find the record in inbox and remove it (to have 1 record per thread and not more)

  • MESSAGE_USER_MARKED_REFS Custom user bookmarked messages