Spotify

Comprehensive database schema for a Spotify-like music streaming platform covering artist profiles, album releases, track catalog with audio features, user-curated and editorial playlists, social following, listening history, liked songs, podcast integration, device management, and listening queue.

PostgreSQL18 tablesWeb App
musicstreamingplaylistpodcastsocial
Created with ERD Studio

Tables in this template

usersUsers
9 cols
artistsArtists
9 cols
artist_membersArtist Members
5 cols
genresGenres
4 cols
albumsAlbums
10 cols
tracksTracks
11 cols
album_tracksAlbum Tracks
6 cols
track_genresTrack Genres
4 cols
track_featuresTrack Features
12 cols
playlistsPlaylists
11 cols
playlist_tracksPlaylist Tracks
6 cols
liked_songsLiked Songs
4 cols
listening_historyListening History
7 cols
follows_artistsFollows Artists
4 cols
follows_playlistsFollows Playlists
4 cols
podcastsPodcasts
9 cols
podcast_episodesPodcast Episodes
9 cols
devicesDevices
8 cols

Related Templates

View all templates
Spotify Database Schema - ERD Template