Difference between revisions of "PlaylistSongs table"

From MediaMonkey Wiki
Jump to: navigation, search
(Added remaining two fields)
(Adding information on how this is stored.)
 
Line 1: Line 1:
The PlaylistSongs table can be used for retrieving song IDs from a given playlist.
+
The PlaylistSongs table can be used for retrieving song IDs from a given playlist. Every song in every playlist resides in this table.
  
 
== Fields ==
 
== Fields ==
Line 11: Line 11:
 
| '''IDSong'''
 
| '''IDSong'''
 
| INTEGER
 
| INTEGER
|  
+
| Primary Key
| Internal MM ID number
+
| Each playlist entry has a unique identifier
 
|-
 
|-
 
| '''IDPlaylist'''
 
| '''IDPlaylist'''
 
| INTEGER
 
| INTEGER
|  
+
| Primary key from the [[Playlists table|Playlists]] table.
| Assigned Playlist Number
+
| The playlist that this entry's song resides in.
 
|-
 
|-
 
| '''IDPlaylistSong'''
 
| '''IDPlaylistSong'''
 
| INTEGER
 
| INTEGER
|  
+
| Primary key from the [[Songs table|Songs]] table.
|  
+
| The song to be used for this entry in the given playlist.
 
|-
 
|-
 
| '''SongOrder'''
 
| '''SongOrder'''
 
| INTEGER
 
| 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)
 
(4 fields total, but need more info in each)

Latest revision as of 19:24, 31 May 2011

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
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)