This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
hxmc:video75schema [2013/10/18 07:00] tschulz created |
hxmc:video75schema [2013/10/19 10:32] (current) tschulz [Episode] |
||
---|---|---|---|
Line 2: | Line 2: | ||
==== tvshow ==== | ==== tvshow ==== | ||
- | * idShow: primary key | + | * **idShow: primary key** |
- | * c00: Show title | + | * **c00: Show title** |
- | * c01: Description | + | * **c01: Description** |
- | * c04: Amazon Rating | + | * **c04: Amazon Rating** |
- | * c05: Premier Date | + | * **c05: Premier Date** |
- | * c06: thumbnail url | + | * **c06: thumbnail url** |
- | * c08: genre | + | * **c08: genre** |
- | * c10: episode guide url | + | * **c10: episode guide url** |
- | * c11: fanart url | + | * **c11: fanart url** |
* c12: ? | * c12: ? | ||
- | * c14: Broadcast Company | + | * **c14: Broadcast Company** |
- | * c15: media source | + | * **c15: media source** |
==== Episode ==== | ==== Episode ==== | ||
- | * IdEpisode: primary key | + | * **idEpisode: primary key** |
- | * IdFile: fk file table | + | * **idFile: fk file table** |
- | * c00: episode title | + | * **c00: episode title** |
- | * c01: episode description | + | * **c01: episode description** |
- | * c03: amazon rating | + | * **c03: amazon rating** |
- | * c04: Director or Actor | + | * **c04: Director or Actor** |
- | * c05: Air date | + | * **c05: Air date** |
- | * c06: thumbnail url | + | * **c06: thumbnail url** |
- | * c10: Director or Actor | + | * **c10: Director or Actor** |
- | * c12: Season number | + | * **c12: Season number** |
- | * c13: episode number | + | * **c13: episode number** |
- | * c18: media source | + | * **c18: media source** |
* c19: ? | * c19: ? | ||
* c20: ? | * c20: ? | ||
- | * idShow: fk tvshow table | + | * **idShow: fk tvshow table** |
==== movie ==== | ==== movie ==== | ||
- | * idMovie: primary key | + | * **idMovie: primary key** |
- | * idFile: fk file table | + | * **idFile: fk file table** |
- | * c00: movie title | + | * **c00: movie title** |
- | * c01: movie description | + | * **c01: movie description** |
- | * c03: tagline | + | * **c03: tagline** |
* c04: ? really big number | * c04: ? really big number | ||
- | * c05: amazon rating | + | * **c05: amazon rating** |
- | * c06: Writer | + | * **c06: Writer** |
- | * c07: release year | + | * **c07: release year** |
- | * c08: thumbnail url | + | * **c08: thumbnail url** |
* c09: ? | * c09: ? | ||
* c11: ? | * c11: ? | ||
- | * c12: movie content rating | + | * **c12: movie content rating** |
* c13: ? | * c13: ? | ||
- | * c14: genre | + | * **c14: genre** |
- | * c15: Director | + | * **c15: Director** |
* c16: Title again? | * c16: Title again? | ||
- | * c18: movie studio | + | * **c18: movie studio** |
- | * c19: trailer url | + | * **c19: trailer url** |
- | * c20: fanart url | + | * **c20: fanart url** |
- | * c21: country filmed ? | + | * **c21: country filmed ?** |
- | * c22: media source | + | * **c22: media source** |
* c23: ? | * c23: ? | ||
- | * idSet: fk set table? | + | * **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 |