logo
ExamplesEditorPricingDocs
37.1kSign in

News site paywall database schema

How a digital newspaper models a metered paywall: articles with revisions, the per-reader meter, plans and subscriptions, gift links, newsletters and moderated comments.

News Paywall ER diagram

News site paywall database schema n1 n1 11 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 sections idBIGINT parent_idBIGINT nameVARCHAR slugVARCHAR default_accessVARCHAR positionINTEGER authors idBIGINT slugVARCHAR display_nameVARCHAR roleVARCHAR bioTEXT emailVARCHAR activeBOOLEAN articles idBIGINT section_idBIGINT live_revision_idBIGINT slugVARCHAR kickerVARCHAR access_levelVARCHAR statusVARCHAR published_atTIMESTAMPTZ updated_atTIMESTAMPTZ word_countINTEGER article_revisions idBIGINT article_idBIGINT revision_numberINTEGER headlineVARCHAR standfirstVARCHAR bodyTEXT free_excerpt_charsINTEGER change_noteVARCHAR created_byBIGINT created_atTIMESTAMPTZ article_authors article_idBIGINT author_idBIGINT positionINTEGER contributionVARCHAR readers idBIGINT emailVARCHAR anonymous_keyVARCHAR display_nameVARCHAR registered_atTIMESTAMPTZ comment_statusVARCHAR created_atTIMESTAMPTZ plans idBIGINT codeVARCHAR nameVARCHAR price_centsINTEGER currency_codeCHAR intervalVARCHAR meter_limitINTEGER gift_allowanceINTEGER includes_archiveBOOLEAN activeBOOLEAN subscriptions idBIGINT reader_idBIGINT plan_idBIGINT statusVARCHAR provider_referenceVARCHAR current_period_st…TIMESTAMPTZ current_period_endTIMESTAMPTZ cancel_at_period_…BOOLEAN started_atTIMESTAMPTZ meter_periods idBIGINT reader_idBIGINT period_startDATE period_endDATE articles_viewedINTEGER allowanceINTEGER last_viewed_atTIMESTAMPTZ meter_views meter_period_idBIGINT article_idBIGINT first_viewed_atTIMESTAMPTZ unlocked_byVARCHAR gift_links idBIGINT article_idBIGINT minted_byBIGINT tokenVARCHAR max_redemptionsINTEGER redemptions_usedINTEGER expires_atTIMESTAMPTZ revoked_atTIMESTAMPTZ created_atTIMESTAMPTZ newsletters idBIGINT codeVARCHAR nameVARCHAR descriptionVARCHAR cadenceVARCHAR subscriber_onlyBOOLEAN activeBOOLEAN newsletter_signups newsletter_idBIGINT reader_idBIGINT statusVARCHAR sourceVARCHAR subscribed_atTIMESTAMPTZ unsubscribed_atTIMESTAMPTZ newsletter_sends idBIGINT newsletter_idBIGINT subjectVARCHAR lead_article_idBIGINT scheduled_forTIMESTAMPTZ sent_atTIMESTAMPTZ recipient_countINTEGER open_countINTEGER click_countINTEGER comments idBIGINT article_idBIGINT reader_idBIGINT parent_idBIGINT bodyTEXT statusVARCHAR moderated_byBIGINT moderation_reasonVARCHAR flag_countINTEGER created_atTIMESTAMPTZ

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
Media & content

Twitch live streaming database schema

How a live streaming platform models its data: broadcast sessions with start and end times, VODs and clips derived from them, tiered and gifted subscriptions, bits, chat, moderation logs and raids.

PostgreSQL
Media & content

YouTube video platform database schema

How a video platform models its data: channels and uploads, encoded renditions, view counts rolled up per day, likes, one-level comment threads, subscriptions, playlists, monetisation and community posts.

MySQL
Media & content

Goodreads book cataloguing database schema

How a book cataloguing site models its data: works split from editions and ISBNs, contributors with roles, default and custom shelves, reading progress, ratings and reviews, series ordering and a friend activity feed.