logo
ExamplesEditorPricingDocs
37.1kSign in

Pinterest database schema

How a visual bookmarking app models its data: images deduplicated by content hash, pins as saves rather than uploads, repins as a self-reference to the source pin, boards with sections and collaborators, follows of both people and boards, and saved searches.

Pinterest ER diagram

Pinterest database schema 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 display_nameVARCHAR aboutVARCHAR follower_countINTEGER pin_countINTEGER created_atTIMESTAMP images idBIGINT content_hashCHAR storage_keyVARCHAR widthINTEGER heightINTEGER dominant_colorCHAR byte_sizeINTEGER uploaded_by_idBIGINT created_atTIMESTAMP boards idBIGINT owner_idBIGINT nameVARCHAR slugVARCHAR descriptionVARCHAR is_secretBOOLEAN pin_countINTEGER follower_countINTEGER created_atTIMESTAMP board_sections idBIGINT board_idBIGINT nameVARCHAR positionSMALLINT pin_countINTEGER created_atTIMESTAMP board_collaborators board_idBIGINT user_idBIGINT roleVARCHAR statusVARCHAR invited_by_idBIGINT joined_atTIMESTAMP pins idBIGINT image_idBIGINT board_idBIGINT section_idBIGINT saver_idBIGINT source_pin_idBIGINT root_pin_idBIGINT titleVARCHAR descriptionVARCHAR destination_urlVARCHAR save_countINTEGER created_atTIMESTAMP pin_reactions pin_idBIGINT user_idBIGINT reactionVARCHAR created_atTIMESTAMP pin_comments idBIGINT pin_idBIGINT author_idBIGINT parent_comment_idBIGINT bodyVARCHAR created_atTIMESTAMP user_follows follower_idBIGINT followee_idBIGINT created_atTIMESTAMP board_follows board_idBIGINT user_idBIGINT created_atTIMESTAMP saved_searches idBIGINT user_idBIGINT queryVARCHAR filtersJSONB notify_on_newBOOLEAN last_run_atTIMESTAMP created_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.

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.

PostgreSQL
Social

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.