WhatsApp Clone
Complete database schema for a WhatsApp-like real-time messaging platform featuring user accounts, contact management, group messaging with member roles, private and group conversations, message delivery status tracking, emoji reactions, rich media attachments, ephemeral stories with view tracking, audio and video call logs, multi-device support, and user blocking functionality.
messagingchatrealtimewhatsapp
Created with ERD Studio
Tables in this template
usersUsers
10 colscontactsContacts
5 colsgroupsGroups
8 colsgroup_membersGroup Members
5 colsconversationsConversations
6 colsconversation_participantsConversation Participants
6 colsmessagesMessages
9 colsmessage_statusMessage Status
6 colsmessage_reactionsMessage Reactions
5 colsmessage_mediaMessage Media
9 colsstoriesStories
8 colsstory_viewsStory Views
4 colsblocked_usersBlocked Users
4 colscall_logsCall Logs
8 colscall_participantsCall Participants
5 colsdevicesDevices
7 colsRelated Templates
View all templates →GitHub
CloneCode hosting platform with repositories, issues, pull requests, and CI/CD
PostgreSQL16 tables
developer-toolsgitcollaboration+2
Web App
Netflix
CloneVideo streaming platform with content catalog, profiles, subscriptions, and recommendations
PostgreSQL15 tables
streamingvideosubscription+2
Web App
Spotify
CloneMusic streaming platform with tracks, artists, albums, playlists, and social features
PostgreSQL18 tables
musicstreamingplaylist+2
Web App
Discord
CloneCommunity platform with servers, channels, roles, voice, and bots
PostgreSQL15 tables
gamingcommunityvoice+2
Web App