PlaylistSongs table: Difference between revisions
Jump to navigation
Jump to 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 | ||
| | | Each playlist entry has a unique identifier | ||
|- | |- | ||
| '''IDPlaylist''' | | '''IDPlaylist''' | ||
| INTEGER | | INTEGER | ||
| | | Primary key from the [[Playlists table|Playlists]] table. | ||
| | | 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) | ||
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)
