Databases/MyVideos: Difference between revisions
(Create Page) |
(v21 Updates) |
||
(12 intermediate revisions by the same user 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 | ||
'''{{red|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.}}''' | |||
Line 18: | Line 20: | ||
== episodeview == | |||
== episodeview == | |||
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 27: | 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 33: | 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 43: | 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 63: | 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 77: | 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 106: | Line 107: | ||
|- | |- | ||
|totalTimeInSeconds || double || Length of video | |totalTimeInSeconds || double || Length of video | ||
|- | |||
|playerState || text || | |||
|- | |- | ||
|rating || float || Rating | |rating || float || Rating | ||
Line 113: | 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"> | ||
|} | |} | ||
== movieview == | == movieview == | ||
A view that joins movie to file and path. | A view that joins movie to file and path. | ||
Line 128: | 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]] | ||
|- | |- | ||
|c00 || text || Local Movie Title | |c00 || text || Local Movie Title | ||
Line 138: | 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 164: | 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 172: | 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 201: | Line 204: | ||
|- | |- | ||
|totalTimeInSeconds || double || Length of video | |totalTimeInSeconds || double || Length of video | ||
|- | |||
|playerState || text || | |||
|- | |- | ||
|rating || float || Rating | |rating || float || Rating | ||
Line 208: | 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 || | |uniqueid_type || text || Provider of the default UniqueID. eg... <uniqueid type="tmdb" default="true"> | ||
|- | |||
|hasVideoVersions || integer || 0 = Not part of a VideoVersion; 1 = Part of a VideoVersion set | |||
|- | |||
|hasVideoExtras || integer || 0 = No Extras; 1 = Contains Extras | |||
|- | |||
|isDefautlVersion || integer || 0 = Not the default / parent version; 1 = Default / parent version | |||
|- | |||
|videoVersionIdFile || integer || Foreign Key to [[Databases/MyVideos#files|files table]] | |||
|- | |||
|videoVersionTypeId || integer || Foreign Key to videoversiontype table | |||
|- | |||
|videoVersionTypeName || text || Descriptive name of version type from videoversiontype table | |||
|- | |||
|VideoVersionTypeItemType || integer || | |||
|} | |} | ||
== musicvideoview == | == musicvideoview == | ||
A view that joins musicvideo to file and path. | A view that joins musicvideo to file and path. | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 222: | 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 289: | 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> | |||
|} | |} | ||
== tvshowview == | == tvshowview == | ||
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 332: | 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 352: | Line 414: | ||
|duration || integer || Total duration | |duration || integer || Total duration | ||
|- | |- | ||
|idParentPath || integer || | |idParentPath || integer || | ||
|- | |- | ||
|strPath || text || Path URL | |strPath || text || Path URL | ||
Line 372: | 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 395: | 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 429: | 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 437: | 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 457: | Line 536: | ||
== art == | == art == | ||
This table stores URLs for video art metadata. | This table stores URLs for video art metadata. | ||
Line 511: | Line 590: | ||
== 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 520: | Line 599: | ||
|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 529: | Line 608: | ||
</resume> | </resume> | ||
|- | |- | ||
|totalTimeInSeconds || | |totalTimeInSeconds || double || Time in seconds of the video | ||
|- | |- | ||
|thumbNailImage || text || Thumbnail for bookmark || | |thumbNailImage || text || Thumbnail for bookmark || | ||
Line 542: | Line 621: | ||
== country == | == country == | ||
This table lists countries. | This table lists countries. | ||
Line 555: | Line 634: | ||
== country link == | == country link == | ||
This table links countries to movies. | This table links countries to movies. | ||
Line 561: | Line 640: | ||
! 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 576: | Line 655: | ||
! 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 585: | Line 664: | ||
== 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 594: | Line 673: | ||
|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 600: | Line 679: | ||
|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 610: | Line 689: | ||
|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 644: | Line 723: | ||
|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 661: | Line 740: | ||
|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 674: | Line 753: | ||
== 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 687: | Line 766: | ||
== 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 693: | Line 772: | ||
! 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 702: | Line 781: | ||
== movie == | == movie == | ||
This table stores movie information. | This table stores movie information. | ||
Line 711: | Line 790: | ||
|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 721: | Line 800: | ||
|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 747: | Line 826: | ||
|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 759: | Line 838: | ||
</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 779: | Line 858: | ||
== movielinktvshow == | == movielinktvshow == | ||
This table links movies to TV shows. | This table links movies to TV shows. | ||
Line 785: | Line 864: | ||
! 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 799: | Line 878: | ||
|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 815: | Line 894: | ||
|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 825: | Line 904: | ||
|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 868: | Line 947: | ||
|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 881: | Line 960: | ||
|- | |- | ||
|exclude || bool || | |exclude || bool || | ||
|- | |||
|allAudio || bool || Skip filename matching for external audio tracks<br>0 = Disabled<br>1 = Enabled | |||
|- | |- | ||
|dateAdded || text || | |dateAdded || text || | ||
Line 889: | Line 970: | ||
== 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 898: | Line 979: | ||
|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 918: | Line 999: | ||
== seasons == | == seasons == | ||
This table stores the links between tv show and seasons. | This table stores the links between tv show and seasons. | ||
Line 926: | Line 1,007: | ||
|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 937: | Line 1,018: | ||
== 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 958: | Line 1,039: | ||
== settings == | == settings == | ||
This table stores settings for individual files. | This table stores settings for individual files. | ||
Line 964: | Line 1,045: | ||
! 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 984: | Line 1,065: | ||
|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,025: | Line 1,094: | ||
|- | |- | ||
|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,035: | Line 1,112: | ||
! 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,042: | Line 1,119: | ||
== streamdetails == | == streamdetails == | ||
This table contains information regarding codecs used, aspect ratios etc | This table contains information regarding codecs used, aspect ratios etc | ||
Line 1,049: | Line 1,126: | ||
! 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,070: | Line 1,148: | ||
| 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,076: | Line 1,154: | ||
|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,090: | Line 1,167: | ||
<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,102: | Line 1,177: | ||
<language></language> | <language></language> | ||
</audio> | </audio> | ||
</streamdetails> | </streamdetails> | ||
</fileinfo> | </fileinfo> | ||
Line 1,123: | Line 1,197: | ||
| 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,134: | Line 1,210: | ||
== studio == | == studio == | ||
This table stores studio information. | This table stores studio information. | ||
Line 1,147: | Line 1,223: | ||
== 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,153: | Line 1,229: | ||
! 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,162: | Line 1,238: | ||
== tag == | == tag == | ||
This stores tags. | This stores tags. | ||
Line 1,175: | Line 1,251: | ||
== | == tag_link == | ||
This table links tags to various media. | This table links tags to various media. | ||
Line 1,181: | Line 1,257: | ||
! 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,190: | Line 1,266: | ||
== 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,206: | Line 1,282: | ||
|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,228: | Line 1,304: | ||
</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,236: | Line 1,312: | ||
|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,254: | Line 1,330: | ||
|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,265: | Line 1,339: | ||
! 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,291: | Line 1,365: | ||
== version == | == version == | ||
This table stores database information. | This table stores database information. | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 1,303: | Line 1,377: | ||
== writer_link == | == videoversion == | ||
This table stores the versioning data 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 || Foreign Key to [[Databases/MyVideos#files|files table]] | |||
|- | |||
|idMedia || integer || Foreign key to a media table | |||
|- | |||
|media_type || text || Media type for link | |||
|- | |||
|itemType || integer || 0 = VideoVersion; 1 = Extras | |||
|- | |||
|idType || integer || Foreign key to a videoversiontype table | |||
|} | |||
== videoversiontype == | |||
This table stores the versioning data 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 || Description of version type | |||
|- | |||
|owner || integer || 0 = {{Kodi}} default; 1 = User added | |||
|- | |||
|idType || integer || 0 = default VideoVersion type; 1 = Extras; 2 = User added VideoVersion type | |||
|} | |||
== 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,309: | Line 1,417: | ||
! 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,315: | Line 1,423: | ||
|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]] |
Revision as of 03:39, 22 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.
episodeview
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"> |
movieview
A view that joins movie to file and path.
Column Name | Data Type | Description |
---|---|---|
idMovie | integer | Primary Key |
idFile | integer | Foreign Key to files table |
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 = Not part of a VideoVersion; 1 = Part of a VideoVersion set |
hasVideoExtras | integer | 0 = No Extras; 1 = Contains Extras |
isDefautlVersion | integer | 0 = Not the default / parent version; 1 = Default / parent version |
videoVersionIdFile | integer | Foreign Key to files table |
videoVersionTypeId | integer | Foreign Key to videoversiontype table |
videoVersionTypeName | text | Descriptive name of version type from videoversiontype table |
VideoVersionTypeItemType | integer |
musicvideoview
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] |
tvshowview
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 or actor | ||||
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 versioning data for the Video Versions feature. [5]
Column Name | Data Type | Description |
---|---|---|
idFile | integer | Foreign Key to files table |
idMedia | integer | Foreign key to a media table |
media_type | text | Media type for link |
itemType | integer | 0 = VideoVersion; 1 = Extras |
idType | integer | Foreign key to a videoversiontype table |
videoversiontype
This table stores the versioning data for the Video Versions feature.[6]
Column Name | Data Type | Description |
---|---|---|
id | integer | Primary Key |
name | text | Description of version type |
owner | integer | 0 = Kodi default; 1 = User added |
idType | integer | 0 = default VideoVersion type; 1 = Extras; 2 = User added VideoVersion type |
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 |
---|