User:Karellen/scratchpad01
Jump to navigation
Jump to search
album
An album. This equates to what Musicbrainz call a "release" and represents the unique release (i.e. issuing) of an item on a specific date with specific release information such as the country, label, etc. Hence album title and artist do not have to be unique as long as we have the release ID (Musicbrainz album ID), Kodi can handle different versions of the same album e.g. original release and then a later remaster (both same title and artist).
| Database Field | Data Type | Description | Music File Tag | Scraper Tag | NFO Tag |
|---|---|---|---|---|---|
| idAlbum | integer | Primary Key | n/a | n/a | n/a |
| strAlbum | varchar(256) | Album title | Yes | No | <albumtitle></albumtitle> |
| strMusicBrainzAlbumID | text | MusicBrainz Album ID (release ID) | Yes | No | <musicBrainzAlbumID></musicBrainzAlbumID> |
| strArtists | text | album artist(s) description (not always a concatenation of names) | Yes | No |
<albumArtistCredits> <artist></artist> <musicBrainzArtistID></musicBrainzArtistID> </albumArtistCredits> |
| strGenres | text | Album genres (denormalised concatenation of values in genre table) | Yes | No | <genre></genre> *Multiple entries allowed |
| iYear | integer | Album release year | Yes | No | <year></year> |
| idThumb | integer | [Unused] | |||
| bCompilation | integer | Compilation flag | |||
| strMoods | text | Album moods | No | Yes | <mood></mood> |
| strStyles | text | Album styles | |||
| strThemes | text | Album themes | No | Yes | <theme></theme> *Multiple entries allowed |
| strReview | text | Album review | No | Yes | <review></review> |
| strImage | text | URLs for available remote album images | |||
| strLabel | text | Album recording label | Yes | No | <label></label> |
| strType | text | Album Type e.g. "Soundtrack / Live" | |||
| fRating | float | Album rating | No | Yes | <rating max="10"></rating> ** What does max="10" mean? |
| iUserrating | integer | Album user rating (out of 10) | No | Yes | <userrating max="10">10</userrating> |
| lastScraped | text | Date/time data scraped from online sources or NFO files | |||
| strReleaseType | text | Internal type - "album" or "single" | No | Yes | <releasetype></releasetype> |
| iVotes | integer | Album votes (for rating) | No | Yes | <votes></votes> |