===== MyVideos75 Schema ===== ==== tvshow ==== * **idShow: primary key** * **c00: Show title** * **c01: Description** * **c04: Amazon Rating** * **c05: Premier Date** * **c06: thumbnail url** * **c08: genre** * **c10: episode guide url** * **c11: fanart url** * c12: ? * **c14: Broadcast Company** * **c15: media source** ==== Episode ==== * **idEpisode: primary key** * **idFile: fk file table** * **c00: episode title** * **c01: episode description** * **c03: amazon rating** * **c04: Director or Actor** * **c05: Air date** * **c06: thumbnail url** * **c10: Director or Actor** * **c12: Season number** * **c13: episode number** * **c18: media source** * c19: ? * c20: ? * **idShow: fk tvshow table** ==== movie ==== * **idMovie: primary key** * **idFile: fk file table** * **c00: movie title** * **c01: movie description** * **c03: tagline** * c04: ? really big number * **c05: amazon rating** * **c06: Writer** * **c07: release year** * **c08: thumbnail url** * c09: ? * c11: ? * **c12: movie content rating** * c13: ? * **c14: genre** * **c15: Director** * c16: Title again? * **c18: movie studio** * **c19: trailer url** * **c20: fanart url** * **c21: country filmed ?** * **c22: media source** * c23: ? * **idSet: fk set table?** ==== Path ==== * **idPath: pk** * **strPath: path** * strContent: video type * strScraper: scrapper provider * strHash * scanRecursive * useFolderNames * strSettings * noUpdate * exclude * dateAdded ==== Files ==== * **idFile: pk** * **idPath: fk (path table)** * **strFilename: filename** * playCount * lastPlayed * dateAdded