ArtistsSongs table - Revision history

Drakinite: Formatting

2024-04-11T16:20:01Z

Formatting

← Older revision		Revision as of 16:20, 11 April 2024
Line 13:		Line 13:
	\|		\|
	\|-		\|-
	\| PersonType		\| '''PersonType'''
	\| INTEGER		\| INTEGER
	\| 1=Artist or AlbumArtist, 3=Composer, 4=Conductor, 5=Lyricist, 6=Producer, 7=Actor, 8 = Publisher		\| 1=Artist or AlbumArtist, 3=Composer, 4=Conductor, 5=Lyricist, 6=Producer, 7=Actor, 8 = Publisher
	\| Specifies the PersonType relation between the Song and the "Artist"		\| Specifies the PersonType relation between the Song and the "Artist"
	\|-		\|-
	\| IDArtist		\| '''IDArtist'''
	\| INTEGER		\| INTEGER
	\|		\|
	\| ID of the "Artist". (ID of the "Artist" in the Artists table.)		\| ID of the "Artist". (ID of the "Artist" in the Artists table.)
	\|-		\|-
	\| 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.)
	\|}		\|}

Drakinite: {{DatabaseTablesList}}

2024-04-11T15:50:15Z

← Older revision		Revision as of 15:50, 11 April 2024
Line 1:		Line 1:
			{{DatabaseTablesList}}
	== Fields ==		== Fields ==
	{\| border="1"		{\| border="1"

Hvaleton: /* Fields */

2020-06-09T19:22:36Z

Fields

← Older revision		Revision as of 19:22, 9 June 2020
Line 14:		Line 14:
	\| PersonType		\| PersonType
	\| INTEGER		\| INTEGER
	\| 1=Artist or AlbumArtist, 3=Composer, 4=Conductor, 5=Lyricist, 6=Producer, 8 = Publisher		\| 1=Artist or AlbumArtist, 3=Composer, 4=Conductor, 5=Lyricist, 6=Producer, 7=Actor, 8 = Publisher
	\| Specifies the PersonType relation between the Song and the "Artist"		\| Specifies the PersonType relation between the Song and the "Artist"
	\|-		\|-

Hvaleton: /* Fields */

2020-06-09T19:18:58Z

Fields

← Older revision		Revision as of 19:18, 9 June 2020
Line 14:		Line 14:
	\| PersonType		\| PersonType
	\| INTEGER		\| INTEGER
	\| 1=Artist or AlbumArtist, 3=Composer, 4=Conductor, 5=Lyricist, 8 = Publisher		\| 1=Artist or AlbumArtist, 3=Composer, 4=Conductor, 5=Lyricist, 6=Producer, 8 = Publisher
	\| Specifies the PersonType relation between the Song and the "Artist"		\| Specifies the PersonType relation between the Song and the "Artist"
	\|-		\|-

Hvaleton at 19:14, 9 June 2020

2020-06-09T19:14:51Z

← Older revision		Revision as of 19:14, 9 June 2020
Line 14:		Line 14:
	\| PersonType		\| PersonType
	\| INTEGER		\| INTEGER
	\| 1=Artist or AlbumArtist, 3=Composer, 4=Conductor, 5=Lyricist		\| 1=Artist or AlbumArtist, 3=Composer, 4=Conductor, 5=Lyricist, 8 = Publisher
	\| Specifies the PersonType relation between the Song and the "Artist"		\| Specifies the PersonType relation between the Song and the "Artist"
	\|-		\|-

Bex at 21:46, 23 January 2008

2008-01-23T21:46:20Z

New page

== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
|
|-
| PersonType
| INTEGER
| 1=Artist or AlbumArtist, 3=Composer, 4=Conductor, 5=Lyricist
| Specifies the PersonType relation between the Song and the "Artist"
|-
| IDArtist
| INTEGER
|
| ID of the "Artist". (ID of the "Artist" in the Artists table.)
|-
| IDSong
| INTEGER
|
| ID of the Song. (ID of the Song in the Songs table.)
|}