User Tools
hxmc:video75schema
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
hxmc/video75schema.txt · Last modified: 2013/10/19 10:32 by tschulz
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
