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)