Streaming Service

Overview

Media streaming platform schema inspired by Netflix and Spotify. Models content catalogs, multi-profile accounts, personalized recommendations, offline downloads, and subscription management.

Key Design Decisions

• Multi-profile Accounts: Multiple viewer profiles per subscription with independent watch history
• Content Hierarchy: Series → seasons → episodes with standalone movies
• Continue Watching: Resume position tracking for interrupted playback
• Recommendation Engine: Collaborative and content-based recommendation inputs

Tables

12-15 tables covering content, genres, content-genre mappings, seasons, episodes, user profiles, watch history, playlists, playlist items, subscriptions, subscription plans, recommendations, and downloads.