ISD 820 Knowledge Base

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

===== 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

ISD 820 Knowledge Base

User Tools

Site Tools

Page Tools