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.
messagingchatreal-timeconversationsattachments
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 colsRelated Templates
View all templates →Twitter / X
CloneMicroblogging platform with tweets, follows, likes, retweets, and DMs
PostgreSQL17 tables
socialmicrobloggingreal-time+2
Social
Photo and video sharing platform with stories, reels, explore, and direct messaging
PostgreSQL17 tables
photosocialstories+2
Social
YouTube
CloneVideo streaming platform with channels, videos, playlists, comments, and monetization
PostgreSQL15 tables
videostreamingcontent+2
Social
Reddit Clone
CloneCommunity voting platform with subreddits, posts, comments, and awards
PostgreSQL16 tables
socialcommunityvoting+2
Social