Messaging & Chat
A comprehensive messaging and chat database schema for building applications like Slack, WhatsApp, or Discord. Supports one-on-one and group conversations with member management, real-time message delivery with read receipts, and file attachments. Includes conversation types, member roles, message status tracking, and media sharing capabilities.
Created with ERD Studio
Tables in this template
usersUsers
9 colsconversationsConversations
8 colsconversation_membersConversation Members
7 colsmessagesMessages
10 colsattachmentsAttachments
7 colsreactionsReactions
5 colsread_receiptsRead Receipts
4 colscontactsContacts
6 colsblocked_usersBlocked Users
4 colsmessage_pinsMessage Pins
5 cols