User Tools
hxmc:video75schema
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
hxmc:video75schema [2013/10/18 09:14] tschulz [movie] |
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 ==== | ||
| Line 58: | Line 58: | ||
| * **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 | ||
hxmc/video75schema.1382105658.txt.gz · Last modified: 2013/10/18 09:14 by tschulz
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
