User Tools
hxmc:video75schema
This is an old revision of the document!
Table of Contents
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?
hxmc/video75schema.1382097659.txt.gz · Last modified: 2013/10/18 07:00 by tschulz
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
