HomeSocial MediaTwitter Clone

Twitter Clone

Microblogging platform with threaded replies, hashtags, retweets, likes, DMs, and follower feeds

SchemaVerse
Social MediaPostgreSQLSocialNormalizedHierarchical
11
0
0
twitter-clone.dbml
15 tables|26 relations

About this Schema

Overview

Complete Twitter-like social network schema. Supports short-form posts (tweets), threaded conversations, hashtag discovery, social graph (followers), and direct messaging.

Key Design Decisions

  • Threaded Replies: Nested comment structure for conversations
  • Hashtag System: Extract and index hashtags for discovery
  • Social Graph: Bidirectional follow relationships
  • Direct Messages: Private one-on-one conversations

Tables

15 tables including tweets, replies, hashtags, follows, likes, retweets, DMs, notifications, and user profiles. Optimized for high-volume social interactions.

Comments

Sign in to comment on this schema

Loading comments...