PlaylistSongs table: Difference between revisions
Jump to navigation
Jump to search
(Adding information on how this is stored.) |
No edit summary |
||
| (2 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
{{DatabaseTablesList}} | |||
The PlaylistSongs table can be used for retrieving song IDs from a given playlist. Every song in every playlist resides in this table. | The PlaylistSongs table can be used for retrieving song IDs from a given playlist. Every song in every playlist resides in this table. | ||
| Line 9: | Line 10: | ||
! Description | ! Description | ||
|- | |- | ||
| ''' | | '''IDPlaylistSong''' | ||
| INTEGER | | INTEGER | ||
| Primary Key | | Primary Key | ||
| Line 19: | Line 20: | ||
| The playlist that this entry's song resides in. | | The playlist that this entry's song resides in. | ||
|- | |- | ||
| ''' | | '''IDSong''' | ||
| INTEGER | | INTEGER | ||
| Primary key from the [[Songs table|Songs]] table. | | Primary key from the [[Songs table|Songs]] table. | ||
| Line 29: | Line 30: | ||
| Entries in a database are unordered, so the playlist order must be made explicit. All numbers must be filled in, starting with zero. | | Entries in a database are unordered, so the playlist order must be made explicit. All numbers must be filled in, starting with zero. | ||
|} | |} | ||
Latest revision as of 07:59, 19 March 2026
- [Database Structure]
- Albums
- Artists
- ArtistsAlbums
- ArtistsSongs
- Covers
- DBInfo
- DeviceFilters
- DeviceTracks
- Devices
- Downloads
- Filters
- Folders
- FoldersHier
- Genres
- GenresSongs
- LastTreePath
- Lists
- ListsSongs
- Medias
- OrganizeRules
- PathProcessing
- Pinned
- Played
- PlaylistSongs
- Playlists
- PodcastDirs
- PodcastEpisodes
- Podcasts
- Radio
- RemoteClients
- Songs
- SynchAlbum
- SynchArtist
- SynchLocation
- SynchPlaylist
- SynchPodcast
- URLRequestCache
The PlaylistSongs table can be used for retrieving song IDs from a given playlist. Every song in every playlist resides in this table.
Fields
| Name | Value Type | Possible Values | Description |
|---|---|---|---|
| IDPlaylistSong | INTEGER | Primary Key | Each playlist entry has a unique identifier |
| IDPlaylist | INTEGER | Primary key from the Playlists table. | The playlist that this entry's song resides in. |
| IDSong | INTEGER | Primary key from the Songs table. | The song to be used for this entry in the given playlist. |
| SongOrder | INTEGER | Zero-based index, ordering the entry in the playlist. | Entries in a database are unordered, so the playlist order must be made explicit. All numbers must be filled in, starting with zero. |
