ListsSongs table - Revision history

Drakinite: {{DatabaseTablesList}} and formatting

2024-04-11T15:59:07Z

{{DatabaseTablesList}} and formatting

← Older revision		Revision as of 15:59, 11 April 2024
Line 1:		Line 1:
			{{DatabaseTablesList}}
	== Fields ==		== Fields ==
	{\| border="1"		{\| border="1"
Line 12:		Line 13:
	\|		\|
	\|-		\|-
	\| IDSong		\| '''IDSong'''
	\| INTEGER		\| INTEGER
	\|		\|
	\| ID of the Song. (ID of the Song in the Songs table.)		\| ID of the Song. (ID of the Song in the Songs table.)
	\|-		\|-
	\| IDListType		\| '''IDListType'''
	\| INTEGER		\| INTEGER
	\| 1=Tempo, 2=Mood, 3=Occasion, 4=Quality		\| 1=Tempo, 2=Mood, 3=Occasion, 4=Quality
	\| ID of the ListType. (IDListType in the Lists table.)		\| ID of the ListType. (IDListType in the Lists table.)
	\|-		\|-
	\| IDList		\| '''IDList'''
	\| INTEGER		\| INTEGER
	\|		\|
	\| ID of the List. (ID of the List in the Lists table.)		\| ID of the List. (ID of the List in the Lists table.)
	\|}		\|}

Bex: /* Fields */

2008-01-26T22:26:58Z

Fields

← Older revision		Revision as of 22:26, 26 January 2008
Line 14:		Line 14:
	\| IDSong		\| IDSong
	\| INTEGER		\| INTEGER
	\| ~~1=Artist or AlbumArtist, 3=Composer, 4=Conductor, 5=Lyricist~~		\|
	\| ID of the Song. (ID of the Song in the Songs table.)		\| ID of the Song. (ID of the Song in the Songs table.)
	\|-		\|-

Bex at 23:13, 23 January 2008

2008-01-23T23:13:26Z

New page

== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
|
|-
| IDSong
| INTEGER
| 1=Artist or AlbumArtist, 3=Composer, 4=Conductor, 5=Lyricist
| ID of the Song. (ID of the Song in the Songs table.)
|-
| IDListType
| INTEGER
| 1=Tempo, 2=Mood, 3=Occasion, 4=Quality
| ID of the ListType. (IDListType in the Lists table.)
|-
| IDList
| INTEGER
|
| ID of the List. (ID of the List in the Lists table.)
|}