Program table

From MythTV Official Wiki
Jump to: navigation, search

Important.png 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