Databases/MyVideos
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 |
---|