Difference between revisions of "Program table"
From MythTV Official Wiki
m (table style) |
m (videoprop,programid) |
||
(4 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | The '''program''' | + | {{Wrongtitle|program table}} |
+ | The '''program table''' contains show listing information from each of the listing providers contained within the [[videosource table]]. [[mythfilldatabase]] is responsible for managing the data in this table. | ||
+ | |||
+ | Up to date with schema revision 1244. | ||
== Table Description == | == Table Description == | ||
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5" | {| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5" | ||
Line 5: | Line 8: | ||
! Field name !! Type !! Null !! Key !! Default !! Extras | ! Field name !! Type !! Null !! Key !! Default !! Extras | ||
|- | |- | ||
− | || chanid || int(10) unsigned || | + | || chanid || int(10) unsigned || NO || PRI || 0 || REFERENCES [[channel table|channel]](chanid) |
|- | |- | ||
− | || starttime || datetime || | + | || starttime || datetime || NO || PRI || 0000-00-00 00:00:00 || |
|- | |- | ||
− | || endtime || datetime || | + | || endtime || datetime || NO || MUL || 0000-00-00 00:00:00 || |
|- | |- | ||
− | || title || varchar(128) || | + | || title || varchar(128) || NO || MUL || || |
|- | |- | ||
− | || subtitle || varchar(128) || | + | || subtitle || varchar(128) || NO || || || |
|- | |- | ||
− | || description || text || | + | || description || text || NO || || || |
|- | |- | ||
− | || category || varchar(64) || | + | || category || varchar(64) || NO || || || |
|- | |- | ||
− | || category_type || varchar(64) || | + | || category_type || varchar(64) || NO || || || |
|- | |- | ||
− | || airdate || year(4) || | + | || airdate || year(4) || NO || || 0000 || |
|- | |- | ||
− | || stars || float || | + | || stars || float || NO || || 0 || |
|- | |- | ||
− | || previouslyshown || tinyint(4) || | + | || previouslyshown || tinyint(4) || NO || || 0 || |
|- | |- | ||
− | || title_pronounce || varchar(128) || | + | || title_pronounce || varchar(128) || NO || MUL || || |
|- | |- | ||
− | || stereo || tinyint(1) || | + | || stereo || tinyint(1) || NO || || 0 || |
|- | |- | ||
− | || subtitled || tinyint(1) || | + | || subtitled || tinyint(1) || NO || || 0 || |
|- | |- | ||
− | || hdtv || tinyint(1) || | + | || hdtv || tinyint(1) || NO || || 0 || |
|- | |- | ||
− | || closecaptioned || tinyint(1) || | + | || closecaptioned || tinyint(1) || NO || || 0 || |
|- | |- | ||
− | || partnumber || int(11) || | + | || partnumber || int(11) || NO || || 0 || |
|- | |- | ||
− | || parttotal || int(11) || | + | || parttotal || int(11) || NO || || 0 || |
|- | |- | ||
− | || seriesid || varchar(12) || | + | || seriesid || varchar(12) || NO || MUL || || |
|- | |- | ||
|| originalairdate || date || YES || || NULL || | || originalairdate || date || YES || || NULL || | ||
|- | |- | ||
− | || showtype || varchar(30) || | + | || showtype || varchar(30) || NO || || || |
|- | |- | ||
− | || colorcode || varchar(20) || | + | || colorcode || varchar(20) || NO || || || |
|- | |- | ||
− | || syndicatedepisodenumber|| varchar(20) || | + | || syndicatedepisodenumber|| varchar(20) || NO || || || |
|- | |- | ||
− | || programid || varchar( | + | || programid || varchar(64) || NO || MUL || || |
|- | |- | ||
− | || manualid || int(10) unsigned || | + | || manualid || int(10) unsigned || NO || PRI || 0 || |
|- | |- | ||
|| generic || tinyint(1) || YES || || 0 || | || generic || tinyint(1) || YES || || 0 || | ||
|- | |- | ||
− | || listingsource || int(11) || | + | || listingsource || int(11) || NO || || 0 || |
|- | |- | ||
− | || first || tinyint(1) || | + | || first || tinyint(1) || NO || || 0 || |
|- | |- | ||
− | || last || tinyint(1) || | + | || last || tinyint(1) || NO || || 0 || |
+ | |- | ||
+ | || audioprop || 'STEREO','MONO','SURROUND','DOLBY','HARDHEAR','VISUALIMPAIR' || NO || || NULL || | ||
+ | |- | ||
+ | || subtitletypes || 'HARDHEAR','NORMAL','ONSCREEN','SIGNED' || NO || || NULL || | ||
+ | |- | ||
+ | || videoprop || 'HDTV','WIDESCREEN','AVC'','720','1080','DAMAGED' || NO || || NULL || | ||
|- | |- | ||
|} | |} | ||
[[Category:DB Table]] | [[Category:DB Table]] |
Latest revision as of 13:59, 22 February 2014
Note: The correct title of this article is program table. It appears incorrectly here due to technical restrictions.
The program table contains show listing information from each of the listing providers contained within the videosource table. mythfilldatabase is responsible for managing the data in this table.
Up to date with schema revision 1244.
Table Description
Field name | Type | Null | Key | Default | Extras |
---|---|---|---|---|---|
chanid | int(10) unsigned | NO | PRI | 0 | REFERENCES channel(chanid) |
starttime | datetime | NO | PRI | 0000-00-00 00:00:00 | |
endtime | datetime | NO | MUL | 0000-00-00 00:00:00 | |
title | varchar(128) | NO | MUL | ||
subtitle | varchar(128) | NO | |||
description | text | NO | |||
category | varchar(64) | NO | |||
category_type | varchar(64) | NO | |||
airdate | year(4) | NO | 0000 | ||
stars | float | NO | 0 | ||
previouslyshown | tinyint(4) | NO | 0 | ||
title_pronounce | varchar(128) | NO | MUL | ||
stereo | tinyint(1) | NO | 0 | ||
subtitled | tinyint(1) | NO | 0 | ||
hdtv | tinyint(1) | NO | 0 | ||
closecaptioned | tinyint(1) | NO | 0 | ||
partnumber | int(11) | NO | 0 | ||
parttotal | int(11) | NO | 0 | ||
seriesid | varchar(12) | NO | MUL | ||
originalairdate | date | YES | NULL | ||
showtype | varchar(30) | NO | |||
colorcode | varchar(20) | NO | |||
syndicatedepisodenumber | varchar(20) | NO | |||
programid | varchar(64) | NO | MUL | ||
manualid | int(10) unsigned | NO | PRI | 0 | |
generic | tinyint(1) | YES | 0 | ||
listingsource | int(11) | NO | 0 | ||
first | tinyint(1) | NO | 0 | ||
last | tinyint(1) | NO | 0 | ||
audioprop | 'STEREO','MONO','SURROUND','DOLBY','HARDHEAR','VISUALIMPAIR' | NO | NULL | ||
subtitletypes | 'HARDHEAR','NORMAL','ONSCREEN','SIGNED' | NO | NULL | ||
videoprop | 'HDTV','WIDESCREEN','AVC,'720','1080','DAMAGED' | NO | NULL |