logo
ExamplesEditorPricingDocs
37.1kSign in

Social network database schema

Followers, feeds and direct messages modelled for read volume: asymmetric follows, one posts table for replies and reposts, narrow like rows, per-participant read pointers and notifications.

Social Network ER diagram

Social network database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 users idBIGINT usernameVARCHAR emailVARCHAR password_hashVARCHAR display_nameVARCHAR bioVARCHAR avatar_urlVARCHAR is_privateBOOLEAN is_verifiedBOOLEAN follower_countINTEGER following_countINTEGER created_atTIMESTAMP deactivated_atTIMESTAMP follows idBIGINT follower_idBIGINT followee_idBIGINT statusVARCHAR created_atTIMESTAMP blocks idBIGINT blocker_idBIGINT blocked_idBIGINT created_atTIMESTAMP posts idBIGINT author_idBIGINT parent_post_idBIGINT repost_of_idBIGINT bodyVARCHAR visibilityVARCHAR like_countINTEGER reply_countINTEGER repost_countINTEGER created_atTIMESTAMP deleted_atTIMESTAMP post_media idBIGINT post_idBIGINT storage_keyVARCHAR media_typeVARCHAR widthINTEGER heightINTEGER duration_secondsINTEGER alt_textVARCHAR positionINTEGER likes user_idBIGINT post_idBIGINT created_atTIMESTAMP comments idBIGINT post_idBIGINT author_idBIGINT parent_comment_idBIGINT bodyVARCHAR like_countINTEGER created_atTIMESTAMP deleted_atTIMESTAMP conversations idBIGINT is_groupBOOLEAN titleVARCHAR created_by_idBIGINT last_message_atTIMESTAMP created_atTIMESTAMP conversation_partic… conversation_idBIGINT user_idBIGINT joined_atTIMESTAMP last_read_message…BIGINT mutedBOOLEAN left_atTIMESTAMP messages idBIGINT conversation_idBIGINT sender_idBIGINT bodyVARCHAR media_keyVARCHAR created_atTIMESTAMP edited_atTIMESTAMP deleted_atTIMESTAMP notifications idBIGINT recipient_idBIGINT actor_idBIGINT notification_typeVARCHAR target_typeVARCHAR target_idBIGINT is_readBOOLEAN created_atTIMESTAMP

Related database schemas

PostgreSQL
Media & content

Blog & CMS database schema

A content management schema that survives contact with editors: posts with an append-only revision history, categories and tags, threaded comments, a real media library, slug redirects and a double opt-in newsletter list.

PostgreSQL
Internal tools

Project management & issue tracker database schema

A Jira-shaped tracker: projects with human-readable issue keys, subtasks through a self-reference, fractional board positions for drag-and-drop, labels, milestones, comments, attachments and a worklog.

PostgreSQL
SaaS

Multi-tenant SaaS database schema

Shared-database multi-tenancy done properly: organizations as tenants, global users joined through memberships, invitations, scoped API keys, plans, subscriptions, metered usage and an append-only audit log.

PostgreSQL
Social

Instagram database schema

How a photo-sharing app models its data: asymmetric follows with pending requests for private accounts, posts carrying an ordered carousel of media, likes and two-level comments, stories that expire, saved collections and direct messages.