Difference between revisions of "Recorded table"
From MythTV Official Wiki
m |
|||
| Line 1: | Line 1: | ||
{{Wrongtitle|recorded table}} | {{Wrongtitle|recorded table}} | ||
| − | The '''recorded table''', lists programs which have already been recorded (or recorded and then transcoded), translating the [[Internal Filenames]] into something safe for human consumption. | + | The '''recorded table''', lists programs which have already been recorded(or recorded and then transcoded) and are still available for viewing, translating the [[Internal Filenames]] into something safe for human consumption. |
== Table Description == | == Table Description == | ||
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5" | {| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5" | ||
Revision as of 12:03, 6 November 2007
Note: The correct title of this article is recorded table. It appears incorrectly here due to technical restrictions.
The recorded table, lists programs which have already been recorded(or recorded and then transcoded) and are still available for viewing, translating the Internal Filenames into something safe for human consumption.
Table Description
| Field name | Type | Null | Key | Default | Extras |
|---|---|---|---|---|---|
| chanid | int(10) unsigned | PRI | 0 | ||
| starttime | timestamp(14) | YES | PRI | NULL | |
| endtime | timestamp(14) | YES | MUL | 00000000000000 | |
| title | varchar(128) | ||||
| subtitle | varchar(128) | ||||
| description | text | ||||
| category | varchar(64) | ||||
| hostname | varchar(255) | ||||
| bookmark | tinyint(1) | 0 | |||
| editing | int(10) unsigned | 0 | |||
| cutlist | tinyint(1) | 0 | |||
| autoexpire | int(11) | 0 | |||
| commflagged | int(10) unsigned | 0 | |||
| recgroup | varchar(32) | Default | |||
| recordid | int(11) | YES | NULL | ||
| seriesid | varchar(12) | MUL | |||
| programid | varchar(12) | MUL |
Fields
- recgroup is the name of the recording group this recording belongs to. This relates to the recgroup field of the recgrouppassword table.
