Program table

From MythTV Official Wiki
Revision as of 20:10, 3 March 2007 by Malban (talk | contribs) (table style)

Jump to: navigation, search

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.

0.20-fixes Version

Field Type Null Key Default Extra
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