Recordedfile table

From MythTV Official Wiki
Revision as of 12:37, 11 September 2016 by Pmhahn (talk | contribs) (Created page with "{{Wrongtitle|recordedfile table}} The '''recordedfile table''' stores per file meta data for each recording in the recorded table like container format and video/audio cod...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Important.png Note: The correct title of this article is recordedfile table. It appears incorrectly here due to technical restrictions.

The recordedfile table stores per file meta data for each recording in the recorded table like container format and video/audio codecs .

Table Description

Field name Type Null Key Default Extras
basename varchar(128) KEY REFERENCES recorded(basename)
filesize bigint 0
width smallint 0
height smallint 0
fps float(6,3) 0.000
aspect float(8,6) 0.000000
audio_samle_rate smallint(5) 0
audio_channels tinyint(3) 0
audio_codec varchar(255)
video_codec varchar(255)
comment varchar(255) NULL
hostname varchar(64)
storagegroup varchar(32) REFERENCES storagegroup(groupname)
id int(11) PRI
recordedid int(10) UNI REFERENCES recorded(recordedid)
container varchar(256)
total_bitrate mediumint(8) 0
video_avg_bitrate mediumint(8) 0
video_max_bitrate mediumint(8) 0
audio_avg_bitrate mediumint(8) 0
audio_max_bitrate mediumint(8) 0

Fields

fps
frames per second, e.g. 50, 25, ...
aspect
width/height, e.g. 4/3=1.3, 16/9=1.7, ...
audio_codec
AC3, MP2, ...
video_codec
H264, MPEG2VIDEO, ...
container
MPEG2TS, ...