Twitter / X
Complete database schema for a Twitter/X-like microblogging platform covering user accounts, tweet content, media attachments, hashtags, follow relationships, likes, retweets, notifications, direct messaging, and trending topics.
socialmicrobloggingreal-timefeednotifications
Created with ERD Studio
Tables in this template
usersUsers
10 colstweetsTweets
12 colstweet_mediaTweet Media
8 colshashtagsHashtags
5 colstweet_hashtagsTweet Hashtags
4 colslikesLikes
5 colsfollowsFollows
5 colsretweetsRetweets
5 colsnotificationsNotifications
9 colsdirect_messagesDirect Messages
8 colsdm_messagesDM Messages
8 colsdm_participantsDM Participants
5 colsblocksBlocks
5 colsbookmarksBookmarks
5 colslistsLists
9 colslist_membersList Members
5 colstrending_topicsTrending Topics
8 colsRelated Templates
View all templates →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
Professional networking platform with profiles, connections, job boards, and content
PostgreSQL15 tables
professionalnetworkingjobs+2
Social