User:Karellen/scratchpad01: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
==== albumartistview ==== | |||
This table combines album with each album artist. | |||
{|class="prettytable" | |||
! Column Name || Data Type || Description || Music File Tag || Scraper || NFO | |||
|- | |||
|idAlbum || integer || ID from album table || n/a || n/a || n/a | |||
== | |- | ||
|idArtist || integer || ID from artist table || n/a || n/a || n/a | |||
|- | |||
|idrole || integer || = 0 (fake role ID field) || n/a || n/a || n/a | |||
|- | |||
|strRole || text || = "AlbumArtist" (fake role desc field) || n/a || n/a || n/a | |||
== | |- | ||
|strArtist || varchar(256) || Artist name || Yes || No || No | |||
|- | |||
|strMusicBrainzArtistID || text || Musicbrainz artist ID || Yes || No || No | |||
|- | |||
|iOrder || integer || Order artist appears in credits || n/a || n/a || n/a | |||
|} | |||
= | |||
= | |||
Revision as of 05:45, 28 August 2017
albumartistview
This table combines album with each album artist.
Column Name | Data Type | Description | Music File Tag | Scraper | NFO |
---|---|---|---|---|---|
idAlbum | integer | ID from album table | n/a | n/a | n/a |
idArtist | integer | ID from artist table | n/a | n/a | n/a |
idrole | integer | = 0 (fake role ID field) | n/a | n/a | n/a |
strRole | text | = "AlbumArtist" (fake role desc field) | n/a | n/a | n/a |
strArtist | varchar(256) | Artist name | Yes | No | No |
strMusicBrainzArtistID | text | Musicbrainz artist ID | Yes | No | No |
iOrder | integer | Order artist appears in credits | n/a | n/a | n/a |