Medium Clone
Complete database schema for a Medium-like online publishing platform featuring user profiles, publication management with member roles, article publishing with rich metadata, nested response threads, clap reaction system, bookmarks, user and publication follows, reading lists, personalized notifications, and paid subscription management.
bloggingpublishingarticlesmedium
Created with ERD Studio
Tables in this template
usersUsers
10 colspublicationsPublications
9 colspublication_membersPublication Members
5 colstagsTags
3 colsarticlesArticles
16 colsarticle_tagsArticle Tags
4 colsresponsesResponses
8 colsarticle_clapsArticle Claps
5 colsresponse_clapsResponse Claps
5 colsbookmarksBookmarks
4 colsuser_followsUser Follows
4 colsreading_listReading List
5 colsnotificationsNotifications
8 colssubscriptionsSubscriptions
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