Social Network
A complete social network database schema designed for platforms like Facebook or Twitter. Includes user accounts with detailed profiles, post creation and sharing, threaded comments, bidirectional friendship management with status tracking, and post/comment likes. Suitable for building social media applications, community platforms, or any project requiring social interactions.
social-networksocial-mediapostscommentsfriendshipslikes
Created with ERD Studio
Tables in this template
usersUsers
8 colsprofilesProfiles
10 colspostsPosts
8 colspost_mediaPost Media
6 colscommentsComments
8 colslikesLikes
5 colsfriendshipsFriendships
4 colsfriend_requestsFriend Requests
6 colsnotificationsNotifications
8 colsblocksBlocks
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