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 |