Recordedfile table

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, ...