Recordmatch table
Jump to navigation
Jump to search
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 |