Recorded table
From MythTV Official Wiki
recorded
The 'recorded' table, unsurprisingly, lists programs which have already been recorded (or recorded and then transcoded), translating the Internal Filenames into something safe for human consumption.
+-------------+------------------+------+-----+----------------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+----------------+-------+ | 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 | varchar(128) | YES | | NULL | | | editing | int(10) unsigned | | | 0 | | | cutlist | text | YES | | NULL | | | 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 | | | +-------------+------------------+------+-----+----------------+-------+