
The image type - poster, fanart, thumb, banner, landscape, clearlogo, clearart, characterart or discart The type of media this art applies to - movie, set, tvshow, season, episode, musicvideo or actor The id of the media this piece of art is for This table stores URLs for video art metadata. This table links actors to Movies, TV Shows, Episodes, Music Videos and stores role information.įoreign key to episode table, tv show table, movie table, music video table Name of the actor, artist, director, or writer This table stores actor, artist, director, and writer information. 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. The information in the Video Library is organized into the following tables. This table stores the TV Show watched count, total seasons, last played and date added data Also produces information about total number of episodes as well as number of watched and unwatched episodes. 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.Ī view that joins episode to file and tvshow (through tvshowlinkepisode) and path.Ī view that joins movie to file and path.Ī view that joins musicvideo to file and path. Views are standard queries, often long or complicated queries saved in the database for convenience. We strongly urge that you do not interfere with them, unless you have knowledge and experience with database designs. Warning: The databases are critical components of Kodi. The current stable release of Kodi is using the following version of the database: It is used in the Videos portion of Kodi. This database contains all information concerning TV shows, movies, and music videos.
