User:Karellen/scratchpad01: Difference between revisions

From Official Kodi Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
==== album ====
==== 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).
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).


{|class="prettytable"
{|class="prettytable"
! Database Field || Data Type || Description || Music File Tag || Scraper Tag || NFO Tag  
! Database Field || Data Type || Description || Music File Tag || Scraper Tag || NFO Tag || Additional Info
|-
|-
|idAlbum || integer || Primary Key || n/a || n/a || n/a
|idAlbum || integer || Primary Key || n/a
|-
|-
|strAlbum || varchar(256) || Album title || Yes || No || <albumtitle></albumtitle>
|strAlbum || varchar(256) || Album title || Yes || No || <albumtitle></albumtitle> ||
|-
|-
|strMusicBrainzAlbumID || text || MusicBrainz Album ID (release ID)  || Yes || No || <musicBrainzAlbumID></musicBrainzAlbumID>
|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 ||  
|strArtists || text || album artist(s) description (not always a concatenation of names)    || Yes || No ||  
Line 16: Line 15:
     <artist></artist>
     <artist></artist>
     <musicBrainzArtistID></musicBrainzArtistID>
     <musicBrainzArtistID></musicBrainzArtistID>
  </albumArtistCredits>
  </albumArtistCredits>  
|| 2 level tags required
|-
|-
|strGenres || text || Album genres (denormalised concatenation of values in genre table) || Yes || No ||  <genre></genre> *Multiple entries allowed
|strGenres || text || Album genres (denormalised concatenation of values in genre table) || Yes || No ||  <genre></genre> || Multiple entries in nfo allowed
|-
|-
|iYear || integer || Album release year || Yes || No || <year></year>
|iYear || integer || Album release year || Yes || No || <year></year> ||
|-
|-
|idThumb || integer || [Unused] || || ||  
|idThumb || integer || [Unused] || || || ||
|-
|-
|bCompilation || integer || Compilation flag || || ||
|bCompilation || integer || Compilation flag || || || ||
|-
|-
|strMoods || text || Album moods || No || Yes || <mood></mood>
|strMoods || text || Album moods || No || Yes || <mood></mood> ||
|-
|-
|strStyles || text || Album styles || || ||
|strStyles || text || Album styles || || || ||
|-
|-
|strThemes || text || Album themes || No || Yes || <theme></theme> *Multiple entries allowed
|strThemes || text || Album themes || No || Yes || <theme></theme> || *Multiple entries in nfo allowed
|-
|-
|strReview || text || Album review || No || Yes || <review></review>
|strReview || text || Album review || No || Yes || <review></review> ||
|-
|-
|strImage || text || URLs for available remote album images || || ||
|strImage || text || URLs for available remote album images || || || ||
|-
|-
|strLabel || text || Album recording label || Yes || No || <label></label>
|strLabel || text || Album recording label || Yes || No || <label></label> ||
|-
|-
|strType || text || Album Type e.g. "Soundtrack / Live"  
|strType || text || Album Type e.g. "Soundtrack / Live" || || || ||
|-
|-
|fRating || float || Album rating || No || Yes || <rating max="10"></rating> ** What does max="10" mean?
|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>
|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 || || ||
|lastScraped || text || Date/time data scraped from online sources or NFO files || n/a
|-
|-
|strReleaseType || text || Internal type - "album" or "single" || No || Yes || <releasetype></releasetype>
|strReleaseType || text || Internal type - "album" or "single" || No || Yes || <releasetype></releasetype> ||
|-
|-
|iVotes || integer || Album votes (for rating) || No || Yes || <votes></votes>
|iVotes || integer || Album votes (for rating) || No || Yes || <votes></votes> ||
|}
|}

Revision as of 07:33, 28 August 2017

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 Additional Info
idAlbum integer Primary Key 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>
2 level tags required
strGenres text Album genres (denormalised concatenation of values in genre table) Yes No <genre></genre> Multiple entries in nfo 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 in nfo 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 n/a
strReleaseType text Internal type - "album" or "single" No Yes <releasetype></releasetype>
iVotes integer Album votes (for rating) No Yes <votes></votes>
Retrieved from "https://kodi.wiki/index.php?title=User:Karellen/scratchpad01&oldid=130544"