Table of Contents

Database Design

Playlists
Tracks
Other

Welcome to the Emmental Wiki, which is written to document the v3.x releases.

Database Design

Emmental 3 uses a SQLite database to store its settings, playlist, and track information. The SQLite configuration we use is documented here.

Playlists

albums: Holds information about each album
album_artist_link: Links albums to artists
artists: Holds information about each artist
decades: Holds information about decades
genres: Holds information about each genre
libraries: Holds information about each library path
media: Holds information about each medium in an album
playlist_properties: Holds properties that all playlists have
playlists: Holds user and system playlist information
years: Holds information about years

Tracks

saved_track_data: Preserves playback statistics when tracks are deleted
system_tracks: Links tracks to system-managed playlists
tracks: Holds information about each track
user_tracks: Links tracks to user-managed playlists

Other

settings: Holds user settings
listenbrainz_queue: Holds played but unsubmitted tracks