Difference between revisions of "Recordedseek table"
From MythTV Official Wiki
(Updated from 0.26 source) |
(TYPES,FK) |
||
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 |
|- | |- | ||
|} | |} |
Revision as of 13:44, 22 February 2014
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
MarkTypes
enum. Not all of the following marktypes apply to the recordedseek table, they may be used in the recordedmarkup 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 |