Difference between revisions of "PlaylistSongs table"

From MediaMonkey Wiki
Jump to: navigation, search
(Just a stub, but a useful one.)
 
(Adding information on how this is stored.)
 
(One intermediate revision by one other user not shown)
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 9: Line 9:
 
! Description
 
! Description
 
|-
 
|-
| '''IdSong'''
+
| '''IDSong'''
 
| INTEGER
 
| INTEGER
|  
+
| Primary Key
|  
+
| 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'''
 +
| INTEGER
 +
| Primary key from the [[Songs table|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.
 
|}
 
|}
  
(incomplete?)
+
(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)