Media & content database schemas
Catalogues, playback and publishing. Content is versioned, rights and availability are time-boxed, and what someone watched or listened to is an append-only log rather than a counter. Every one opens in the free drawDB editor in a click, and is public domain.
8 schemas here, from 10 to 15 tables (97 tables and 720 columns in total), written for PostgreSQL, MySQL, SQLite. Each one ships an ER diagram you can open and edit, a column-by-column reference, design notes explaining the trade-offs, and SQL for all six dialects. Recurring themes across the set: catalog, subscriptions, publishing, comments, streaming.
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.
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.
Netflix video streaming database schema
How a video streaming service models its data: films and series in one titles table, seasons and episodes, profiles inside an account, resume positions, per-region licensing windows, My List, ratings and subtitle tracks.
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.
Local-first podcast app database schema (SQLite)
How a podcast client stores its data on the device: subscribed shows, episodes mirrored from RSS feeds, playback positions, download state, an ordered queue, per-show settings, feed sync cursors and an offline outbox.
Spotify music streaming database schema
How a music streaming service models its data: artists, albums and tracks, credited roles on a track, ordered playlists with collaborators, saved library, offline downloads and an append-only play log.
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.
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.