Difference between revisions of "Recordedmarkup table"
From MythTV Official Wiki
m (Code-Ref) |
(Fix -100, add -15, fix wiki syntax, reference filemarkup table) |
||
| Line 6: | Line 6: | ||
! Field name !! Type !! Null !! Key !! Default !! Extras | ! Field name !! Type !! Null !! Key !! Default !! Extras | ||
|- | |- | ||
| − | | chanid || int(10) unsigned || || PRI || 0 || rowspan="2" | | + | | chanid || int(10) unsigned || || PRI || 0 || rowspan="2" | {{DbRef|recorded|chanid,starttime}} |
|- | |- | ||
| starttime || datetime || || PRI || 0000-00-00 00:00:00 | | starttime || datetime || || PRI || 0000-00-00 00:00:00 | ||
| Line 21: | Line 21: | ||
*'''chanid''' along with '''starttime''' relate to unique entries in the [[recorded table]]. | *'''chanid''' along with '''starttime''' relate to unique entries in the [[recorded table]]. | ||
*'''offset''' is redundant and remains for backwards compatibility. | *'''offset''' is redundant and remains for backwards compatibility. | ||
| − | *'''type''' shows what kind of marker it is, such as a keyframe, scene change, a flagged commercial, etc. Possible values for <code>type</code> are defined in the [https://code.mythtv.org/doxygen/programtypes_8h_source.html#l00050 <code>MarkTypes</code> enum]. Not all of the following marktypes apply to the recordedmarkup table, they may be used in the [[recordedseek table]] instead. | + | *'''type''' shows what kind of marker it is, such as a keyframe, scene change, a flagged commercial, etc. Possible values for <code>type</code> are defined in the [https://code.mythtv.org/doxygen/programtypes_8h_source.html#l00050 <code>MarkTypes</code> enum]. Not all of the following marktypes apply to the recordedmarkup table, they may be used in the [[recordedseek table]] of [[filemarkup table]] instead. |
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5; text-align:center" | {| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5; text-align:center" | ||
| Line 27: | Line 27: | ||
! '''Value''' !! '''Field''' | ! '''Value''' !! '''Field''' | ||
|- | |- | ||
| − | |-100 || MARK_ALL | + | | -100 || MARK_ALL |
|- | |- | ||
| -10 || MARK_UNSET | | -10 || MARK_UNSET | ||
| Line 68: | Line 68: | ||
|- | |- | ||
| 14 || MARK_ASPECT_CUSTOM | | 14 || MARK_ASPECT_CUSTOM | ||
| + | |- | ||
| + | | 15 || MARK_SCAN_PROGRESSIVE | ||
|- | |- | ||
| 30 || MARK_VIDEO_WIDTH | | 30 || MARK_VIDEO_WIDTH | ||
Latest revision as of 16:20, 22 February 2021
Note: The correct title of this article is recordedmarkup table. It appears incorrectly here due to technical restrictions.
The recordedmarkup table stores bookmarks, edit markup and commercial flagging markup for each recording in the recorded table.
Table Description
| Field name | Type | Null | Key | Default | Extras |
|---|---|---|---|---|---|
| chanid | int(10) unsigned | PRI | 0 | REF recorded(chanid,starttime) | |
| starttime | datetime | PRI | 0000-00-00 00:00:00 | ||
| mark | mediumint(8) unsigned | PRI | 0 | unit: framenumber | |
| type | tinyint(4) | PRI | 0 | ||
| data | iny(11) unsigned | NULL | NULL |
Fields
- chanid along with starttime relate to unique entries in the recorded table.
- offset is redundant and remains for backwards compatibility.
- type shows what kind of marker it is, such as a keyframe, scene change, a flagged commercial, etc. Possible values for
typeare defined in theMarkTypesenum. Not all of the following marktypes apply to the recordedmarkup table, they may be used in the recordedseek table of filemarkup table instead.
| Value | Field |
|---|---|
| -100 | MARK_ALL |
| -10 | MARK_UNSET |
| -5 | MARK_TMP_CUT_END |
| -4 | MARK_TMP_CUT_START |
| -3 | MARK_UPDATED_CUT |
| -2 | MARK_PLACEHOLDER |
| 0 | MARK_CUT_END |
| 1 | MARK_CUT_START |
| 2 | MARK_BOOKMARK |
| 3 | MARK_BLANK_FRAME |
| 4 | MARK_COMM_START |
| 5 | MARK_COMM_END |
| 6 | MARK_GOP_START |
| 7 | MARK_KEYFRAME |
| 8 | MARK_SCENE_CHANGE |
| 9 | MARK_GOP_BYFRAME |
| 10 | MARK_ASPECT_1_1 //< deprecated, it is only 1:1 sample aspect ratio |
| 11 | MARK_ASPECT_4_3 |
| 12 | MARK_ASPECT_16_9 |
| 13 | MARK_ASPECT_2_21_1 |
| 14 | MARK_ASPECT_CUSTOM |
| 15 | MARK_SCAN_PROGRESSIVE |
| 30 | MARK_VIDEO_WIDTH |
| 31 | MARK_VIDEO_HEIGHT |
| 32 | MARK_VIDEO_RATE |
| 33 | MARK_DURATION_MS |
| 34 | MARK_TOTAL_FRAMES |
| 40 | MARK_UTIL_PROGSTART |
| 41 | MARK_UTIL_LASTPLAYPOS |
