Difference between revisions of "Record table"
From MythTV Official Wiki
m (typo) |
(Convert FOREIGN KEYS to new template DbRef) |
||
(7 intermediate revisions by 2 users not shown) | |||
Line 2: | Line 2: | ||
The '''record table''' contains the list of recording rules that have been created. The [[scheduler]] uses this information to determine which shows in the [[program table]] should be recorded and on what [[video capture card]] (listed in the [[capturecard table]]). | The '''record table''' contains the list of recording rules that have been created. The [[scheduler]] uses this information to determine which shows in the [[program table]] should be recorded and on what [[video capture card]] (listed in the [[capturecard table]]). | ||
− | + | ;type: documented in '''enum RecordingType''' in the file [https://github.com/MythTV/mythtv/blob/master/mythtv/libs/libmyth/recordingtypes.h libs/libmyth/recordingtypes.h]. | |
− | + | :{| border=1 cellspacing=0 cellpadding=5 | |
− | |||
− | {| border=1 cellspacing=0 cellpadding=5 | ||
| kNotRecording | | kNotRecording | ||
| 0 | | 0 | ||
Line 15: | Line 13: | ||
| 2 | | 2 | ||
|- | |- | ||
− | | kChannelRecord | + | | kChannelRecord (Obsolete) |
| 3 | | 3 | ||
|- | |- | ||
Line 33: | Line 31: | ||
| 8 | | 8 | ||
|- | |- | ||
− | | kFindDailyRecord | + | | kFindDailyRecord (Obsolete) |
| 9 | | 9 | ||
|- | |- | ||
− | | kFindWeeklyRecord | + | | kFindWeeklyRecord (Obsolete) |
| 10 | | 10 | ||
+ | |- | ||
+ | | kTemplateRecord | ||
+ | | 11 | ||
+ | |} | ||
+ | ;dupmethod:[[Duplicate matching]] method, documented in '''enum RecordingDupMethodType''' in the file [https://github.com/MythTV/mythtv/blob/master/mythtv/libs/libmyth/recordingtypes.h libs/libmyth/recordingtypes.h]. | ||
+ | :{| border=1 cellspacing=0 cellpadding=5 | ||
+ | |- | ||
+ | | kDupCheckUnset | ||
+ | | 0x00 | ||
+ | |- | ||
+ | | kDupCheckNone | ||
+ | | 0x01 | ||
+ | |- | ||
+ | | kDupCheckSub | ||
+ | | 0x02 | ||
+ | |- | ||
+ | | kDupCheckDesc | ||
+ | | 0x04 | ||
+ | |- | ||
+ | | kDupCheckSubDesc | ||
+ | | 0x06 | ||
+ | |- | ||
+ | | kDupCheckSubThenDesc | ||
+ | | 0x08 | ||
+ | |} | ||
+ | ;dupin:[[Duplicate matching]] where, documented in '''enum RecordingDupInType''' in the file [https://github.com/MythTV/mythtv/blob/master/mythtv/libs/libmyth/recordingtypes.h libs/libmyth/recordingtypes.h]. | ||
+ | :{| border=1 cellspacing=0 cellpadding=5 | ||
+ | |- | ||
+ | | kDupsUnset | ||
+ | | 0x00 | ||
+ | |- | ||
+ | | kDupsInRecorded | ||
+ | | 0x01 | ||
+ | |- | ||
+ | | kDupsInOldRecorded | ||
+ | | 0x02 | ||
+ | |- | ||
+ | | kDupsInAll | ||
+ | | 0x0F | ||
+ | |- | ||
+ | | kDupsNewEpi | ||
+ | | 0x10 | ||
+ | |} | ||
+ | ;station: Station callsign | ||
+ | ;inetref: Metadata lookup, e.g. <tt>ttvdb.py_12345</tt> or <tt>tmdb3.py_12345</tt> | ||
+ | ;search: Search type, , documented in '''enum RecSearchType''' in the file [https://github.com/MythTV/mythtv/blob/master/mythtv/libs/libmyth/recordingtypes.h libs/libmyth/recordingtypes.h]. | ||
+ | :{| border=1 cellspacing=0 cellpadding=5 | ||
+ | |- | ||
+ | | kNoSearch | ||
+ | | 0 | ||
+ | |- | ||
+ | | kPowerSearch | ||
+ | | 1 | ||
+ | |- | ||
+ | | kTitleSearch | ||
+ | | 2 | ||
+ | |- | ||
+ | | kKeywordSearch | ||
+ | | 3 | ||
+ | |- | ||
+ | | kPeopleSearch | ||
+ | | 4 | ||
+ | |- | ||
+ | | kManualSearch | ||
+ | | 5 | ||
|} | |} | ||
− | + | ;findday: ? | |
+ | ;findtime: time of day | ||
+ | ;findid: represent a <i>days sinf 0000-01-01</i> and is calculates with <tt>(UNIX_TIMESTAMP(program.starttime)/60/60/24)+719528</tt> | ||
+ | ;parentid: ? | ||
+ | ;transcoder: ? | ||
+ | ;avg_delay: ? | ||
== 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" | ||
|- style="background: lightsteelblue" | |- style="background: lightsteelblue" | ||
− | ! Field name | + | ! Field name !! Type !! Null !! Key !! Default !! Extras || Schema-Version |
|- | |- | ||
| recordid || int(10) unsigned || || PRI || NULL || auto_increment | | | recordid || int(10) unsigned || || PRI || NULL || auto_increment | | ||
Line 50: | Line 118: | ||
| type || int(10) unsigned || || MUL || 0 || | | | type || int(10) unsigned || || MUL || 0 || | | ||
|- | |- | ||
− | | chanid || int(10) unsigned || YES || MUL || NULL || | + | | chanid || int(10) unsigned || YES || MUL || NULL || {{DbRef|channel|chanid}} || |
|- | |- | ||
| starttime || time || || || 00:00:00 || | | | starttime || time || || || 00:00:00 || | | ||
Line 65: | Line 133: | ||
|- | |- | ||
| description || varchar(16000) || || || || | | | description || varchar(16000) || || || || | | ||
+ | |- | ||
+ | | season || smallint(5) || || || || || +1278 | ||
+ | |- | ||
+ | | episode || smallint(5) || || || || || +1278 | ||
|- | |- | ||
| category || varchar(64) || || || || | | | category || varchar(64) || || || || | | ||
|- | |- | ||
− | | profile || varchar(128) || || || Default || | + | | profile || varchar(128) || || || Default || {{DbRef|recordingprofiles|name}} || |
|- | |- | ||
| recpriority || int(10) || || || 0 || | | | recpriority || int(10) || || || 0 || | | ||
Line 82: | Line 154: | ||
| endoffset || int(11) || || || 0 || | | | endoffset || int(11) || || || 0 || | | ||
|- | |- | ||
− | | recgroup || varchar(32) || || || Default || | + | | recgroup || varchar(32) || || || Default || {{DbRef|recgrouppassword|recgroup}} || |
|- | |- | ||
| dupmethod || int(11) || || || 6 || | | | dupmethod || int(11) || || || 6 || | | ||
Line 90: | Line 162: | ||
| station || varchar(20) || || || || | | | station || varchar(20) || || || || | | ||
|- | |- | ||
− | | seriesid || varchar( | + | | seriesid || varchar(64) || YES || MUL || NULL || | |
+ | |- | ||
+ | | programid || varchar(64) || YES || MUL || NULL || | | ||
|- | |- | ||
− | | | + | | inetref || varchar(40) || || || || || +1278 |
|- | |- | ||
| search || int(10) unsigned || || MUL || 0 || | | | search || int(10) unsigned || || MUL || 0 || | | ||
Line 107: | Line 181: | ||
|- | |- | ||
| autouserjob4 || tinyint(1) || || || 0 || | | | autouserjob4 || tinyint(1) || || || 0 || | | ||
+ | |- | ||
+ | | autometadata || tinyint(1) || || || 0 || || +1278 | ||
|- | |- | ||
| findday || tinyint(4) || || || 0 || | | | findday || tinyint(4) || || || 0 || | | ||
Line 120: | Line 196: | ||
| transcoder || int(11) || || || 0 || | | | transcoder || int(11) || || || 0 || | | ||
|- | |- | ||
− | | playgroup || varchar(32) || || || Default || | + | | playgroup || varchar(32) || || || Default || {{DbRef|playgroup|name}} || |
|- | |- | ||
− | | prefinput || int(10) || || || 0 || | + | | prefinput || int(10) || || || 0 || {{DbRef|cardinput|cardinputid}} || |
|- | |- | ||
| next_record || datetime || || || NULL || | | | next_record || datetime || || || NULL || | | ||
Line 130: | Line 206: | ||
| last_delete || datetime || || || NULL || | | | last_delete || datetime || || || NULL || | | ||
|- | |- | ||
− | | storagegroup || varchar(32) || || || Default || | + | | storagegroup || varchar(32) || || || Default || {{DbRef|storagegroup|groupname}} || |
|- | |- | ||
| avg_delay || int(11) || || || 100 || | | | avg_delay || int(11) || || || 100 || | | ||
+ | |- | ||
+ | | filter || int(10) unsigned || || || 0 || {{DbRef|recordfilter|filterid}} || +1277 | ||
+ | |- | ||
+ | | recgroupid || smallint(4) || || MUL || 1 || {{DbRef|recgroups|recgroupid}} || +? | ||
|} | |} | ||
[[Category:DB Table]] | [[Category:DB Table]] |
Latest revision as of 13:55, 22 February 2021
Note: The correct title of this article is record table. It appears incorrectly here due to technical restrictions.
The record table contains the list of recording rules that have been created. The scheduler uses this information to determine which shows in the program table should be recorded and on what video capture card (listed in the capturecard table).
- type
- documented in enum RecordingType in the file libs/libmyth/recordingtypes.h.
kNotRecording 0 kSingleRecord 1 kTimeslotRecord 2 kChannelRecord (Obsolete) 3 kAllRecord 4 kWeekslotRecord 5 kFindOneRecord 6 kOverrideRecord 7 kDontRecord 8 kFindDailyRecord (Obsolete) 9 kFindWeeklyRecord (Obsolete) 10 kTemplateRecord 11
- dupmethod
- Duplicate matching method, documented in enum RecordingDupMethodType in the file libs/libmyth/recordingtypes.h.
kDupCheckUnset 0x00 kDupCheckNone 0x01 kDupCheckSub 0x02 kDupCheckDesc 0x04 kDupCheckSubDesc 0x06 kDupCheckSubThenDesc 0x08
- dupin
- Duplicate matching where, documented in enum RecordingDupInType in the file libs/libmyth/recordingtypes.h.
kDupsUnset 0x00 kDupsInRecorded 0x01 kDupsInOldRecorded 0x02 kDupsInAll 0x0F kDupsNewEpi 0x10
- station
- Station callsign
- inetref
- Metadata lookup, e.g. ttvdb.py_12345 or tmdb3.py_12345
- search
- Search type, , documented in enum RecSearchType in the file libs/libmyth/recordingtypes.h.
kNoSearch 0 kPowerSearch 1 kTitleSearch 2 kKeywordSearch 3 kPeopleSearch 4 kManualSearch 5
- findday
- ?
- findtime
- time of day
- findid
- represent a days sinf 0000-01-01 and is calculates with (UNIX_TIMESTAMP(program.starttime)/60/60/24)+719528
- parentid
- ?
- transcoder
- ?
- avg_delay
- ?
Table Description
Field name | Type | Null | Key | Default | Extras | Schema-Version |
---|---|---|---|---|---|---|
recordid | int(10) unsigned | PRI | NULL | |||
type | int(10) unsigned | MUL | 0 | |||
chanid | int(10) unsigned | YES | MUL | NULL | REF channel(chanid) | |
starttime | time | 00:00:00 | ||||
startdate | date | 0000-00-00 | ||||
endtime | time | 00:00:00 | ||||
enddate | date | 0000-00-00 | ||||
title | varchar(128) | MUL | ||||
subtitle | varchar(128) | |||||
description | varchar(16000) | |||||
season | smallint(5) | +1278 | ||||
episode | smallint(5) | +1278 | ||||
category | varchar(64) | |||||
profile | varchar(128) | Default | REF recordingprofiles(name) | |||
recpriority | int(10) | 0 | ||||
autoexpire | int(11) | 0 | ||||
maxepisodes | int(11) | MUL | 0 | |||
maxnewest | int(11) | 0 | ||||
startoffset | int(11) | 0 | ||||
endoffset | int(11) | 0 | ||||
recgroup | varchar(32) | Default | REF recgrouppassword(recgroup) | |||
dupmethod | int(11) | 6 | ||||
dupin | int(11) | 15 | ||||
station | varchar(20) | |||||
seriesid | varchar(64) | YES | MUL | NULL | ||
programid | varchar(64) | YES | MUL | NULL | ||
inetref | varchar(40) | +1278 | ||||
search | int(10) unsigned | MUL | 0 | |||
autotranscode | tinyint(1) | 0 | ||||
autocommflag | tinyint(1) | 0 | ||||
autouserjob1 | tinyint(1) | 0 | ||||
autouserjob2 | tinyint(1) | 0 | ||||
autouserjob3 | tinyint(1) | 0 | ||||
autouserjob4 | tinyint(1) | 0 | ||||
autometadata | tinyint(1) | 0 | +1278 | |||
findday | tinyint(4) | 0 | ||||
findtime | time | 00:00:00 | ||||
findid | int(11) | 0 | ||||
inactive | tinyint(1) | 0 | ||||
parentid | int(11) | 0 | ||||
transcoder | int(11) | 0 | ||||
playgroup | varchar(32) | Default | REF playgroup(name) | |||
prefinput | int(10) | 0 | REF cardinput(cardinputid) | |||
next_record | datetime | NULL | ||||
last_record | datetime | NULL | ||||
last_delete | datetime | NULL | ||||
storagegroup | varchar(32) | Default | REF storagegroup(groupname) | |||
avg_delay | int(11) | 100 | ||||
filter | int(10) unsigned | 0 | REF recordfilter(filterid) | +1277 | ||
recgroupid | smallint(4) | MUL | 1 | REF recgroups(recgroupid) | +? |