Recordedprogram table
From MythTV Official Wiki
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.