anna/emmental
anna
/
emmental
1
0
Fork 0
Code Issues 11 Pull Requests Projects 1 Releases 12 Wiki Activity
Page: user_tracks
Pages
Home SQLite Config album_artist_link albums artists decades genres libraries listenbrainz_queue media playlist_properties playlists saved_track_data settings system_tracks tracks user_tracks years
1 user_tracks
Anna Schumaker edited this page 2023-05-10 15:55:33 -04:00
Table of Contents

The user_tracks table is used to link tracks to their associated playlist_properties. This table is similar to the system_tracks table, except it adds a position column so users can manually arrange tracks.

Columns

Name Type Description
trackid INTEGER The trackid of one of the playlist's tracks
propertyid INTEGER The propertyid of the playlist
position INTEGER The position of the track in the playlist

The user_tracks_view

The user_tracks_view is intended to be used by playlists when they load their trackids, and automatically filters out tracks that are in the process of being deleted.

Column Description
trackid The trackid of the track
propertyid The propertyid of the playlist
position The position of the track in the playlist