Difference between revisions of "Recordmatch table"
From MythTV Official Wiki
(FK, +findid) |
|||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
{{Wrongtitle|recordmatch table}} | {{Wrongtitle|recordmatch table}} | ||
== Table Description == | == Table Description == | ||
| + | 13:33, 22 February 2014 (UTC) This is my guess, correct this if you know better! | ||
| + | |||
| + | This table is used by the scheduler to find program candidates for recording. | ||
| + | # It is regularly populated by checking all [[program table|programs]] against the [[record table|recording rules]]. | ||
| + | # Then duplicates are eliminated. | ||
| + | |||
{| 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 !! Type | + | ! Field name !! Type !! Null !! Key !! Default !! Extras !! Schema-Version |
|- | |- | ||
| − | || recordid || int(10) unsigned | + | || recordid || int(10) unsigned || YES || MUL || NULL || REFERENCES [[record table|record]](recordid) |
|- | |- | ||
| − | || chanid || int(10) unsigned | + | || chanid || int(10) unsigned || YES || || NULL || REFERENCES [[channel table|channel]](chanid) |
|- | |- | ||
| − | || starttime || datetime | + | || starttime || datetime || YES || || NULL || |
|- | |- | ||
| − | || manualid || int(10) unsigned | + | || manualid || int(10) unsigned || YES || || NULL || |
|- | |- | ||
| + | || oldrecduplicate || tinyint(1) || YES || || NULL || | ||
| + | |- | ||
| + | || recduplicate || tinyint(1) || YES || || NULL || | ||
| + | |- | ||
| + | || findduplicate || tinyint(1) || YES || || NULL || | ||
| + | |- | ||
| + | || oldrecstatus || int(11) || YES || || NULL || | ||
| + | |- | ||
| + | || findid || int(11) || || || 0 || || +1299 | ||
|} | |} | ||
Latest revision as of 13:33, 22 February 2014
Note: The correct title of this article is recordmatch table. It appears incorrectly here due to technical restrictions.
Table Description
13:33, 22 February 2014 (UTC) This is my guess, correct this if you know better!
This table is used by the scheduler to find program candidates for recording.
- It is regularly populated by checking all programs against the recording rules.
- Then duplicates are eliminated.
| Field name | Type | Null | Key | Default | Extras | Schema-Version |
|---|---|---|---|---|---|---|
| recordid | int(10) unsigned | YES | MUL | NULL | REFERENCES record(recordid) | |
| chanid | int(10) unsigned | YES | NULL | REFERENCES channel(chanid) | ||
| starttime | datetime | YES | NULL | |||
| manualid | int(10) unsigned | YES | NULL | |||
| oldrecduplicate | tinyint(1) | YES | NULL | |||
| recduplicate | tinyint(1) | YES | NULL | |||
| findduplicate | tinyint(1) | YES | NULL | |||
| oldrecstatus | int(11) | YES | NULL | |||
| findid | int(11) | 0 | +1299 |
