PlaylistSongs table

From MediaMonkey Wiki
Revision as of 19:24, 31 May 2011 by Alfonse (talk | contribs) (Adding information on how this is stored.)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

The PlaylistSongs table can be used for retrieving song IDs from a given playlist. Every song in every playlist resides in this table.


Name Value Type Possible Values Description
IDSong 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.
IDPlaylistSong 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.

(4 fields total, but need more info in each)