Artists table - Revision history

Drakinite: Added asterisks for non IUNICODE fields

2024-04-11T16:20:55Z

Added asterisks for non IUNICODE fields

← Older revision		Revision as of 16:20, 11 April 2024
Line 1:		Line 1:
	{{DatabaseTablesList}}		{{DatabaseTablesList}}

	== Fields ==		== Fields ==
	{\| border="1"		{\| border="1"
Line 51:		Line 50:
	\|-		\|-
	\| '''PictureDataHash'''		\| '''PictureDataHash'''
	\| TEXT		\| TEXT*
	\| FVGQBM43GJ83JVRZ		\| FVGQBM43GJ83JVRZ
	\| First 16 digits of a MD5 hash of the cover image saved for this "Person".		\| First 16 digits of a MD5 hash of the cover image saved for this "Person".
Line 57:		Line 56:
	\|-		\|-
	\| '''MBGID'''		\| '''MBGID'''
	\| TEXT		\| TEXT*
	\| 012151a8-0f9a-44c9-997f-ebd68b5389f9		\| 012151a8-0f9a-44c9-997f-ebd68b5389f9
	\| ID of the matching artist on MusicBrainz.		\| ID of the matching artist on MusicBrainz.

Drakinite at 15:47, 11 April 2024

2024-04-11T15:47:58Z

← Older revision		Revision as of 15:47, 11 April 2024
Line 1:		Line 1:
			{{DatabaseTablesList}}

	== Fields ==		== Fields ==
	{\| border="1"		{\| border="1"

Drakinite at 18:22, 10 April 2024

2024-04-10T18:22:13Z

← Older revision		Revision as of 18:22, 10 April 2024
Line 2:		Line 2:
	{\| border="1"		{\| border="1"
	\|-		\|-
	! ~~'''~~Name~~'''~~		! Name
	! ~~'''~~Value Type~~'''~~		! Value Type
	! ~~'''~~Possible Values~~'''~~		! Possible Values
	! ~~'''~~Description~~'''~~		! Description
	\|-		\|-
	\| '''ID'''		\| '''ID'''

Drakinite: Updated formatting

2024-04-10T18:21:00Z

Updated formatting

← Older revision		Revision as of 18:21, 10 April 2024
Line 2:		Line 2:
	{\| border="1"		{\| border="1"
	\|-		\|-
	! Name		! '''Name'''
	! Value Type		! '''Value Type'''
	! Possible Values		! '''Possible Values'''
	! Description		! '''Description'''
	\|-		\|-
	\| '''ID'''		\| '''ID'''
Line 12:		Line 12:
	\|		\|
	\|-		\|-
	\| Artist		\| '''Artist'''
	\| TEXT		\| TEXT
	\| Imagine Dragons		\| Imagine Dragons
	\| Name of the "Person". (This field should be named Person.)		\| Name of the "Person". (This field should be named Person.)
	\|-		\|-
	\| ''Comment''		\| '''Comment'''
	\| TEXT		\| TEXT
	\|		\|
Line 23:		Line 23:
	MediaMonkey 5.0 and later may automatically populate this field from a web search.		MediaMonkey 5.0 and later may automatically populate this field from a web search.
	\|-		\|-
	\| Tracks		\| '''Tracks'''
	\| INTEGER		\| INTEGER
	\|		\|
	\| Count of tracks where the "Person" appears as Artist.		\| Count of tracks where the "Person" appears as Artist.
	\|-		\|-
	\| Albums		\| '''Albums'''
	\| INTEGER		\| INTEGER
	\|		\|
	\| Count of tracks where the "Person" appears as AlbumArtist.		\| Count of tracks where the "Person" appears as AlbumArtist.
	\|-		\|-
	\| Authors		\| '''Authors'''
	\| INTEGER		\| INTEGER
	\|		\|
	\| Count of tracks where the "Person" appears as Composer.		\| Count of tracks where the "Person" appears as Composer.
	\|-		\|-
	\| Conducts		\| '''Conducts'''
	\| INTEGER		\| INTEGER
	\|		\|
	\| Count of tracks where the "Person" appears as Conductor.		\| Count of tracks where the "Person" appears as Conductor.
	\|-		\|-
	\| Lyrics		\| '''Lyrics'''
	\| INTEGER		\| INTEGER
	\|		\|
	\| Count of tracks where the "Person" appears as Lyricist.		\| Count of tracks where the "Person" appears as Lyricist.
	\|-		\|-
	\| ''PictureDataHash''		\| '''PictureDataHash'''
	\| TEXT		\| TEXT
	\| FVGQBM43GJ83JVRZ		\| FVGQBM43GJ83JVRZ
Line 54:		Line 54:
	Added in version 5.0		Added in version 5.0
	\|-		\|-
	\| MBGID		\| '''MBGID'''
	\| TEXT		\| TEXT
	\| 012151a8-0f9a-44c9-997f-ebd68b5389f9		\| 012151a8-0f9a-44c9-997f-ebd68b5389f9
Line 60:		Line 60:
	Added in version 5.0		Added in version 5.0
	\|-		\|-
	\| LastTimeShown		\| '''LastTimeShown'''
	\| REAL		\| REAL
	\| 45173.1271521528		\| 45173.1271521528

Drakinite: Added changes from 5.0

2024-04-10T17:55:00Z

Added changes from 5.0

← Older revision		Revision as of 17:55, 10 April 2024
Line 14:		Line 14:
	\| Artist		\| Artist
	\| TEXT		\| TEXT
	\|		\| Imagine Dragons
	\| Name of the "Person". (This field should be named Person.)		\| Name of the "Person". (This field should be named Person.)
	\|-		\|-
	\| ''Comment''		\| ''Comment''
	\| TEXT		\| TEXT
	\|		\|
	\|		\| Description of the artist.
			MediaMonkey 5.0 and later may automatically populate this field from a web search.
	\|-		\|-
	\| Tracks		\| Tracks
Line 46:		Line 47:
	\|		\|
	\| Count of tracks where the "Person" appears as Lyricist.		\| Count of tracks where the "Person" appears as Lyricist.
			\|-
			\| ''PictureDataHash''
			\| TEXT
			\| FVGQBM43GJ83JVRZ
			\| First 16 digits of a MD5 hash of the cover image saved for this "Person".
			Added in version 5.0
			\|-
			\| MBGID
			\| TEXT
			\| 012151a8-0f9a-44c9-997f-ebd68b5389f9
			\| ID of the matching artist on MusicBrainz.
			Added in version 5.0
			\|-
			\| LastTimeShown
			\| REAL
			\| 45173.1271521528
			\| Last time the artist was displayed in the UI. Formatted as the number of days since December 30, 1899.
			Added in version 5.0
	\|}		\|}

Bex: /* Fields */

2008-01-23T21:28:34Z

Fields

← Older revision		Revision as of 21:28, 23 January 2008
Line 25:		Line 25:
	\| INTEGER		\| INTEGER
	\|		\|
	\| ~~Number~~ of tracks where the "Person" appears as Artist.		\| Count of tracks where the "Person" appears as Artist.
	\|-		\|-
	\| Albums		\| Albums
	\| INTEGER		\| INTEGER
	\|		\|
	\| ~~Number~~ of tracks where the "Person" appears as AlbumArtist.		\| Count of tracks where the "Person" appears as AlbumArtist.
	\|-		\|-
	\| Authors		\| Authors
	\| INTEGER		\| INTEGER
	\|		\|
	\| ~~Number~~ of tracks where the "Person" appears as Composer.		\| Count of tracks where the "Person" appears as Composer.
	\|-		\|-
	\| Conducts		\| Conducts
	\| INTEGER		\| INTEGER
	\|		\|
	\| ~~Number~~ of tracks where the "Person" appears as Conductor.		\| Count of tracks where the "Person" appears as Conductor.
	\|-		\|-
	\| Lyrics		\| Lyrics
	\| INTEGER		\| INTEGER
	\|		\|
	\| ~~Number~~ of tracks where the "Person" appears as Lyricist.		\| Count of tracks where the "Person" appears as Lyricist.
	\|}		\|}

Bex at 21:10, 23 January 2008

2008-01-23T21:10:37Z

New page

== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
|
|-
| Artist
| TEXT
|
| Name of the "Person". (This field should be named Person.)
|-
| ''Comment''
| TEXT
|
|
|-
| Tracks
| INTEGER
|
| Number of tracks where the "Person" appears as Artist.
|-
| Albums
| INTEGER
|
| Number of tracks where the "Person" appears as AlbumArtist.
|-
| Authors
| INTEGER
|
| Number of tracks where the "Person" appears as Composer.
|-
| Conducts
| INTEGER
|
| Number of tracks where the "Person" appears as Conductor.
|-
| Lyrics
| INTEGER
|
| Number of tracks where the "Person" appears as Lyricist.
|}