Complete database schema for an Instagram-like visual social platform featuring user profiles, photo and video posts with multiple media, Instagram Stories with viewer tracking, Reels short-form video, comment threads, likes, hashtag discovery, follow relationships, close friends lists, direct messaging with threads, and highlight collections.
photosocialstoriesreelsinfluencer
Created with ERD Studio
Tables in this template
usersUsers
9 colsprofilesProfiles
11 colspostsPosts
9 colspost_mediaPost Media
9 colshashtagsHashtags
4 colspost_hashtagsPost Hashtags
4 colsfollowsFollows
5 colsstoriesStories
8 colsstory_viewsStory Views
4 colshighlightsHighlights
6 colshighlight_itemsHighlight Items
5 colscommentsComments
8 colspost_likesPost Likes
4 colsdm_threadsDM Threads
5 colsdm_participantsDM Participants
5 colsdirect_messagesDirect Messages
8 colsreelsReels
10 colsRelated Templates
View all templates →Twitter / X
CloneMicroblogging platform with tweets, follows, likes, retweets, and DMs
PostgreSQL17 tables
socialmicrobloggingreal-time+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