🎬 Media & Entertainment · Database ERD
Media Content Catalog Schema
A database schema for an OTT catalog: titles, seasons, episodes, people, genres, media assets and regional availability.
Drawing diagram…
What this diagram shows
- Series have seasons and episodes; films are single titles
- Each playable item has several encoded media assets
- Availability windows differ by country
Prompt used
ERD for an OTT content catalog: Title (film or series) has Genres and CastCredits linking People with roles; Series titles have Seasons with Episodes; each Episode or film has MediaAssets (encodings, subtitles, audio languages); Availability records country and licence window for each title.
Mermaid code
erDiagram
TITLE ||--o{ SEASON : has
SEASON ||--|{ EPISODE : contains
TITLE ||--o{ TITLE_GENRE : tagged
GENRE ||--o{ TITLE_GENRE : groups
TITLE ||--o{ CAST_CREDIT : features
PERSON ||--o{ CAST_CREDIT : "credited in"
EPISODE ||--o{ MEDIA_ASSET : "encoded as"
TITLE ||--o{ AVAILABILITY : "licensed in"
TITLE {
int id PK
string name
string type
int release_year
}
EPISODE {
int id PK
int season_id FK
int number
int duration_min
}
MEDIA_ASSET {
int id PK
int episode_id FK
string kind
string language
}
AVAILABILITY {
int title_id FK
string country
date window_start
date window_end
}Related templates
OTT Video Streaming Platform
An OTT streaming service like a Netflix-style app: user apps, catalog and entitlement services, DRM, and delivery through a CDN.
Video Transcoding Pipeline
How an uploaded master video becomes adaptive streams: ingest, quality checks, transcoding into several resolutions, packaging, DRM and publishing.
Content Publishing Workflow
How an article or video moves through a newsroom or media house: drafting, editing, legal review, scheduling and publishing across channels.
Subscription Paywall Sequence
How a metered paywall works on a news or streaming site: free article count, the paywall, subscription purchase and entitlement.
Live Event Streaming Deployment
How a live sports or concert stream reaches millions: venue encoders, cloud ingest and transcoding, packaging, and multi-CDN delivery.
Podcast Publishing Workflow
From recording to publishing a podcast episode: editing, show notes, review, and distribution to every podcast app.