User:Karellen/scratchpad01
Jump to navigation
Jump to search
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 |