Difference between revisions of "Recordedmarkup table"

From MythTV Official Wiki
Jump to: navigation, search
m (Mirror the note about marktypes on the recordedseek table page)
(Fix -100, add -15, fix wiki syntax, reference filemarkup table)
 
(9 intermediate revisions by 6 users not shown)
Line 1: Line 1:
 +
{{Wrongtitle|recordedmarkup table}}
 
The '''recordedmarkup table''' stores bookmarks, edit markup and commercial flagging markup for each recording in the [[recorded table]].
 
The '''recordedmarkup table''' stores bookmarks, edit markup and commercial flagging markup for each recording in the [[recorded table]].
−
 
+
== Table Description ==
−
{| border=1 style="background:#D6DFE7"
+
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5"
 +
|- style="background: lightsteelblue"
 +
!  Field name !! Type                  !! Null !! Key !! Default            !! Extras
 
|-
 
|-
−
! Field || Type || Null || Key || Default
+
| chanid    || int(10) unsigned ||     || PRI || 0                  || rowspan="2" | {{DbRef|recorded|chanid,starttime}}
 
|-
 
|-
−
! chanid || int(10) unsigned || NO || PRI || 0
+
| starttime || datetime        ||      || PRI || 0000-00-00 00:00:00
 
|-
 
|-
−
! starttime || datetime || NO || PRI || 0000-00-00 00:00:00
+
| mark      || mediumint(8) unsigned ||      || PRI || 0||unit: framenumber
 
|-
 
|-
−
! mark || bigint(20) || NO || PRI || 0
+
| type      || tinyint(4)       ||     || PRI || 0
 
|-
 
|-
−
! offset || varchar(32) || YES || || NULL
+
| data      || iny(11) unsigned || NULL ||     || NULL
 
|-
 
|-
−
! type || int(11) || NO || PRI || 0
 
 
|}
 
|}
  
−
The <code>offset</code> field is redundant and remains for backwards compatibility.
+
== 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 <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.
  
−
The <code>type</code> field 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 [http://www.cuymedia.net/doxygen-dev-docs/html/programinfo_8h.html#a59 <code>MarkTypes</code> enum] N.B. 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"
 +
|- 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
 +
|-
 +
|  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
 +
|-
 +
|}
  
−
typedef enum {
 
−
    MARK_UNSET = -10,
 
−
    MARK_UPDATED_CUT = -3,
 
−
    MARK_EDIT_MODE = -2,
 
−
    MARK_CUT_END = 0,
 
−
    MARK_CUT_START = 1,
 
−
    MARK_BOOKMARK = 2,
 
−
    MARK_BLANK_FRAME = 3,
 
−
    MARK_COMM_START = 4,
 
−
    MARK_COMM_END = 5,
 
−
    MARK_GOP_START = 6,
 
−
    MARK_KEYFRAME = 7,
 
−
    MARK_SCENE_CHANGE = 8,
 
−
    MARK_GOP_BYFRAME = 9
 
−
} MarkTypes;
 
  
 
[[Category:DB Table]]
 
[[Category:DB Table]]

Latest revision as of 16:20, 22 February 2021

Important.png 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 type are defined in the MarkTypes enum. 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
Retrieved from "http://www.mythtv.org/wiki?title=Recordedmarkup_table&oldid=65616"