Databases/MyVideos: Difference between revisions
No edit summary |
|||
(16 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
{{Template:DatabasesNavBox}} | {{Template:DatabasesNavBox}} | ||
{{mininav| [[Development]] {{l2| [[Userdata]]}} | [[Databases]] }} | {{mininav| [[Development]] {{l2| [[Userdata]]}} | [[Databases]] }} | ||
Line 10: | Line 9: | ||
The current stable release of {{kodi}} is using the following version of the database: | The current stable release of {{kodi}} is using the following version of the database: | ||
;Kodi | ;Kodi v20 - MyVideos121.db | ||
Line 21: | Line 20: | ||
== episode_view == | |||
== | |||
A view that joins episode to file and tvshow (through tvshowlinkepisode) and path. | A view that joins episode to file and tvshow (through tvshowlinkepisode) and path. | ||
Line 30: | Line 28: | ||
|idEpisode || integer || Primary Key | |idEpisode || integer || Primary Key | ||
|- | |- | ||
|idFile || integer || Foreign key to the [[Databases#files|files table]] | |idFile || integer || Foreign key to the [[Databases/MyVideos#files|files table]] | ||
|- | |- | ||
|c00 || text || Episode Title | |c00 || text || Episode Title | ||
Line 36: | Line 34: | ||
|c01 || text || Plot Summary | |c01 || text || Plot Summary | ||
|- | |- | ||
|c02 || text || | |c02 || text || Not Used | ||
|- | |- | ||
|c03 || text || Rating | |c03 || text || Link to [[Databases/MyVideos#rating|Rating Table]] | ||
|- | |- | ||
|c04 || text || Writer | |c04 || text || Writer | ||
Line 46: | Line 44: | ||
|c06 || text || Thumbnail URL | |c06 || text || Thumbnail URL | ||
|- | |- | ||
|c07 || text || | |c07 || text || Thumbnail URL Spoof | ||
|- | |- | ||
|c08 || text || | |c08 || text || Not Used | ||
|- | |- | ||
|c09 || text || | |c09 || text || Runtime | ||
|- | |- | ||
|c10 || text || Director | |c10 || text || Director | ||
|- | |- | ||
|c11 || text || | |c11 || text || Production Code | ||
|- | |- | ||
|c12 || | |c12 || varchar(24) || Season Number | ||
|- | |- | ||
|c13 || | |c13 || tvarchar(24)ext || Episode Number | ||
|- | |- | ||
|c14 || text || | |c14 || text || Original Title | ||
|- | |- | ||
|c15 || text || Season formatted for sorting | |c15 || text || Season formatted for sorting | ||
Line 66: | Line 64: | ||
|c16 || text || Episode formatted for sorting | |c16 || text || Episode formatted for sorting | ||
|- | |- | ||
|c17 || | |c17 || varchar(24) || Bookmark | ||
|- | |- | ||
|c18 || text || Path to episode file | |c18 || text || Path to episode file | ||
|- | |- | ||
|c19 || text || | |c19 || text || Link to [[Databases/MyVideos#path|Path Table]] | ||
|- | |- | ||
|c20 || text || | |c20 || text || Link to [[Databases/MyVideos#uniqueid|UniqueID Table]] | ||
|- | |- | ||
|c21 || text || Not used | |c21 || text || Not used | ||
Line 80: | Line 78: | ||
|c23 || text || Not used | |c23 || text || Not used | ||
|- | |- | ||
|idShow || | |idShow || integer || Foreign key to the [[Databases/MyVideos#tvshow|tvshow table]] | ||
|- | |- | ||
|userrating || | |userrating || integer || User Rating | ||
|- | |- | ||
|idSeason || | |idSeason || integer || Foreign key to the [[Databases/MyVideos#seasons|seasons table]] | ||
|- | |- | ||
|strFilename || text || Full name of file including extension | |strFilename || text || Full name of file including extension | ||
Line 109: | Line 107: | ||
|- | |- | ||
|totalTimeInSeconds || double || Length of video | |totalTimeInSeconds || double || Length of video | ||
|- | |||
|playerState || text || | |||
|- | |- | ||
|rating || float || Rating | |rating || float || Rating | ||
Line 116: | Line 116: | ||
|rating_type || text || Type of rating | |rating_type || text || Type of rating | ||
|- | |- | ||
|uniqueid_value || text || | |uniqueid_value || text || Default UniqueID ( default="true" ) | ||
|- | |- | ||
|uniqueid_type || text || | |uniqueid_type || text || Provider of the default UniqueID. eg... <uniqueid type="tmdb" default="true"> | ||
|} | |} | ||
== | == movie_view == | ||
A view that joins movie to file and | A view that joins movie to file, path, videoversion and videoversiontype. One record per movie version. Most values are the same for all versions of a movie. | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 131: | Line 131: | ||
|idMovie || integer || Primary Key | |idMovie || integer || Primary Key | ||
|- | |- | ||
|idFile || integer || Foreign Key to [[Databases#files|files table]] | |idFile || integer || Foreign Key to [[Databases/MyVideos#files|files table]] for the default version of the movie. | ||
|- | |- | ||
|c00 || text || Local Movie Title | |c00 || text || Local Movie Title | ||
Line 141: | Line 141: | ||
|c03 || text || Movie Tagline | |c03 || text || Movie Tagline | ||
|- | |- | ||
|c04 || text || | |c04 || text || Not Used | ||
|- | |- | ||
|c05 || text || Link to [[Databases#rating|Rating Table]] | |c05 || text || Link to [[Databases/MyVideos#rating|Rating Table]] | ||
|- | |- | ||
|c06 || text || Writers | |c06 || text || Writers | ||
|- | |- | ||
|c07 || text || | |c07 || text || Not Used | ||
|- | |- | ||
|c08 || text || Image URL | |c08 || text || Image URL | ||
|- | |- | ||
|c09 || text || | |c09 || text || Link to [[Databases/MyVideos#uniqueid|uniqueid Table]] | ||
|- | |- | ||
|c10 || text || Title formatted for sorting | |c10 || text || Title formatted for sorting | ||
|- | |- | ||
|c11 || text || Runtime | |c11 || text || Runtime | ||
|- | |- | ||
|c12 || text || MPAA Rating | |c12 || text || MPAA Rating | ||
Line 167: | Line 167: | ||
|c16 || text || Original Movie Title | |c16 || text || Original Movie Title | ||
|- | |- | ||
|c17 || text || | |c17 || text || Thumb URL Spoof] | ||
|- | |- | ||
|c18 || text || Studio | |c18 || text || Studio | ||
Line 175: | Line 175: | ||
|c20 || text || Fanart URLs | |c20 || text || Fanart URLs | ||
|- | |- | ||
|c21 || text || Country | |c21 || text || Country | ||
|- | |- | ||
|c22 || text || Path to playable file | |c22 || text || Path to playable file | ||
|- | |- | ||
|c23 || text || | |c23 || text || Link to [[Databases/MyVideos#path|path table]] for Source folder | ||
|- | |- | ||
|idSet || integer || Foreign Key to [[Databases#sets|sets table]] | |idSet || integer || Foreign Key to [[Databases/MyVideos#sets|sets table]] | ||
|- | |- | ||
|userrating || integer || Rating applied by user | |userrating || integer || Rating applied by user | ||
Line 204: | Line 204: | ||
|- | |- | ||
|totalTimeInSeconds || double || Length of video | |totalTimeInSeconds || double || Length of video | ||
|- | |||
|playerState || text || | |||
|- | |- | ||
|rating || float || Rating | |rating || float || Rating | ||
Line 211: | Line 213: | ||
|rating_type || text || Type of rating | |rating_type || text || Type of rating | ||
|- | |- | ||
|uniqueid_value || text || | |uniqueid_value || text || Default UniqueID ( default="true" ) | ||
|- | |||
|uniqueid_type || text || Provider of the default UniqueID. eg... <uniqueid type="tmdb" default="true"> | |||
|- | |||
|hasVideoVersions || integer || 0 = the movie has a single version; 1 = the movie has additional versions | |||
|- | |||
|hasVideoExtras || integer || 0 = No Extras; 1 = has Extras | |||
|- | |||
|isDefaultVersion || integer || 0 = Not the default / parent version; 1 = Default / parent version | |||
|- | |||
|videoVersionIdFile || integer || [version specific] Foreign Key to [[Databases/MyVideos#files|files table]] | |||
|- | |||
|videoVersionTypeId || integer || [version specific] Foreign Key to [[Databases/MyVideos#videoversiontype|videoversiontype table]] | |||
|- | |- | ||
| | |videoVersionTypeName || text || [version specific] Descriptive name of the version, see [[Databases/MyVideos#videoversiontype|videoversiontype table]] | ||
|- | |||
|VideoVersionTypeItemType || integer || [version specific] Type of the version, see [[Databases/MyVideos#videoversiontype|videoversiontype table]] | |||
|} | |} | ||
== | == musicvideo_view == | ||
A view that joins musicvideo to file and path. | A view that joins musicvideo to file and path. | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 225: | Line 241: | ||
|idMVideo || integer || Primary Key | |idMVideo || integer || Primary Key | ||
|- | |- | ||
|idFile || integer || Foreign Key to [[Databases#files|files table]] | |idFile || integer || Foreign Key to [[Databases/MyVideos#files|files table]] | ||
|- | |- | ||
|c00 || text || Title | |c00 || text || Title | ||
|- | |- | ||
|c01 || text || | |c01 || text || Thumb URL | ||
|- | |- | ||
|c02 || text || | |c02 || text || Thumb URL spoof | ||
|- | |- | ||
|c03 || text || | |c03 || text || Not Used | ||
|- | |- | ||
|c04 || text || Run time | |c04 || text || Run time | ||
|- | |- | ||
|c05 || text || Director | |c05 || text || Director | ||
|- | |- | ||
|c06 || text || Studios | |c06 || text || Studios | ||
|- | |- | ||
|c07 || text || | |c07 || text || Not Used | ||
|- | |- | ||
|c08 || text || Plot | |c08 || text || Plot | ||
|- | |- | ||
|c09 || text || Album | |c09 || text || Album | ||
|- | |- | ||
|c10 || text || Artist | |c10 || text || Artist | ||
|- | |- | ||
|c11 || text || Genre | |c11 || text || Genre | ||
|- | |- | ||
|c12 || text || Track | |c12 || text || Track | ||
|- | |- | ||
|c13 || text || | |c13 || text || Path to playable file | ||
|- | |- | ||
|c14 || text || | |c14 || text || Link to [[Databases/MyVideos#path|path table]] for Source folder | ||
|- | |- | ||
|c15 || text || | |c15 || text || Not Used | ||
|- | |- | ||
|c16 || text || | |c16 || text || Not Used | ||
|- | |- | ||
|c17 || text || | |c17 || text || Not Used | ||
|- | |- | ||
|c18 || text || | |c18 || text || Not Used | ||
|- | |- | ||
|c19 || text || | |c19 || text || Not Used | ||
|- | |- | ||
|c20 || text || | |c20 || text || Not Used | ||
|- | |- | ||
|c21 || text || | |c21 || text || Not Used | ||
|- | |- | ||
|c22 || text || | |c22 || text || Not Used | ||
|- | |- | ||
|c23 || text || | |c23 || text || Not Used | ||
|- | |- | ||
|userrating || integer || User Rating | |userrating || integer || User Rating | ||
Line 292: | Line 308: | ||
|- | |- | ||
|totalTimeInSeconds || double || Time in seconds of the video | |totalTimeInSeconds || double || Time in seconds of the video | ||
|- | |||
|playerState || text || | |||
|} | |||
== season_view == | |||
A view that joins seasons to the tvshow. | |||
{|class="prettytable" | |||
! Column Name || Data Type || Description | |||
|- | |||
|idSeason || integer || Primary Key | |||
|- | |||
|idShow || integer || Foreign key to the [[Databases/MyVideos#files|tv show table]] | |||
|- | |||
|Season || integer || Season number | |||
|- | |||
|name || text || User modified Season name | |||
|- | |||
|userrating || integer || User rating for season | |||
|- | |||
|strPath || text || Path to tv show | |||
|- | |||
|showTitle || text || TV Show name | |||
|- | |||
|Plot || text || TV Show plot | |||
|- | |||
|premiered || text || TV Show premiered date | |||
|- | |||
|genre || text || genre | |||
|- | |||
|studio || text || Studio | |||
|- | |||
|mpaa || text || Certification | |||
|- | |||
|episodes || text || Season episode count | |||
|- | |||
|playCount || integer || Number of play times. Each played episode increases the count | |||
|- | |||
|aired || text || Aired date of the first episode in the season | |||
|- | |||
|inProgressCount || integer || Show watched/in progress/total counts in home screen listings and video window listings<ref>https://github.com/xbmc/xbmc/pull/23658</ref> | |||
|} | |} | ||
== | == tvshow_view == | ||
View that joins tvshow to path. Also produces information about total number of episodes as well as number of watched and unwatched episodes. | View that joins tvshow to path. Also produces information about total number of episodes as well as number of watched and unwatched episodes. | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 335: | Line 394: | ||
|c15 || text || Title formatted for sorting | |c15 || text || Title formatted for sorting | ||
|- | |- | ||
|c16 || text || | |c16 || text || Trailer | ||
|- | |- | ||
|c17 || text || Not Used | |c17 || text || Not Used | ||
Line 355: | Line 414: | ||
|duration || integer || Total duration | |duration || integer || Total duration | ||
|- | |- | ||
|idParentPath || integer || | |idParentPath || integer || | ||
|- | |- | ||
|strPath || text || Path URL | |strPath || text || Path URL | ||
Line 375: | Line 434: | ||
|rating_type || text || Type of rating | |rating_type || text || Type of rating | ||
|- | |- | ||
|uniqueid_value || text || | |uniqueid_value || text || Default UniqueID ( default="true" ) | ||
|- | |- | ||
|uniqueid_type || text || | |uniqueid_type || text || Provider of the default UniqueID. eg... <uniqueid type="tmdb" default="true"> | ||
|- | |||
|inProgressCount || integer || Show in progress episodes count along with watched episodes and total episodes count in home screen listings and video window listings.<ref>https://github.com/xbmc/xbmc/pull/23658</ref> | |||
|} | |} | ||
== | == tvshowcounts == | ||
This table stores the TV Show watched count, total seasons, last played and date added data | This table stores the TV Show watched count, total seasons, last played and date added data | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 398: | Line 459: | ||
|- | |- | ||
|dateAdded || text || Date Added | |dateAdded || text || Date Added | ||
|- | |||
|inProgressCount || integer || Show in progress episodes count along with watched episodes and total episodes count in home screen listings and video window listings.<ref>https://github.com/xbmc/xbmc/pull/23658</ref> | |||
|} | |||
== tvshowlinkpath_minview == | |||
Joins TV Show to Path | |||
{|class="prettytable" | |||
! Column Name || Data Type || Description | |||
|- | |||
|idShow || integer || Primary Key | |||
|- | |||
|idPath || || Foreign key to [[Databases/MyVideos#path|path table]] | |||
|} | |} | ||
{{top}} | {{top}} | ||
= Tables = | = Tables = | ||
The information in the Video Library is organized into the following tables. Several large tables (such as [[Databases#episode|episode]], [[Databases#movie|movie]], [[Databases#settings|settings]], and [[Databases#tvshow|tvshow]]) contain the bulk of the information, while most of the others are used to link a long string to a common ID key. | The information in the Video Library is organized into the following tables. Several large tables (such as [[Databases/MyVideos#episode|episode]], [[Databases/MyVideos#movie|movie]], [[Databases/MyVideos#settings|settings]], and [[Databases/MyVideos#tvshow|tvshow]]) contain the bulk of the information, while most of the others are used to link a long string to a common ID key. | ||
== actor == | == actor == | ||
This table stores actor, artist, director, and writer information. | This table stores actor, artist, director, and writer information. | ||
Line 432: | Line 508: | ||
== actor_link == | == actor_link == | ||
This table links actors to Movies, TV Shows, Episodes, Music Videos and stores role information. | This table links actors to Movies, TV Shows, Episodes, Music Videos and stores role information. | ||
Line 440: | Line 516: | ||
! rowspan="1" style="text-align: centre;" | Music Videos | ! rowspan="1" style="text-align: centre;" | Music Videos | ||
|- | |- | ||
|actor_id || integer || Foreign key to [[Databases# | |actor_id || integer || Foreign key to [[Databases/MyVideos#actor|actors table]] || || | ||
|- | |- | ||
|media_id || integer || Foreign key to [[Databases#episode|episode table]], [[Databases#tvshow|tv show table]], [[Databases#movie|movie table]],[[Databases#musicvideo|music video table]] || || | |media_id || integer || Foreign key to [[Databases/MyVideos#episode|episode table]], [[Databases/MyVideos#tvshow|tv show table]], [[Databases/MyVideos#movie|movie table]],[[Databases/MyVideos#musicvideo|music video table]] || || | ||
|- | |- | ||
|media_type || text || Movie, TV Show, Episode, Music Video || <movie></movie><br /><tvshow></tvshow><br /><episodedetails></episodedetails> || <musicvideo></musicvideo> | |media_type || text || Movie, TV Show, Episode, Music Video || <movie></movie><br /><tvshow></tvshow><br /><episodedetails></episodedetails> || <musicvideo></musicvideo> | ||
Line 460: | Line 536: | ||
== art == | == art == | ||
This table stores URLs for video art metadata. | This table stores URLs for video art metadata. | ||
Line 474: | Line 550: | ||
|media_id || integer || The id of the media this piece of art is for || || || || | |media_id || integer || The id of the media this piece of art is for || || || || | ||
|- | |- | ||
|media_type || text || The type of media this art applies to - movie, set, tvshow, season, episode, musicvideo or | |media_type || text || The type of media this art applies to - movie, set, tvshow, season, episode, musicvideo, actor or videoversion|| || || || | ||
|- | |- | ||
|type || text || The image type - poster, fanart, thumb, banner, landscape, clearlogo, clearart, characterart or discart |||| || || | |type || text || The image type - poster, fanart, thumb, banner, landscape, clearlogo, clearart, characterart or discart |||| || || | ||
Line 512: | Line 588: | ||
|} | |} | ||
== bookmark == | |||
== bookmark == | |||
This table stores bookmarks, which are timestamps representing the point in a video where a user stopped playback, an explicit bookmark requested by the user, or an automatically generated episode bookmark. | This table stores bookmarks, which are timestamps representing the point in a video where a user stopped playback, an explicit bookmark requested by the user, or an automatically generated episode bookmark. | ||
Line 523: | Line 597: | ||
|idBookmark || integer || Primary Key || | |idBookmark || integer || Primary Key || | ||
|- | |- | ||
|idFile || integer || Foreign key to [[Databases#files|files table]] || | |idFile || integer || Foreign key to [[Databases/MyVideos#files|files table]] || | ||
|- | |- | ||
|timeInSeconds || double || Time in seconds of bookmark location | |timeInSeconds || double || Time in seconds of bookmark location | ||
Line 532: | Line 606: | ||
</resume> | </resume> | ||
|- | |- | ||
|totalTimeInSeconds || | |totalTimeInSeconds || double || Time in seconds of the video | ||
|- | |- | ||
|thumbNailImage || text || Thumbnail for bookmark || | |thumbNailImage || text || Thumbnail for bookmark || | ||
Line 545: | Line 619: | ||
== country == | == country == | ||
This table lists countries. | This table lists countries. | ||
Line 558: | Line 632: | ||
== country link == | == country link == | ||
This table links countries to movies. | This table links countries to movies. | ||
Line 564: | Line 638: | ||
! Column Name || Data Type || Description | ! Column Name || Data Type || Description | ||
|- | |- | ||
|country_id || integer || Foreign key to [[Databases#country|country table]] | |country_id || integer || Foreign key to [[Databases/MyVideos#country|country table]] | ||
|- | |- | ||
|media_id || integer ||Foreign key to [[Databases#movie|movie table]] | |media_id || integer ||Foreign key to [[Databases/MyVideos#movie|movie table]] | ||
|- | |- | ||
|media_type || | |media_type || text || Media Class | ||
|} | |} | ||
== director_link == | == director_link == | ||
This table links directors to Movies, TV show episodes and Music Videos | This table links directors to Movies, TV show episodes and Music Videos | ||
Line 579: | Line 653: | ||
! Column Name || Data Type || Description | ! Column Name || Data Type || Description | ||
|- | |- | ||
|actor_id || integer || Foreign key to [[Databases#actors|actors table]] | |actor_id || integer || Foreign key to [[Databases/MyVideos#actors|actors table]] | ||
|- | |- | ||
|media_id || integer || Foreign key to [[Databases#episode|episode table]], [[Databases#movie|movie table]],[[Databases#musicvideo|music video table]] | |media_id || integer || Foreign key to [[Databases/MyVideos#episode|episode table]], [[Databases/MyVideos#movie|movie table]],[[Databases/MyVideos#musicvideo|music video table]] | ||
|- | |- | ||
|media_type || text || Movie, Music Video, Episode | |media_type || text || Movie, Music Video, Episode | ||
Line 588: | Line 662: | ||
== episode == | == episode == | ||
This table stores television episode information. Information concerning the series is stored in [[Databases#tvshow|tvshow]]. To link an episode to its parent series, use [[Databases#tvshowlinkepisode|tvshowlinkepisode]]. | This table stores television episode information. Information concerning the series is stored in [[Databases/MyVideos#tvshow|tvshow]]. To link an episode to its parent series, use [[Databases/MyVideos#tvshowlinkepisode|tvshowlinkepisode]]. | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 597: | Line 671: | ||
|idEpisode || integer || Primary Key || | |idEpisode || integer || Primary Key || | ||
|- | |- | ||
|idFile || integer || Foreign key to the [[Databases#files|files table]] || | |idFile || integer || Foreign key to the [[Databases/MyVideos#files|files table]] || | ||
|- | |- | ||
|c00 || text || Episode Title || <title></title> | |c00 || text || Episode Title || <title></title> | ||
Line 603: | Line 677: | ||
|c01 || text || Plot Summary || <plot></plot> | |c01 || text || Plot Summary || <plot></plot> | ||
|- | |- | ||
|c02 || text || | |c02 || text || Not Used || | ||
|- | |- | ||
|c03 || text || Link to [[Databases#rating|Rating Table]] || | |c03 || text || Link to [[Databases/MyVideos#rating|Rating Table]] || | ||
|- | |- | ||
|c04 || text || Writer || <credits></credits> | |c04 || text || Writer || <credits></credits> | ||
Line 613: | Line 687: | ||
|c06 || text || Thumbnail URL || <thumb></thumb> | |c06 || text || Thumbnail URL || <thumb></thumb> | ||
|- | |- | ||
|c07 || text || | |c07 || text || Thumbnail URL Spoof || | ||
|- | |- | ||
|c08 || text || | |c08 || text || Not Used || | ||
|- | |- | ||
|c09 || text || | |c09 || text || Runtime || <runtime></runtime> | ||
|- | |- | ||
|c10 || text || Director || <director></director> | |c10 || text || Director || <director></director> | ||
|- | |- | ||
|c11 || text || | |c11 || text || Production Code || <code></code> | ||
|- | |- | ||
|c12 || | |c12 || varchar(24) || Season Number || <season></season> | ||
|- | |- | ||
|c13 || | |c13 || varchar(24) || Episode Number || <episode></episode> | ||
|- | |- | ||
|c14 || text || Original Title || <originaltitle></originaltitle> | |c14 || text || Original Title || <originaltitle></originaltitle> | ||
|- | |- | ||
|c15 || text || Season | |c15 || text || Season Number- Specials Sorting || <displayseason></displayseason> | ||
|- | |- | ||
|c16 || text || Episode | |c16 || text || Episode Number- Specials Sorting || <displayepisode></displayepisode> | ||
|- | |- | ||
|c17 || | |c17 || varchar(24) || Bookmark || | ||
|- | |- | ||
|c18 || text || Path to episode file || | |c18 || text || Path to episode file || | ||
|- | |- | ||
|c19 || text || | |c19 || text || Link to [[Databases/MyVideos#path|Path Table]] || | ||
|- | |- | ||
|c20 || text || | |c20 || text || Link to [[Databases/MyVideos#uniqueid|UniqueID Table]] || | ||
|- | |- | ||
|c21 || text || Not used || | |c21 || text || Not used || | ||
Line 647: | Line 721: | ||
|c23 || text || Not used || | |c23 || text || Not used || | ||
|- | |- | ||
|idShow || | |idShow || integer || Foreign key to the [[Databases/MyVideos#tvshow|tvshow table]] || | ||
|- | |- | ||
|userrating || | |userrating || integer || User Rating || <userrating></userrating> | ||
|- | |- | ||
|idSeason || | |idSeason || integer || Foreign key to the [[Databases/MyVideos#seasons|seasons table]] || | ||
|} | |} | ||
== files == | == files == | ||
This table stores filenames and links the path. | This table stores filenames and links the path. | ||
Line 664: | Line 738: | ||
|idFile || integer || Primary Key || | |idFile || integer || Primary Key || | ||
|- | |- | ||
|idPath || integer || Foreign key to [[Databases#path|path table]] || | |idPath || integer || Foreign key to [[Databases/MyVideos#path|path table]] || | ||
|- | |- | ||
|strFilename || text || Full name of file including extension || | |strFilename || text || Full name of file including extension || | ||
Line 677: | Line 751: | ||
== genre == | == genre == | ||
This table stores genre information. For convenience the contents are duplicated in [[Databases#movie|movie]] and [[Databases#tvshow|tvshow]], so a join isn't necessary. | This table stores genre information. For convenience the contents are duplicated in [[Databases/MyVideos#movie|movie]] and [[Databases/MyVideos#tvshow|tvshow]], so a join isn't necessary. | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 690: | Line 764: | ||
== genre_link == | == genre_link == | ||
This table links genres to movies. (The contents are also stored in movies.c14, though.) | This table links genres to movies. (The contents are also stored in movies.c14, though.) | ||
Line 696: | Line 770: | ||
! Column Name || Data Type || Description | ! Column Name || Data Type || Description | ||
|- | |- | ||
|genre_id || integer || Foreign key to [[Databases#genre|genre table]] | |genre_id || integer || Foreign key to [[Databases/MyVideos#genre|genre table]] | ||
|- | |- | ||
|media_id || integer || Foreign key to [[Databases#movie|movie table]], [[Databases#tvshow|tv show table]], [[Databases#musicvideo|music video table]] | |media_id || integer || Foreign key to [[Databases/MyVideos#movie|movie table]], [[Databases/MyVideos#tvshow|tv show table]], [[Databases/MyVideos#musicvideo|music video table]] | ||
|- | |- | ||
|media_type || text || Movie, Music Video, TV Show | |media_type || text || Movie, Music Video, TV Show | ||
Line 705: | Line 779: | ||
== movie == | == movie == | ||
This table stores movie information. | This table stores movie information. | ||
Line 714: | Line 788: | ||
|idMovie || integer || Primary Key || | |idMovie || integer || Primary Key || | ||
|- | |- | ||
|idFile || integer || Foreign Key to [[Databases#files|files table]] || | |idFile || integer || Foreign Key to [[Databases/MyVideos#files|files table]] || | ||
|- | |- | ||
|c00 || text || Local Movie Title || <title></title> | |c00 || text || Local Movie Title || <title></title> | ||
Line 724: | Line 798: | ||
|c03 || text || Movie Tagline || <tagline></tagline> | |c03 || text || Movie Tagline || <tagline></tagline> | ||
|- | |- | ||
|c04 || text || | |c04 || text || Not Used || | ||
|- | |- | ||
|c05 || text || Link to [[Databases#rating|Rating Table]] || | |c05 || text || Link to [[Databases/MyVideos#rating|Rating Table]] || | ||
|- | |- | ||
|c06 || text || Writers || <credits></credits> | |c06 || text || Writers || <credits></credits> | ||
|- | |- | ||
|c07 || text || | |c07 || text || Not Used || | ||
|- | |- | ||
|c08 || text || Image URL || <thumb aspect="poster" preview=""></thumb> | |c08 || text || Image URL || <thumb aspect="poster" preview=""></thumb> | ||
|- | |- | ||
|c09 || text || | |c09 || text || Link to [[Databases/MyVideos#uniqueid|uniqueid Table]] || | ||
|- | |- | ||
|c10 || text || Title formatted for sorting || <sorttitle></sorttitle> | |c10 || text || Title formatted for sorting || <sorttitle></sorttitle> | ||
|- | |- | ||
|c11 || text || Runtime | |c11 || text || Runtime || <runtime></runtime> ** | ||
|- | |- | ||
|c12 || text || MPAA Rating || <mpaa></mpaa> | |c12 || text || MPAA Rating || <mpaa></mpaa> | ||
Line 750: | Line 824: | ||
|c16 || text || Original Movie Title || <originaltitle></originaltitle> | |c16 || text || Original Movie Title || <originaltitle></originaltitle> | ||
|- | |- | ||
|c17 || text || | |c17 || text || Thumb URL Spoof || | ||
|- | |- | ||
|c18 || text || Studio || <studio></studio> | |c18 || text || Studio || <studio></studio> | ||
Line 762: | Line 836: | ||
</fanart> | </fanart> | ||
|- | |- | ||
|c21 || text || Country | |c21 || text || Country || <country></country> | ||
|- | |- | ||
|c22 || text || Path to playable file || | |c22 || text || Path to playable file || | ||
|- | |- | ||
|c23 || text || | |c23 || text || Link to [[Databases/MyVideos#path|path table]] for Source folder || | ||
|- | |- | ||
|idSet || integer || Foreign Key to [[Databases#sets|sets table]] || | |idSet || integer || Foreign Key to [[Databases/MyVideos#sets|sets table]] || | ||
|- | |- | ||
|userrating || integer || Rating applied by user || <userrating></userrating> | |userrating || integer || Rating applied by user || <userrating></userrating> | ||
Line 782: | Line 856: | ||
== movielinktvshow == | == movielinktvshow == | ||
This table links movies to TV shows. | This table links movies to TV shows. | ||
Line 788: | Line 862: | ||
! Column Name || Data Type || Description | ! Column Name || Data Type || Description | ||
|- | |- | ||
|idMovie || integer || Foreign key to [[Databases#movie|movie table]] | |idMovie || integer || Foreign key to [[Databases/MyVideos#movie|movie table]] | ||
|- | |- | ||
|idShow || integer || Foreign key to [[Databases#tvshow|tvshow table]] | |idShow || integer || Foreign key to [[Databases/MyVideos#tvshow|tvshow table]] | ||
|} | |} | ||
== musicvideo == | == musicvideo == | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 802: | Line 876: | ||
|idMVideo || integer || Primary Key || | |idMVideo || integer || Primary Key || | ||
|- | |- | ||
|idFile || integer || Foreign Key to [[Databases#files|files table]] || | |idFile || integer || Foreign Key to [[Databases/MyVideos#files|files table]] || | ||
|- | |- | ||
|c00 || text || Title || <title></title> | |c00 || text || Title || <title></title> | ||
|- | |- | ||
|c01 || text || | |c01 || text || Thumb URL || <thumb preview=""></thumb> | ||
|- | |- | ||
|c02 || text || | |c02 || text || Thumb URL spoof || | ||
|- | |- | ||
|c03 || text || | |c03 || text || Not Used || | ||
|- | |- | ||
|c04 || text || Run time || <runtime></runtime> | |c04 || text || Run time || <runtime></runtime> | ||
Line 818: | Line 892: | ||
|c06 || text || Studios || <studio></studio> | |c06 || text || Studios || <studio></studio> | ||
|- | |- | ||
|c07 || text || | |c07 || text || Not Used || | ||
|- | |- | ||
|c08 || text || Plot || <plot></plot> | |c08 || text || Plot || <plot></plot> | ||
Line 828: | Line 902: | ||
|c11 || text || Genre || <genre></genre> | |c11 || text || Genre || <genre></genre> | ||
|- | |- | ||
|c12 || text || Track || | |c12 || text || Track || | ||
|- | |- | ||
|c13 || text || Path to playable file || <filenameandpath></filenameandpath | |c13 || text || Path to playable file || <filenameandpath></filenameandpath> | ||
|- | |- | ||
|c14 || text || | |c14 || text || Link to [[Databases/MyVideos#path|path table]] for Source folder || <basepath></basepath> | ||
|- | |- | ||
|c15 || text || | |c15 || text || Not Used || | ||
|- | |- | ||
|c16 || text || | |c16 || text || Not Used || | ||
|- | |- | ||
|c17 || text || | |c17 || text || Not Used || | ||
|- | |- | ||
|c18 || text || | |c18 || text || Not Used || | ||
|- | |- | ||
|c19 || text || | |c19 || text || Not Used || | ||
|- | |- | ||
|c20 || text || | |c20 || text || Not Used || | ||
|- | |- | ||
|c21 || text || | |c21 || text || Not Used || | ||
|- | |- | ||
|c22 || text || | |c22 || text || Not Used || | ||
|- | |- | ||
|c23 || text || | |c23 || text || Not Used || | ||
|- | |- | ||
|userrating || integer || Rating applied by user || <userrating></userrating> | |userrating || integer || Rating applied by user || <userrating></userrating> | ||
|- | |- | ||
|premiered || text || Date movie premiered || < | |premiered || text || Date movie premiered || <premiered></premiered> | ||
|} | |} | ||
== path == | == path == | ||
This table stores path information. | This table stores path information. | ||
Line 871: | Line 945: | ||
|strContent || text || Type of content (tvshows, movies, etc...) | |strContent || text || Type of content (tvshows, movies, etc...) | ||
|- | |- | ||
|strScraper || text || | |strScraper || text || addon ID | ||
|- | |- | ||
|strHash || text || Hash | |strHash || text || Hash | ||
Line 884: | Line 958: | ||
|- | |- | ||
|exclude || bool || | |exclude || bool || | ||
|- | |||
|allAudio || bool || Skip filename matching for external audio tracks<br>0 = Disabled<br>1 = Enabled | |||
|- | |- | ||
|dateAdded || text || | |dateAdded || text || | ||
Line 892: | Line 968: | ||
== rating == | == rating == | ||
This table stores the ratings for TV Shows, Episodes and Movies | This table stores the ratings for TV Shows, Episodes and Movies | ||
Line 901: | Line 977: | ||
|rating_id || integer || Primary Key || | |rating_id || integer || Primary Key || | ||
|- | |- | ||
|media_id || integer || Foreign key to [[Databases#episode|episode table]], [[Databases#tvshow|tv show table]], [[Databases#movie|movie table]], || | |media_id || integer || Foreign key to [[Databases/MyVideos#episode|episode table]], [[Databases/MyVideos#tvshow|tv show table]], [[Databases/MyVideos#movie|movie table]], || | ||
|- | |- | ||
|media_type || text || Movies, TV Show, TV Episode || <movie></movie><br /><tvshow></tvshow><br /><episodedetails></episodedetails> | |media_type || text || Movies, TV Show, TV Episode || <movie></movie><br /><tvshow></tvshow><br /><episodedetails></episodedetails> | ||
Line 921: | Line 997: | ||
== seasons == | == seasons == | ||
This table stores the links between tv show and seasons. | This table stores the links between tv show and seasons. | ||
Line 929: | Line 1,005: | ||
|idSeason || integer || Primary Key || | |idSeason || integer || Primary Key || | ||
|- | |- | ||
|idShow|| integer || Foreign key to [[Databases#tvshow|tvshow table]] || | |idShow|| integer || Foreign key to [[Databases/MyVideos#tvshow|tvshow table]] || | ||
|- | |- | ||
|season || integer || Season number || <season></season> | |season || integer || Season number || <season></season> | ||
|- | |- | ||
|name || text || Season Name || | |name || text || Season Name || <namedseason number="n"></namedseason><br/> n = season number | ||
|- | |- | ||
|userrating || integer || Season level User Rating || | |userrating || integer || Season level User Rating || | ||
Line 940: | Line 1,016: | ||
== sets == | == sets == | ||
This table stores the id and name for movie sets. Sets are linked to movies in the movie table (idSet column). | This table stores the id and name for movie sets. Sets are linked to movies in the movie table (idSet column). | ||
Line 961: | Line 1,037: | ||
== settings == | == settings == | ||
This table stores settings for individual files. | This table stores settings for individual files. | ||
Line 967: | Line 1,043: | ||
! Column Name || Data Type || Description | ! Column Name || Data Type || Description | ||
|- | |- | ||
|idFile || integer || Foreign Key to [[Databases#files|files table]] | |idFile || integer || Foreign Key to [[Databases/MyVideos#files|files table]] | ||
|- | |- | ||
|Deinterlace || bool || Deinterlace | |Deinterlace || bool || Deinterlace | ||
Line 987: | Line 1,063: | ||
|SubtitleOn || bool || Enable subtitles | |SubtitleOn || bool || Enable subtitles | ||
|- | |- | ||
|Brightness || | |Brightness || float || Brightness | ||
|- | |- | ||
|Contrast || | |Contrast || float || Contrast | ||
|- | |- | ||
|Gamma || | |Gamma || float || Gamma | ||
|- | |- | ||
|VolumeAmplification || float || VolumeAmplification | |VolumeAmplification || float || VolumeAmplification | ||
|- | |- | ||
|AudioDelay || float || AudioDelay | |AudioDelay || float || AudioDelay | ||
|- | |- | ||
|ResumeTime || integer || ResumeTime | |ResumeTime || integer || ResumeTime | ||
|- | |- | ||
|Sharpness || float || Sharpness | |Sharpness || float || Sharpness | ||
Line 1,028: | Line 1,092: | ||
|- | |- | ||
|VideoStream || integer || VideoStream | |VideoStream || integer || VideoStream | ||
|- | |||
|TonemapMethod || integer || | |||
|- | |||
|TonemapParam || float || | |||
|- | |||
|Orientation || integer || | |||
|- | |||
|CenterMixLevel || integer || | |||
|} | |} | ||
== stacktimes == | == stacktimes == | ||
This table stores playing times for files (used for playing multi-file videos). | This table stores playing times for files (used for playing multi-file videos). | ||
Line 1,038: | Line 1,110: | ||
! Column Name || Data Type || Description | ! Column Name || Data Type || Description | ||
|- | |- | ||
|idFile || integer || Foreign key to [[Databases#files|files table]] | |idFile || integer || Foreign key to [[Databases/MyVideos#files|files table]] | ||
|- | |- | ||
|times|| text || Times | |times|| text || Times | ||
Line 1,045: | Line 1,117: | ||
== streamdetails == | == streamdetails == | ||
This table contains information regarding codecs used, aspect ratios etc | This table contains information regarding codecs used, aspect ratios etc | ||
Line 1,052: | Line 1,124: | ||
! rowspan="1" style="text-align: centre;" | Movies **<br />TV Episode ** | ! rowspan="1" style="text-align: centre;" | Movies **<br />TV Episode ** | ||
! rowspan="1" style="text-align: centre;" | Music Videos ** | ! rowspan="1" style="text-align: centre;" | Music Videos ** | ||
! Version<br/>Added | |||
|- | |- | ||
|idFile || integer || Foreign Key to [[Databases#files|files table]] || || | |idFile || integer || Foreign Key to [[Databases/MyVideos#files|files table]] || || || | ||
|- | |- | ||
|iStreamType || integer || 0 = video, 1 = audio, 2 = subtitles || || | |iStreamType || integer || 0 = video, 1 = audio, 2 = subtitles || || || | ||
|- | |- | ||
|strVideoCodec|| text || Video codex (xvid etc) | |strVideoCodec|| text || Video codex (xvid etc) | ||
Line 1,073: | Line 1,146: | ||
| rowspan="6" style="text-align: left;" | | | rowspan="6" style="text-align: left;" | | ||
|- | |- | ||
|fVideoAspect|| | |fVideoAspect|| float || Aspect ratio | ||
|- | |- | ||
|iVideoWidth|| integer || Width of the video | |iVideoWidth|| integer || Width of the video | ||
Line 1,079: | Line 1,152: | ||
|iVideoHeight|| integer || Height of the video | |iVideoHeight|| integer || Height of the video | ||
|- | |- | ||
|iVideoDuration|| integer || Actual runtime in sec | |iVideoDuration|| integer || Actual runtime in sec | ||
|- | |- | ||
|strStereoMode || text || Stereo Mode | |strStereoMode || text || Stereo Mode | ||
|- | |- | ||
|strAudioCodec|| text || Audio codec (aac, mp3 etc) | |strAudioCodec|| text || Audio codec (aac, mp3 etc) | ||
| rowspan="3" style="text-align: left;" | | | rowspan="3" style="text-align: left;" | | ||
<fileinfo> | <fileinfo> | ||
<streamdetails> | <streamdetails> | ||
<audio> | <audio> | ||
<codec></codec> | <codec></codec> | ||
Line 1,093: | Line 1,165: | ||
<language></language> | <language></language> | ||
</audio> | </audio> | ||
</streamdetails> | </streamdetails> | ||
</fileinfo> | </fileinfo> | ||
| rowspan="3" style="text-align: left;" | | | rowspan="3" style="text-align: left;" | | ||
<fileinfo> | <fileinfo> | ||
<streamdetails> | <streamdetails> | ||
<audio> | <audio> | ||
<codec></codec> | <codec></codec> | ||
Line 1,105: | Line 1,175: | ||
<language></language> | <language></language> | ||
</audio> | </audio> | ||
</streamdetails> | </streamdetails> | ||
</fileinfo> | </fileinfo> | ||
Line 1,126: | Line 1,195: | ||
| rowspan="1" style="text-align: left;" | | | rowspan="1" style="text-align: left;" | | ||
|- | |- | ||
|strVideoLanguage|| text || Language of the Video || | |strVideoLanguage|| text || Language of the Video || || || | ||
|- | |||
|strHdrType|| text || hdr type of the video || <hdrtype></hdrtype> || || v20 <ref>https://github.com/xbmc/xbmc/pull/19983</ref> | |||
|} | |} | ||
Line 1,137: | Line 1,208: | ||
== studio == | == studio == | ||
This table stores studio information. | This table stores studio information. | ||
Line 1,150: | Line 1,221: | ||
== studio link == | == studio link == | ||
This table links studios to movies, music videos and tv shows | This table links studios to movies, music videos and tv shows | ||
Line 1,156: | Line 1,227: | ||
! Column Name || Data Type || Description | ! Column Name || Data Type || Description | ||
|- | |- | ||
|studio_id || integer || Foreign key to [[Databases#studio|studio table]] | |studio_id || integer || Foreign key to [[Databases/MyVideos#studio|studio table]] | ||
|- | |- | ||
|media_id || integer || Foreign key to [[Databases#movie|movie table]], [[Databases#tvshow|tv show table]], [[Databases#musicvideo|music video table]] | |media_id || integer || Foreign key to [[Databases/MyVideos#movie|movie table]], [[Databases/MyVideos#tvshow|tv show table]], [[Databases/MyVideos#musicvideo|music video table]] | ||
|- | |- | ||
|media_type || text || Movie, Music Video, TV Show | |media_type || text || Movie, Music Video, TV Show | ||
Line 1,165: | Line 1,236: | ||
== tag == | == tag == | ||
This stores tags. | This stores tags. | ||
Line 1,178: | Line 1,249: | ||
== | == tag_link == | ||
This table links tags to various media. | This table links tags to various media. | ||
Line 1,184: | Line 1,255: | ||
! Column Name || Data Type || Description | ! Column Name || Data Type || Description | ||
|- | |- | ||
|tag_id || integer || Foreign key to [[Databases#tag|tag table]] | |tag_id || integer || Foreign key to [[Databases/MyVideos#tag|tag table]] | ||
|- | |- | ||
|media_id || integer || Foreign key to a media table | |media_id || integer || Foreign key to a media table | ||
Line 1,193: | Line 1,264: | ||
== tvshow == | == tvshow == | ||
This table stores information about a television series. Information concerning the shows episodes is stored in [[Databases#episode|episode]]. To link a TV show to its episodes, use [[Databases#tvshowlinkepisode|tvshowlinkepisode]]. | This table stores information about a television series. Information concerning the shows episodes is stored in [[Databases/MyVideos#episode|episode]]. To link a TV show to its episodes, use [[Databases/MyVideos#tvshowlinkepisode|tvshowlinkepisode]]. | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 1,209: | Line 1,280: | ||
|c03 || text || Unknown || | |c03 || text || Unknown || | ||
|- | |- | ||
|c04 || text || Link to [[Databases#rating|Rating Table]] || | |c04 || text || Link to [[Databases/MyVideos#rating|Rating Table]] || | ||
|- | |- | ||
|c05 || text || First Aired || <premiered></premiered> | |c05 || text || First Aired || <premiered></premiered> | ||
Line 1,231: | Line 1,302: | ||
</fanart> | </fanart> | ||
|- | |- | ||
|c12 || text || | |c12 || text || Unique ID issued by Kodi based on Scraper ID's || | ||
|- | |- | ||
|c13 || text || Content Rating || <mpaa></mpaa> | |c13 || text || Content Rating || <mpaa></mpaa> | ||
Line 1,239: | Line 1,310: | ||
|c15 || text || Title formatted for sorting || <sorttitle></sorttitle> | |c15 || text || Title formatted for sorting || <sorttitle></sorttitle> | ||
|- | |- | ||
|c16 || text || | |c16 || text || Trailer || <trailer></trailer> | ||
|- | |- | ||
|c17 || text || Not Used || | |c17 || text || Not Used || | ||
Line 1,257: | Line 1,328: | ||
|userrating || integer || Rating applied by user || <userrating></userrating> | |userrating || integer || Rating applied by user || <userrating></userrating> | ||
|- | |- | ||
|duration || | |duration || integer || Length of Episodes || <runtime></runtime> | ||
|} | |} | ||
== tvshowlinkpath == | |||
== tvshowlinkpath == | |||
This table links a TV show to its path. | This table links a TV show to its path. | ||
Line 1,268: | Line 1,337: | ||
! Column Name || Data Type || Description | ! Column Name || Data Type || Description | ||
|- | |- | ||
|idShow || integer || Foreign key to [[Databases#tvshow|tvshow table]] | |idShow || integer || Foreign key to [[Databases/MyVideos#tvshow|tvshow table]] | ||
|- | |- | ||
|idPath || integer || Foreign key to [[Databases#path|path table]] | |idPath || integer || Foreign key to [[Databases/MyVideos#path|path table]] | ||
|} | |} | ||
== uniqueid == | == uniqueid == | ||
This table | This table holds the UniqueID's for Movies, TV shows and Episodes. Normally the UniqueID's are the ID's used at the scraper sites. For user created nfo files for say, home movies, the ID's are user nominated. Music Videos do not require a UniqueID. | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 1,294: | Line 1,363: | ||
== version == | == version == | ||
This table stores database information. | This table stores database information. | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 1,306: | Line 1,375: | ||
== writer_link == | == videoversion == | ||
This table stores the relations between media "parents" (movies, episodes, ...) and their video assets (versions, extras) for the Video Versions feature. <ref>https://github.com/xbmc/xbmc/pulls?page=4&q=is%3Apr+label%3A%22Feature%3A+Video+Versions%2FExtras%22+is%3Aclosed</ref> | |||
{|class="prettytable" | |||
! Column Name || Data Type || Description | |||
|- | |||
|idFile || integer || The video asset. Foreign Key to [[Databases/MyVideos#files|files table]] | |||
|- | |||
|idMedia || integer || id of the media | |||
|- | |||
|media_type || text || The type of media this asset is linked with (v21: the only supported value is "movie") | |||
|- | |||
|itemType || integer || Type of video asset. 0 = VideoVersion; 1 = Extras | |||
|- | |||
|idType || integer || Name of the video asset. Foreign key to the [[Databases/MyVideos#videoversiontype|videoversiontype table]] | |||
|} | |||
== videoversiontype == | |||
This table stores the version types/names and extras names for the Video Versions feature.<ref>https://github.com/xbmc/xbmc/pulls?page=4&q=is%3Apr+label%3A%22Feature%3A+Video+Versions%2FExtras%22+is%3Aclosed</ref> | |||
{|class="prettytable" | |||
! Column Name || Data Type || Description | |||
|- | |||
|id || integer || Primary Key | |||
|- | |||
|name || text || Name / type of the version or extra | |||
|- | |||
|owner || integer || 0 = prepopulated by the system; 1 = added by library scan; 2 = added by user | |||
|- | |||
|itemType || integer || type of asset the record applies to. 0 = Version; 1 = Extras | |||
|} | |||
== writer_link == | |||
This table links writers stored in the actors table to movies and episodes. | This table links writers stored in the actors table to movies and episodes. | ||
Line 1,312: | Line 1,411: | ||
! Column Name || Data Type || Description | ! Column Name || Data Type || Description | ||
|- | |- | ||
|actor_id || integer || Foreign key to [[Databases#actors|actors table]] | |actor_id || integer || Foreign key to [[Databases/MyVideos#actors|actors table]] | ||
|- | |- | ||
|media_id || integer || Foreign key to a media table | |media_id || integer || Foreign key to a media table | ||
Line 1,318: | Line 1,417: | ||
|media_type || text || Media type for link | |media_type || text || Media type for link | ||
|} | |} | ||
= References = | |||
<references /> | |||
{{Top}} | {{Top}} | ||
{{updated|21}} | |||
[[Category:Karellen]] | [[Category:Karellen]] | ||
[[Category:Development]] | [[Category:Development]] | ||
[[Category:Video library]] | [[Category:Video library]] | ||
[[Category: | [[Category:Skin_development]] |
Latest revision as of 21:26, 27 May 2024
Kodi Databases
See also: |
---|
Development Userdata |
Databases | MyVideos |
MyVideos#
This database contains all information concerning TV shows, movies, and music videos. It is used in the Videos portion of Kodi.
The current stable release of Kodi is using the following version of the database:
- Kodi v20 - MyVideos121.db
Warning: The databases are critical components of Kodi. We strongly urge that you do not interfere with them, unless you have knowledge and experience with database designs.
Views
Views are standard queries, often long or complicated queries saved in the database for convenience. The views below allow you to easily access all the information about each of the main media types in the Video Library, across all the linking tables.
episode_view
A view that joins episode to file and tvshow (through tvshowlinkepisode) and path.
Column Name | Data Type | Description |
---|---|---|
idEpisode | integer | Primary Key |
idFile | integer | Foreign key to the files table |
c00 | text | Episode Title |
c01 | text | Plot Summary |
c02 | text | Not Used |
c03 | text | Link to Rating Table |
c04 | text | Writer |
c05 | text | First Aired |
c06 | text | Thumbnail URL |
c07 | text | Thumbnail URL Spoof |
c08 | text | Not Used |
c09 | text | Runtime |
c10 | text | Director |
c11 | text | Production Code |
c12 | varchar(24) | Season Number |
c13 | tvarchar(24)ext | Episode Number |
c14 | text | Original Title |
c15 | text | Season formatted for sorting |
c16 | text | Episode formatted for sorting |
c17 | varchar(24) | Bookmark |
c18 | text | Path to episode file |
c19 | text | Link to Path Table |
c20 | text | Link to UniqueID Table |
c21 | text | Not used |
c22 | text | Not used |
c23 | text | Not used |
idShow | integer | Foreign key to the tvshow table |
userrating | integer | User Rating |
idSeason | integer | Foreign key to the seasons table |
strFilename | text | Full name of file including extension |
strPath | text | Path to playable file |
playCount | integer | # of Times Played |
lastPlayed | text | Date & Time Last Played |
dateAdded | text | Date & Time Added to Library |
strTitle | text | Name of program |
genre | text | Genre |
studio | text | Studio |
premiered | text | Premiered Date |
mpaa | text | MPAA Rating |
resumeTimeInSeconds | double | Resume Point |
totalTimeInSeconds | double | Length of video |
playerState | text | |
rating | float | Rating |
votes | integer | Votes for rating |
rating_type | text | Type of rating |
uniqueid_value | text | Default UniqueID ( default="true" ) |
uniqueid_type | text | Provider of the default UniqueID. eg... <uniqueid type="tmdb" default="true"> |
movie_view
A view that joins movie to file, path, videoversion and videoversiontype. One record per movie version. Most values are the same for all versions of a movie.
Column Name | Data Type | Description |
---|---|---|
idMovie | integer | Primary Key |
idFile | integer | Foreign Key to files table for the default version of the movie. |
c00 | text | Local Movie Title |
c01 | text | Movie Plot |
c02 | text | Movie Plot Outline |
c03 | text | Movie Tagline |
c04 | text | Not Used |
c05 | text | Link to Rating Table |
c06 | text | Writers |
c07 | text | Not Used |
c08 | text | Image URL |
c09 | text | Link to uniqueid Table |
c10 | text | Title formatted for sorting |
c11 | text | Runtime |
c12 | text | MPAA Rating |
c13 | text | IMDB Top 250 Ranking |
c14 | text | Genre |
c15 | text | Director |
c16 | text | Original Movie Title |
c17 | text | Thumb URL Spoof] |
c18 | text | Studio |
c19 | text | Trailer URL |
c20 | text | Fanart URLs |
c21 | text | Country |
c22 | text | Path to playable file |
c23 | text | Link to path table for Source folder |
idSet | integer | Foreign Key to sets table |
userrating | integer | Rating applied by user |
premiered | text | Date movie premiered |
strSet | text | Movie Set |
strSetOverview | text | Movie Set plot |
strFilename | text | Full name of file including extension |
strPath | text | Path to playable file |
playCount | integer | # of Times Played |
lastPlayed | text | Date & Time Last Played |
dateAdded | text | Date & Time Added to Library |
resumeTimeInSeconds | double | Resume Point |
totalTimeInSeconds | double | Length of video |
playerState | text | |
rating | float | Rating |
votes | integer | Votes for rating |
rating_type | text | Type of rating |
uniqueid_value | text | Default UniqueID ( default="true" ) |
uniqueid_type | text | Provider of the default UniqueID. eg... <uniqueid type="tmdb" default="true"> |
hasVideoVersions | integer | 0 = the movie has a single version; 1 = the movie has additional versions |
hasVideoExtras | integer | 0 = No Extras; 1 = has Extras |
isDefaultVersion | integer | 0 = Not the default / parent version; 1 = Default / parent version |
videoVersionIdFile | integer | [version specific] Foreign Key to files table |
videoVersionTypeId | integer | [version specific] Foreign Key to videoversiontype table |
videoVersionTypeName | text | [version specific] Descriptive name of the version, see videoversiontype table |
VideoVersionTypeItemType | integer | [version specific] Type of the version, see videoversiontype table |
musicvideo_view
A view that joins musicvideo to file and path.
Column Name | Data Type | Description |
---|---|---|
idMVideo | integer | Primary Key |
idFile | integer | Foreign Key to files table |
c00 | text | Title |
c01 | text | Thumb URL |
c02 | text | Thumb URL spoof |
c03 | text | Not Used |
c04 | text | Run time |
c05 | text | Director |
c06 | text | Studios |
c07 | text | Not Used |
c08 | text | Plot |
c09 | text | Album |
c10 | text | Artist |
c11 | text | Genre |
c12 | text | Track |
c13 | text | Path to playable file |
c14 | text | Link to path table for Source folder |
c15 | text | Not Used |
c16 | text | Not Used |
c17 | text | Not Used |
c18 | text | Not Used |
c19 | text | Not Used |
c20 | text | Not Used |
c21 | text | Not Used |
c22 | text | Not Used |
c23 | text | Not Used |
userrating | integer | User Rating |
premiered | text | Premier of Music Video |
strFileName | text | Full name of file including extension |
strPath | text | Path URL |
playCount | integer | # of Times Played |
lastPlayed | text | Date & Time Last Played |
dateAdded | text | Date & Time Added to Library |
resumeTimeInSeconds | double | Time in seconds of bookmark location |
totalTimeInSeconds | double | Time in seconds of the video |
playerState | text |
season_view
A view that joins seasons to the tvshow.
Column Name | Data Type | Description |
---|---|---|
idSeason | integer | Primary Key |
idShow | integer | Foreign key to the tv show table |
Season | integer | Season number |
name | text | User modified Season name |
userrating | integer | User rating for season |
strPath | text | Path to tv show |
showTitle | text | TV Show name |
Plot | text | TV Show plot |
premiered | text | TV Show premiered date |
genre | text | genre |
studio | text | Studio |
mpaa | text | Certification |
episodes | text | Season episode count |
playCount | integer | Number of play times. Each played episode increases the count |
aired | text | Aired date of the first episode in the season |
inProgressCount | integer | Show watched/in progress/total counts in home screen listings and video window listings[1] |
tvshow_view
View that joins tvshow to path. Also produces information about total number of episodes as well as number of watched and unwatched episodes.
Column Name | Data Type | Description |
---|---|---|
idShow | integer | Primary Key |
c00 | text | Show Title |
c01 | text | Show Plot Summary |
c02 | text | Status |
c03 | text | Votes |
c04 | text | Rating |
c05 | text | First Aired |
c06 | text | Thumbnail URL |
c07 | text | [unknown - Spoof Thumbnail URL?] |
c08 | text | Genre |
c09 | text | Original Title |
c10 | text | Episode Guide URL |
c11 | text | Fan Art URL |
c12 | text | SeriesId (when using thetvdb.com scraper) |
c13 | text | Content Rating |
c14 | text | Network |
c15 | text | Title formatted for sorting |
c16 | text | Trailer |
c17 | text | Not Used |
c18 | text | Not Used |
c19 | text | Not Used |
c20 | text | [unknown] |
c21 | text | [unknown] |
c22 | text | [unknown] |
c23 | text | [unknown] |
userrating | integer | User Rating |
duration | integer | Total duration |
idParentPath | integer | |
strPath | text | Path URL |
dateAdded | text | Date & Time Added to Library |
lastPlayed | text | Date & Time Last Played |
totalCount | integer | # of Episodes |
watchedcount | integer | # of Times Played |
totalSeasons | integer | # of Seasons |
rating | float | Rating |
votes | integer | Votes for rating |
rating_type | text | Type of rating |
uniqueid_value | text | Default UniqueID ( default="true" ) |
uniqueid_type | text | Provider of the default UniqueID. eg... <uniqueid type="tmdb" default="true"> |
inProgressCount | integer | Show in progress episodes count along with watched episodes and total episodes count in home screen listings and video window listings.[2] |
tvshowcounts
This table stores the TV Show watched count, total seasons, last played and date added data
Column Name | Data Type | Description |
---|---|---|
idShow | integer | Primary Key |
lastPlayed | text | Date & Time Last Played |
totalCount | integer | # of Episodes |
watchedcount | integer | # of Times Played |
totalSeasons | integer | # of Seasons |
dateAdded | text | Date Added |
inProgressCount | integer | Show in progress episodes count along with watched episodes and total episodes count in home screen listings and video window listings.[3] |
tvshowlinkpath_minview
Joins TV Show to Path
Column Name | Data Type | Description |
---|---|---|
idShow | integer | Primary Key |
idPath | Foreign key to path table |
Return to top |
---|
Tables
The information in the Video Library is organized into the following tables. Several large tables (such as episode, movie, settings, and tvshow) contain the bulk of the information, while most of the others are used to link a long string to a common ID key.
actor
This table stores actor, artist, director, and writer information.
Column Name | Data Type | Description | Movies TV Show TV Episode |
Music Videos |
---|---|---|---|---|
actor_id | integer | Primary Key | ||
name | integer | Name of the actor, artist, director, or writer |
<actor> <name></name> <thumb></thumb> </actor> |
<artist></artist> |
art_urls | text | Image URL |
actor_link
This table links actors to Movies, TV Shows, Episodes, Music Videos and stores role information.
Column Name | Data Type | Description | Movies TV Show TV Episode |
Music Videos |
---|---|---|---|---|
actor_id | integer | Foreign key to actors table | ||
media_id | integer | Foreign key to episode table, tv show table, movie table,music video table | ||
media_type | text | Movie, TV Show, Episode, Music Video | <movie></movie> <tvshow></tvshow> <episodedetails></episodedetails> |
<musicvideo></musicvideo> |
role | text | Role the actor played |
<actor> <role></role> <order></order> </actor> |
n/a |
cast_order | integer | Order actors will be displayed |
art
This table stores URLs for video art metadata.
Column Name | Data Type | Description | Movies | TV Shows | TV Episode | Music Videos |
---|---|---|---|---|---|---|
art_id | integer | Primary Key | ||||
media_id | integer | The id of the media this piece of art is for | ||||
media_type | text | The type of media this art applies to - movie, set, tvshow, season, episode, musicvideo, actor or videoversion | ||||
type | text | The image type - poster, fanart, thumb, banner, landscape, clearlogo, clearart, characterart or discart | ||||
url | text | Image URL |
<thumb aspect="poster" preview=""></thumb> and <fanart> <thumb preview=""></thumb> </fanart> |
<fanart url=""> <thumb dim="" colors="" preview=""></thumb> </fanart> and <actor> <thumb></thumb> </actor> and <thumb aspect="" type="" season=""></thumb> |
<fanart> <thumb preview=""></thumb> </fanart> and <actor> <thumb></thumb> </actor> and <thumb></thumb> |
<art> <fanart></fanart> <poster></poster> </art> |
bookmark
This table stores bookmarks, which are timestamps representing the point in a video where a user stopped playback, an explicit bookmark requested by the user, or an automatically generated episode bookmark.
Column Name | Data Type | Description | Movies TV Show TV Episode |
---|---|---|---|
idBookmark | integer | Primary Key | |
idFile | integer | Foreign key to files table | |
timeInSeconds | double | Time in seconds of bookmark location |
<resume> <position></position> <total></total> </resume> |
totalTimeInSeconds | double | Time in seconds of the video | |
thumbNailImage | text | Thumbnail for bookmark | |
player | text | Player used to store bookmark | |
playerState | text | Player's internal state in XML | |
type | integer | Type of bookmark (0=standard, 1=resume, 2=episode) |
country
This table lists countries.
Column Name | Data Type | Description | Movies |
---|---|---|---|
country_id | integer | Primary Key | |
name | text | Country Name | <country></country> |
country link
This table links countries to movies.
Column Name | Data Type | Description |
---|---|---|
country_id | integer | Foreign key to country table |
media_id | integer | Foreign key to movie table |
media_type | text | Media Class |
director_link
This table links directors to Movies, TV show episodes and Music Videos
Column Name | Data Type | Description |
---|---|---|
actor_id | integer | Foreign key to actors table |
media_id | integer | Foreign key to episode table, movie table,music video table |
media_type | text | Movie, Music Video, Episode |
episode
This table stores television episode information. Information concerning the series is stored in tvshow. To link an episode to its parent series, use tvshowlinkepisode.
Column Name | Data Type | Description | TV Episode |
---|---|---|---|
idEpisode | integer | Primary Key | |
idFile | integer | Foreign key to the files table | |
c00 | text | Episode Title | <title></title> |
c01 | text | Plot Summary | <plot></plot> |
c02 | text | Not Used | |
c03 | text | Link to Rating Table | |
c04 | text | Writer | <credits></credits> |
c05 | text | First Aired | <premiered></premiered> |
c06 | text | Thumbnail URL | <thumb></thumb> |
c07 | text | Thumbnail URL Spoof | |
c08 | text | Not Used | |
c09 | text | Runtime | <runtime></runtime> |
c10 | text | Director | <director></director> |
c11 | text | Production Code |
|
c12 | varchar(24) | Season Number | <season></season> |
c13 | varchar(24) | Episode Number | <episode></episode> |
c14 | text | Original Title | <originaltitle></originaltitle> |
c15 | text | Season Number- Specials Sorting | <displayseason></displayseason> |
c16 | text | Episode Number- Specials Sorting | <displayepisode></displayepisode> |
c17 | varchar(24) | Bookmark | |
c18 | text | Path to episode file | |
c19 | text | Link to Path Table | |
c20 | text | Link to UniqueID Table | |
c21 | text | Not used | |
c22 | text | Not used | |
c23 | text | Not used | |
idShow | integer | Foreign key to the tvshow table | |
userrating | integer | User Rating | <userrating></userrating> |
idSeason | integer | Foreign key to the seasons table |
files
This table stores filenames and links the path.
Column Name | Data Type | Description | Movies TV Shows TV Episodes Music Videos |
---|---|---|---|
idFile | integer | Primary Key | |
idPath | integer | Foreign key to path table | |
strFilename | text | Full name of file including extension | |
playCount | integer | # of Times Played | <playcount></playcount> |
lastPlayed | text | Date & Time Last Played | <lastplayed></lastplayed> |
dateAdded | text | Date & Time Added to Library | <dateadded></dateadded> |
genre
This table stores genre information. For convenience the contents are duplicated in movie and tvshow, so a join isn't necessary.
Column Name | Data Type | Description | Movies TV Shows TV Episodes Music Videos |
---|---|---|---|
genre_id | integer | Primary Key | |
name | text | Genre label | <genre></genre> |
genre_link
This table links genres to movies. (The contents are also stored in movies.c14, though.)
Column Name | Data Type | Description |
---|---|---|
genre_id | integer | Foreign key to genre table |
media_id | integer | Foreign key to movie table, tv show table, music video table |
media_type | text | Movie, Music Video, TV Show |
movie
This table stores movie information.
Column Name | Data Type | Description | Movies |
---|---|---|---|
idMovie | integer | Primary Key | |
idFile | integer | Foreign Key to files table | |
c00 | text | Local Movie Title | <title></title> |
c01 | text | Movie Plot | <plot></plot> |
c02 | text | Movie Plot Outline | <outline></outline> |
c03 | text | Movie Tagline | <tagline></tagline> |
c04 | text | Not Used | |
c05 | text | Link to Rating Table | |
c06 | text | Writers | <credits></credits> |
c07 | text | Not Used | |
c08 | text | Image URL | <thumb aspect="poster" preview=""></thumb> |
c09 | text | Link to uniqueid Table | |
c10 | text | Title formatted for sorting | <sorttitle></sorttitle> |
c11 | text | Runtime | <runtime></runtime> ** |
c12 | text | MPAA Rating | <mpaa></mpaa> |
c13 | text | IMDB Top 250 Ranking | <top250></top250> |
c14 | text | Genre | <genre></genre> |
c15 | text | Director | <director></director> |
c16 | text | Original Movie Title | <originaltitle></originaltitle> |
c17 | text | Thumb URL Spoof | |
c18 | text | Studio | <studio></studio> |
c19 | text | Trailer URL | <trailer></trailer> |
c20 | text | Fanart URLs |
<fanart> <thumb preview=""></thumb> </fanart> |
c21 | text | Country | <country></country> |
c22 | text | Path to playable file | |
c23 | text | Link to path table for Source folder | |
idSet | integer | Foreign Key to sets table | |
userrating | integer | Rating applied by user | <userrating></userrating> |
premiered | text | Date movie premiered | <premiered></premiered> |
Notes | |
---|---|
** | Overwritten on Play |
movielinktvshow
This table links movies to TV shows.
Column Name | Data Type | Description |
---|---|---|
idMovie | integer | Foreign key to movie table |
idShow | integer | Foreign key to tvshow table |
musicvideo
Column Name | Data Type | Description | Music Videos |
---|---|---|---|
idMVideo | integer | Primary Key | |
idFile | integer | Foreign Key to files table | |
c00 | text | Title | <title></title> |
c01 | text | Thumb URL | <thumb preview=""></thumb> |
c02 | text | Thumb URL spoof | |
c03 | text | Not Used | |
c04 | text | Run time | <runtime></runtime> |
c05 | text | Director | <director></director> |
c06 | text | Studios | <studio></studio> |
c07 | text | Not Used | |
c08 | text | Plot | <plot></plot> |
c09 | text | Album | <album></album> |
c10 | text | Artist | <artist></artist> |
c11 | text | Genre | <genre></genre> |
c12 | text | Track | |
c13 | text | Path to playable file | <filenameandpath></filenameandpath> |
c14 | text | Link to path table for Source folder | <basepath></basepath> |
c15 | text | Not Used | |
c16 | text | Not Used | |
c17 | text | Not Used | |
c18 | text | Not Used | |
c19 | text | Not Used | |
c20 | text | Not Used | |
c21 | text | Not Used | |
c22 | text | Not Used | |
c23 | text | Not Used | |
userrating | integer | Rating applied by user | <userrating></userrating> |
premiered | text | Date movie premiered | <premiered></premiered> |
path
This table stores path information.
Column Name | Data Type | Description |
---|---|---|
idPath | integer | Primary Key |
strPath | text | Path URL |
strContent | text | Type of content (tvshows, movies, etc...) |
strScraper | text | addon ID |
strHash | text | Hash |
scanRecursive | integer | Recursive scan setting |
useFolderNames | bool | User folder names setting |
strSettings | text | Custom settings used by scraper |
noUpdate | bool | Exclude path from library update |
exclude | bool | |
allAudio | bool | Skip filename matching for external audio tracks 0 = Disabled 1 = Enabled |
dateAdded | text | |
idParentPath | integer |
rating
This table stores the ratings for TV Shows, Episodes and Movies
Column Name | Data Type | Description | Movies TV Shows TV Episode |
---|---|---|---|
rating_id | integer | Primary Key | |
media_id | integer | Foreign key to episode table, tv show table, movie table, | |
media_type | text | Movies, TV Show, TV Episode | <movie></movie> <tvshow></tvshow> <episodedetails></episodedetails> |
rating_type | text | default | |
rating | float | rating from scraper site |
<ratings> <rating name="default" max="10" default="true"> <value></value> <votes></votes> </rating> </ratings> |
votes | integer | votes from scraper site |
seasons
This table stores the links between tv show and seasons.
Column Name | Data Type | Description | TV Show |
---|---|---|---|
idSeason | integer | Primary Key | |
idShow | integer | Foreign key to tvshow table | |
season | integer | Season number | <season></season> |
name | text | Season Name | <namedseason number="n"></namedseason> n = season number |
userrating | integer | Season level User Rating |
sets
This table stores the id and name for movie sets. Sets are linked to movies in the movie table (idSet column).
Column Name | Data Type | Description | Movies |
---|---|---|---|
idSet | integer | Primary Key | |
strSet | text | The name of the set |
<set> <name></name> <overview></overview> </set> |
strOverview | text | The description of the set |
settings
This table stores settings for individual files.
Column Name | Data Type | Description |
---|---|---|
idFile | integer | Foreign Key to files table |
Deinterlace | bool | Deinterlace |
ViewMode | integer | ViewMode |
ZoomAmount | float | ZoomAmount |
PixelRatio | float | PixelRatio |
VerticalShift | float | |
AudioStream | integer | Selected audio stream |
SubtitleStream | integer | Selected subtitle stream |
SubtitleDelay | float | Amount of delay for subtitles |
SubtitleOn | bool | Enable subtitles |
Brightness | float | Brightness |
Contrast | float | Contrast |
Gamma | float | Gamma |
VolumeAmplification | float | VolumeAmplification |
AudioDelay | float | AudioDelay |
ResumeTime | integer | ResumeTime |
Sharpness | float | Sharpness |
NoiseReduction | float | Noise Reduction |
NonLinStretch | bool | Non Linear Stretch |
PostProcess | bool | Post Processing |
ScalingMethod | integer | Scaling |
DeinterlaceMode | integer | Deinterlace mode |
StereoMode | integer | Stereo Mode |
StereoInvert | bool | Stereo Inversion |
VideoStream | integer | VideoStream |
TonemapMethod | integer | |
TonemapParam | float | |
Orientation | integer | |
CenterMixLevel | integer |
stacktimes
This table stores playing times for files (used for playing multi-file videos).
Column Name | Data Type | Description |
---|---|---|
idFile | integer | Foreign key to files table |
times | text | Times |
streamdetails
This table contains information regarding codecs used, aspect ratios etc
Column Name | Data Type | Description | Movies ** TV Episode ** |
Music Videos ** | Version Added |
---|---|---|---|---|---|
idFile | integer | Foreign Key to files table | |||
iStreamType | integer | 0 = video, 1 = audio, 2 = subtitles | |||
strVideoCodec | text | Video codex (xvid etc) |
<fileinfo> <streamdetails> <video> <codec></codec> <aspect></aspect> <width></width> <height></height> <durationinseconds>5311</durationinseconds> <stereomode></stereomode> </video> </streamdetails> </fileinfo> |
||
fVideoAspect | float | Aspect ratio | |||
iVideoWidth | integer | Width of the video | |||
iVideoHeight | integer | Height of the video | |||
iVideoDuration | integer | Actual runtime in sec | |||
strStereoMode | text | Stereo Mode | |||
strAudioCodec | text | Audio codec (aac, mp3 etc) |
<fileinfo> <streamdetails> <audio> <codec></codec> <channels></channels> <language></language> </audio> </streamdetails> </fileinfo> |
<fileinfo> <streamdetails> <audio> <codec></codec> <channels></channels> <language></language> </audio> </streamdetails> </fileinfo> | |
iAudioChannels | integer | Number of audio channels (2 for stereo, 6 for 5.1 etc) | |||
strAudioLanguage | text | Language of the audio track | |||
strSubtitleLanguage | text | Language of the subtitles |
<fileinfo> <streamdetails> <video> <subtitle> <language>en</language> </subtitle> </video> </streamdetails> </fileinfo> |
||
strVideoLanguage | text | Language of the Video | |||
strHdrType | text | hdr type of the video | <hdrtype></hdrtype> | v20 [4] |
Notes | |
---|---|
** | Settings Will be overwritten on first play |
studio
This table stores studio information.
Column Name | Data Type | Description | Movies TV Shows TV Episodes Music Videos |
---|---|---|---|
studio_id | integer | Primary Key | |
name | text | Studio Label | <studio></studio> |
studio link
This table links studios to movies, music videos and tv shows
Column Name | Data Type | Description |
---|---|---|
studio_id | integer | Foreign key to studio table |
media_id | integer | Foreign key to movie table, tv show table, music video table |
media_type | text | Movie, Music Video, TV Show |
tag
This stores tags.
Column Name | Data Type | Description | Movies TV Shows Music Videos |
---|---|---|---|
tag_id | integer | Primary Key | |
name | integer | Tag | <tag></tag> |
tag_link
This table links tags to various media.
Column Name | Data Type | Description |
---|---|---|
tag_id | integer | Foreign key to tag table |
media_id | integer | Foreign key to a media table |
media_type | text | Media type for link |
tvshow
This table stores information about a television series. Information concerning the shows episodes is stored in episode. To link a TV show to its episodes, use tvshowlinkepisode.
Column Name | Data Type | Description | TV Show |
---|---|---|---|
idShow | integer | Primary Key | |
c00 | text | Show Title | <showtitle></showtitle> |
c01 | text | Show Plot Summary | <plot>plot> |
c02 | text | Status | <status></status> |
c03 | text | Unknown | |
c04 | text | Link to Rating Table | |
c05 | text | First Aired | <premiered></premiered> |
c06 | text | Thumbnail URL | <thumb aspect="" type="" season=""></thumb> |
c07 | text | [unknown - Spoof Thumbnail URL?] | |
c08 | text | Genre | <genre></genre> |
c09 | text | Original Title | <originaltitle></originaltitle> |
c10 | text | Episode Guide URL |
<episodeguide> <url cache=""></url> </episodeguide> |
c11 | text | Fan Art URL |
<fanart url=""> <thumb dim="" colors="" preview=""></thumb> </fanart> |
c12 | text | Unique ID issued by Kodi based on Scraper ID's | |
c13 | text | Content Rating | <mpaa></mpaa> |
c14 | text | Studio | <studio></studio> |
c15 | text | Title formatted for sorting | <sorttitle></sorttitle> |
c16 | text | Trailer | <trailer></trailer> |
c17 | text | Not Used | |
c18 | text | Not Used | |
c19 | text | Not Used | |
c20 | text | [unknown] | |
c21 | text | [unknown] | |
c22 | text | [unknown] | |
c23 | text | [unknown] | |
userrating | integer | Rating applied by user | <userrating></userrating> |
duration | integer | Length of Episodes | <runtime></runtime> |
tvshowlinkpath
This table links a TV show to its path.
Column Name | Data Type | Description |
---|---|---|
idShow | integer | Foreign key to tvshow table |
idPath | integer | Foreign key to path table |
uniqueid
This table holds the UniqueID's for Movies, TV shows and Episodes. Normally the UniqueID's are the ID's used at the scraper sites. For user created nfo files for say, home movies, the ID's are user nominated. Music Videos do not require a UniqueID.
Column Name | Data Type | Description | Movies TV Shows TV Episodes |
---|---|---|---|
uniqueid | integer | Primary Key | |
media_id | integer | Foreign key to a media table | |
media_type | text | Media type for link | <movie></movie> <tvshow></tvshow> <episodedetails></episodedetails> |
value | text | ID at scraper site | <id></id> |
type | text | Scraper site |
version
This table stores database information.
Column Name | Data Type | Description |
---|---|---|
idVersion | integer | Version of database |
idCompressCount | integer | Number of times database has been compressed |
videoversion
This table stores the relations between media "parents" (movies, episodes, ...) and their video assets (versions, extras) for the Video Versions feature. [5]
Column Name | Data Type | Description |
---|---|---|
idFile | integer | The video asset. Foreign Key to files table |
idMedia | integer | id of the media |
media_type | text | The type of media this asset is linked with (v21: the only supported value is "movie") |
itemType | integer | Type of video asset. 0 = VideoVersion; 1 = Extras |
idType | integer | Name of the video asset. Foreign key to the videoversiontype table |
videoversiontype
This table stores the version types/names and extras names for the Video Versions feature.[6]
Column Name | Data Type | Description |
---|---|---|
id | integer | Primary Key |
name | text | Name / type of the version or extra |
owner | integer | 0 = prepopulated by the system; 1 = added by library scan; 2 = added by user |
itemType | integer | type of asset the record applies to. 0 = Version; 1 = Extras |
writer_link
This table links writers stored in the actors table to movies and episodes.
Column Name | Data Type | Description |
---|---|---|
actor_id | integer | Foreign key to actors table |
media_id | integer | Foreign key to a media table |
media_type | text | Media type for link |
References
- ↑ https://github.com/xbmc/xbmc/pull/23658
- ↑ https://github.com/xbmc/xbmc/pull/23658
- ↑ https://github.com/xbmc/xbmc/pull/23658
- ↑ https://github.com/xbmc/xbmc/pull/19983
- ↑ https://github.com/xbmc/xbmc/pulls?page=4&q=is%3Apr+label%3A%22Feature%3A+Video+Versions%2FExtras%22+is%3Aclosed
- ↑ https://github.com/xbmc/xbmc/pulls?page=4&q=is%3Apr+label%3A%22Feature%3A+Video+Versions%2FExtras%22+is%3Aclosed
Return to top |
---|