Difference between revisions of "Program table"
From MythTV Official Wiki
m (table style) |
m (table style) |
||
Line 1: | Line 1: | ||
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. | 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. | ||
− | + | == Table Description == | |
− | == | + | {| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5" |
− | {| cellpadding=" | + | |- style="background: lightsteelblue" |
− | |- | + | ! Field name !! Type !! Null !! Key !! Default !! Extras |
− | !Field | + | |- |
− | |- | ||
|| chanid || int(10) unsigned || || PRI || 0 || | || chanid || int(10) unsigned || || PRI || 0 || | ||
− | |- | + | |- |
|| starttime || datetime || || PRI || 0000-00-00 00:00:00 || | || starttime || datetime || || PRI || 0000-00-00 00:00:00 || | ||
− | |- | + | |- |
|| endtime || datetime || || MUL || 0000-00-00 00:00:00 || | || endtime || datetime || || MUL || 0000-00-00 00:00:00 || | ||
− | |- | + | |- |
|| title || varchar(128) || || MUL || || | || title || varchar(128) || || MUL || || | ||
− | |- | + | |- |
|| subtitle || varchar(128) || || || || | || subtitle || varchar(128) || || || || | ||
− | |- | + | |- |
|| description || text || || || || | || description || text || || || || | ||
− | |- | + | |- |
|| category || varchar(64) || || || || | || category || varchar(64) || || || || | ||
− | |- | + | |- |
|| category_type || varchar(64) || || || || | || category_type || varchar(64) || || || || | ||
− | |- | + | |- |
|| airdate || year(4) || || || 0000 || | || airdate || year(4) || || || 0000 || | ||
− | |- | + | |- |
|| stars || float || || || 0 || | || stars || float || || || 0 || | ||
− | |- | + | |- |
|| previouslyshown || tinyint(4) || || || 0 || | || previouslyshown || tinyint(4) || || || 0 || | ||
− | |- | + | |- |
|| title_pronounce || varchar(128) || || MUL || || | || title_pronounce || varchar(128) || || MUL || || | ||
− | |- | + | |- |
|| stereo || tinyint(1) || || || 0 || | || stereo || tinyint(1) || || || 0 || | ||
− | |- | + | |- |
|| subtitled || tinyint(1) || || || 0 || | || subtitled || tinyint(1) || || || 0 || | ||
− | |- | + | |- |
|| hdtv || tinyint(1) || || || 0 || | || hdtv || tinyint(1) || || || 0 || | ||
− | |- | + | |- |
|| closecaptioned || tinyint(1) || || || 0 || | || closecaptioned || tinyint(1) || || || 0 || | ||
− | |- | + | |- |
|| partnumber || int(11) || || || 0 || | || partnumber || int(11) || || || 0 || | ||
− | |- | + | |- |
|| parttotal || int(11) || || || 0 || | || parttotal || int(11) || || || 0 || | ||
− | |- | + | |- |
|| seriesid || varchar(12) || || MUL || || | || seriesid || varchar(12) || || MUL || || | ||
− | |- | + | |- |
|| originalairdate || date || YES || || NULL || | || originalairdate || date || YES || || NULL || | ||
− | |- | + | |- |
|| showtype || varchar(30) || || || || | || showtype || varchar(30) || || || || | ||
− | |- | + | |- |
|| colorcode || varchar(20) || || || || | || colorcode || varchar(20) || || || || | ||
− | |- | + | |- |
|| syndicatedepisodenumber|| varchar(20) || || || || | || syndicatedepisodenumber|| varchar(20) || || || || | ||
− | |- | + | |- |
|| programid || varchar(20) || || MUL || || | || programid || varchar(20) || || MUL || || | ||
− | |- | + | |- |
|| manualid || int(10) unsigned || || PRI || 0 || | || manualid || int(10) unsigned || || PRI || 0 || | ||
− | |- | + | |- |
|| generic || tinyint(1) || YES || || 0 || | || generic || tinyint(1) || YES || || 0 || | ||
− | |- | + | |- |
|| listingsource || int(11) || || || 0 || | || listingsource || int(11) || || || 0 || | ||
− | |- | + | |- |
|| first || tinyint(1) || || || 0 || | || first || tinyint(1) || || || 0 || | ||
− | |- | + | |- |
|| last || tinyint(1) || || || 0 || | || last || tinyint(1) || || || 0 || | ||
|- | |- |
Revision as of 23:09, 15 March 2007
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.
Table Description
Field name | Type | Null | Key | Default | Extras |
---|---|---|---|---|---|
chanid | int(10) unsigned | PRI | 0 | ||
starttime | datetime | PRI | 0000-00-00 00:00:00 | ||
endtime | datetime | MUL | 0000-00-00 00:00:00 | ||
title | varchar(128) | MUL | |||
subtitle | varchar(128) | ||||
description | text | ||||
category | varchar(64) | ||||
category_type | varchar(64) | ||||
airdate | year(4) | 0000 | |||
stars | float | 0 | |||
previouslyshown | tinyint(4) | 0 | |||
title_pronounce | varchar(128) | MUL | |||
stereo | tinyint(1) | 0 | |||
subtitled | tinyint(1) | 0 | |||
hdtv | tinyint(1) | 0 | |||
closecaptioned | tinyint(1) | 0 | |||
partnumber | int(11) | 0 | |||
parttotal | int(11) | 0 | |||
seriesid | varchar(12) | MUL | |||
originalairdate | date | YES | NULL | ||
showtype | varchar(30) | ||||
colorcode | varchar(20) | ||||
syndicatedepisodenumber | varchar(20) | ||||
programid | varchar(20) | MUL | |||
manualid | int(10) unsigned | PRI | 0 | ||
generic | tinyint(1) | YES | 0 | ||
listingsource | int(11) | 0 | |||
first | tinyint(1) | 0 | |||
last | tinyint(1) | 0 |