Difference between revisions of "Recordedmarkup table"
From MythTV Official Wiki
(Add new MARK-UTIL_) |
m (Code-Ref) |
||
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 [ | + | *'''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. |
{| 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" |
Revision as of 06:53, 5 April 2018
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 | REFERENCES 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
type
are defined in theMarkTypes
enum. Not all of the following marktypes apply to the recordedmarkup table, they may be used in the recordedseek table instead.
Value | Field |
---|---|
-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 |
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 |