Table of Contents
MyVideos75 Schema
tvshow
Episode
movie
Path
Files
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