Social database schema examples and ER diagrams
What a Social schema usually contains
Social schemas live or die on the join tables. These templates model follows, posts, reactions and threads with the relationship rows designed for the reads they will actually take.
Templates (5)
Photo Sharing Database Schema
A 28-table photo sharing database schema covering profiles, follows, posts and media, comments, likes, stories, notifications and moderation: free ER diagram and DBML.
- tables
- 28
- columns
- 192
- refs
- 60
Music Streaming Database Schema
A 26-table music streaming database schema covering artists, releases, tracks, credits, licensing, playlists, follows, play events, subscriptions and royalties: free ER diagram and DBML.
- tables
- 26
- columns
- 177
- refs
- 40
Reddit Clone Database Schema
A 108-table Reddit clone database schema with subreddits, karma, hot/best/top ranking, nested comment trees, awards and coins, AutoMod, modmail, chat and the full ad stack — free ER diagram and DBML.
- tables
- 108
- columns
- 890
- refs
- 201
Forum Database Schema
A 15-table forum database schema with boards, topics, threaded replies, voting, subscriptions, reputation badges and moderation — free ER diagram and DBML.
- tables
- 15
- columns
- 112
- refs
- 31
Social Media Database Schema
A 35-table social media database schema with follows, posts, likes, comments, stories, direct messaging, feeds and moderation — free ER diagram and DBML.
- tables
- 35
- columns
- 203
- refs
- 66