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.
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 cols