PlaylistSongs table - Revision history

Jiri at 07:59, 19 March 2026

2026-03-19T07:59:58Z

← Older revision		Revision as of 07:59, 19 March 2026
Line 10:		Line 10:
	! Description		! Description
	\|-		\|-
	\| '''~~IDSong~~'''		\| '''IDPlaylistSong'''
	\| INTEGER		\| INTEGER
	\| Primary Key		\| Primary Key
Line 20:		Line 20:
	\| The playlist that this entry's song resides in.		\| The playlist that this entry's song resides in.
	\|-		\|-
	\| '''~~IDPlaylistSong~~'''		\| '''IDSong'''
	\| INTEGER		\| INTEGER
	\| Primary key from the [[Songs table\|Songs]] table.		\| Primary key from the [[Songs table\|Songs]] table.

Drakinite: {{DatabaseTablesList}} and removed "need more info" since there's a description for each field

2024-04-11T16:02:40Z

{{DatabaseTablesList}} and removed "need more info" since there's a description for each field

← Older revision		Revision as of 16:02, 11 April 2024
Line 30:		Line 30:
	\| Entries in a database are unordered, so the playlist order must be made explicit. All numbers must be filled in, starting with zero.		\| 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)~~

Drakinite: {{DatabaseTablesList}}

2024-04-11T16:01:42Z

← Older revision		Revision as of 16:01, 11 April 2024
Line 1:		Line 1:
			{{DatabaseTablesList}}
	The PlaylistSongs table can be used for retrieving song IDs from a given playlist. Every song in every playlist resides in this table.		The PlaylistSongs table can be used for retrieving song IDs from a given playlist. Every song in every playlist resides in this table.

Alfonse: Adding information on how this is stored.

2011-05-31T19:24:11Z

Adding information on how this is stored.

← Older revision		Revision as of 19:24, 31 May 2011
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)

Twinbee: Added remaining two fields

2009-06-19T13:53:43Z

Added remaining two fields

← Older revision		Revision as of 13:53, 19 June 2009
Line 9:		Line 9:
	! Description		! Description
	\|-		\|-
	\| '''~~IdSong~~'''		\| '''IDSong'''
	\| INTEGER		\| INTEGER
	\|		\|
	\|		\| Internal MM ID number
	\|-		\|-
	\| '''IDPlaylist'''		\| '''IDPlaylist'''
Line 18:		Line 18:
	\|		\|
	\| Assigned Playlist Number		\| Assigned Playlist Number
			\|-
			\| '''IDPlaylistSong'''
			\| INTEGER
			\|
			\|
			\|-
			\| '''SongOrder'''
			\| INTEGER
			\|
			\|
	\|}		\|}

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

Twinbee: Just a stub, but a useful one.

2009-06-19T13:27:07Z

Just a stub, but a useful one.

New page

The PlaylistSongs table can be used for retrieving song IDs from a given playlist.

== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''IdSong'''
| INTEGER
|
|
|-
| '''IDPlaylist'''
| INTEGER
|
| Assigned Playlist Number
|}

(incomplete?)