logo
ExamplesEditorPricingDocs
37.1kSign in

Reddit database schema

How a forum models its data: subreddits and subscriptions, link and text posts, arbitrarily deep comment trees stored as materialised paths, narrow vote tables, karma, flairs, and an append-only moderation log with removal reasons.

Reddit ER diagram

Reddit database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 users idBIGINT usernameVARCHAR emailVARCHAR post_karmaINTEGER comment_karmaINTEGER is_suspendedBOOLEAN created_atTIMESTAMP subreddits idBIGINT nameVARCHAR titleVARCHAR descriptionTEXT visibilityVARCHAR is_nsfwBOOLEAN subscriber_countINTEGER created_by_idBIGINT created_atTIMESTAMP subscriptions subreddit_idBIGINT user_idBIGINT is_favoriteBOOLEAN subscribed_atTIMESTAMP posts idBIGINT subreddit_idBIGINT author_idBIGINT kindVARCHAR titleVARCHAR urlVARCHAR bodyTEXT flair_idBIGINT scoreINTEGER comment_countINTEGER is_lockedBOOLEAN removed_atTIMESTAMP created_atTIMESTAMP comments idBIGINT post_idBIGINT author_idBIGINT parent_comment_idBIGINT pathVARCHAR depthSMALLINT bodyTEXT scoreINTEGER is_removedBOOLEAN created_atTIMESTAMP post_votes post_idBIGINT user_idBIGINT valueSMALLINT created_atTIMESTAMP comment_votes comment_idBIGINT user_idBIGINT valueSMALLINT created_atTIMESTAMP moderators subreddit_idBIGINT user_idBIGINT permissionsVARCHAR added_by_idBIGINT added_atTIMESTAMP removal_reasons idBIGINT subreddit_idBIGINT titleVARCHAR messageTEXT positionSMALLINT is_activeBOOLEAN mod_actions idBIGINT subreddit_idBIGINT moderator_idBIGINT actionVARCHAR target_post_idBIGINT target_comment_idBIGINT target_user_idBIGINT removal_reason_idBIGINT noteVARCHAR created_atTIMESTAMP flairs idBIGINT subreddit_idBIGINT kindVARCHAR textVARCHAR background_colorCHAR is_mod_onlyBOOLEAN user_flairs subreddit_idBIGINT user_idBIGINT flair_idBIGINT text_overrideVARCHAR assigned_atTIMESTAMP

Related database schemas

PostgreSQL
Social

Facebook database schema

How a social network models its data: symmetric friendships stored as one canonical row, posts with audience scoping, typed reactions, groups with membership roles, pages, and events with RSVPs.

MySQL
Communication

Discussion forum and community database schema

The phpBB and Discourse shape rather than the Reddit one: curated categories and boards, threads bumped by replies, flat numbered posts with quoting, reputation and badges, a report-driven moderation queue and private messages.

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.

PostgreSQL
Social

LinkedIn database schema

How a professional network models its data: profiles with a date-ranged career history, symmetric connections created from invitations, canonical skills with endorsements, company pages, job postings and applications, and a feed.