1 system_tracks
Anna Schumaker edited this page 2023-05-10 14:58:06 -04:00

The system_tracks table is used to link tracks to their associated playlist_properties. This is needed because a track could have multiple artists and genres.

Columns

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

The system_tracks_view

The system_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