Recordedprogram table

From MythTV Official Wiki
Revision as of 13:56, 22 February 2014 by Pmhahn (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Important.png Note: The correct title of this article is recordedprogram table. It appears incorrectly here due to technical restrictions.

The recordedprogram table stores program detail information about entries in the recorded table. This information is copied from the program table.

Table Description

Field name Type Null Key Default Extras
chanid int(10) unsigned PRI 0 REFERENCES recorded(chanid,starttime)
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 unsigned 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) NULL MUL NULL
originalairdate date NULL NULL
showtype varchar(30)
colorcode varchar(20)
syndicatedepisodenumber varchar(20)
programid varchar(64) NULL MUL NULL
manualid int(10) unsigned PRI 0
generic tinyint(1) NULL 0
listingsource int(11) 0
first tinyint(1) 0
last tinyint(1) 0
audioprop 'STEREO','MONO','SURROUND','DOLBY','HARDHEAR','VISUALIMPAIR' NULL
subtitletypes 'HARDHEAR','NORMAL','ONSCREEN','SIGNED' NULL
videoprop 'HDTV','WIDESCREEN','AVC','720','1080','DAMAGED' NULL

Fields

  • chanid along with starttime relate to unique entries in the recorded table.