Difference between revisions of "Recordedseek table"
From MythTV Official Wiki
(→Fields) |
(Fix -100, add -15, fix wiki syntax, reference filemarkup table) |
||
(5 intermediate revisions by 2 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" | {{DbRef|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 MarkTypes enum]. Not all of the following marktypes apply to the recordedseek table, they may be used in the [[recordedmarkup table]] or [[filemarkup 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" | {| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5; text-align:center" | ||
Line 26: | Line 28: | ||
! '''Value''' !! '''Field''' | ! '''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 |
|- | |- | ||
− | | 8 || MARK_SCENE_CHANGE | + | | 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 | ||
|- | |- | ||
− | |||
|} | |} | ||
− | |||
− | |||
[[Category:DB Table]] | [[Category:DB Table]] |
Latest revision as of 16:17, 22 February 2021
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 | REF 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 MarkTypes enum. Not all of the following marktypes apply to the recordedseek table, they may be used in the recordedmarkup table or filemarkup table instead.
- mark 0-based frame number
- offset 0-based offset into file
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 |