Difference between revisions of "Recordedseek table"
From MythTV Official Wiki
(Same add new MAKR_UTIL_) |
|||
(6 intermediate revisions by 4 users not shown) | |||
Line 4: | Line 4: | ||
{| 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 !! Null !! Key !! Default !! Extras |
|- | |- | ||
− | | chanid | + | | chanid || int(10) unsigned || || PRI || 0 || rowspan="2" |REFERENCES [[recorded table|recorded]](chanid,starttime) |
|- | |- | ||
− | | starttime || datetime | + | | starttime || datetime || || PRI || 0000-00-00 00:00:00 |
|- | |- | ||
− | | mark | + | | mark || mediumint(8) unsigned || || PRI || 0 |
|- | |- | ||
− | | offset | + | | offset || bigint(20) unsigned || || || NULL |
|- | |- | ||
− | | type | + | | type || tinyint(4) || || PRI || 0 |
|- | |- | ||
|} | |} | ||
Line 20: | Line 20: | ||
== Fields == | == Fields == | ||
*'''chanid''' along with '''starttime''' relate to unique entries in the [[recorded table]]. | *'''chanid''' along with '''starttime''' relate to unique entries in the [[recorded table]]. | ||
− | *'''type''' shows what kind of marker it is, such as a keyframe. Possible values are defined in the [ | + | *'''type''' shows what kind of marker it is, such as a keyframe. Possible values 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 recordedseek table, they may be used in the [[recordedmarkup table]] instead. | |
+ | *'''mark''' 0-based frame number | ||
+ | *'''offset''' 0-based offset into file | ||
+ | |||
+ | {| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5; text-align:center" | ||
+ | |- style="background: lightsteelblue" | ||
+ | ! '''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 | ||
+ | |- | ||
+ | | 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 | ||
+ | |- | ||
+ | |} | ||
Revision as of 06:55, 5 April 2018
Note: The correct title of this article is recordedseek table. It appears incorrectly here due to technical restrictions.
The recordedseek table stores a time vs. byte offset mapping (seektable) for each recording in the recorded table to enable accurate forward and backward time skipping.
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 | ||
offset | bigint(20) unsigned | NULL | |||
type | tinyint(4) | PRI | 0 |
Fields
- chanid along with starttime relate to unique entries in the recorded table.
- type shows what kind of marker it is, such as a keyframe. Possible values are defined in the [[https://code.mythtv.org/doxygen/programtypes_8h_source.html#l00050
MarkTypes
enum]. Not all of the following marktypes apply to the recordedseek table, they may be used in the recordedmarkup table instead.
- mark 0-based frame number
- offset 0-based offset into file
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 |