Column Name |
Data Type |
Remark |
|---|---|---|
MediaId |
integer |
Primary Key |
VolumeName |
tinyblob |
Volume name |
Slot |
integer |
Autochanger Slot number or zero |
PoolId |
integer |
Link to Pool Record |
MediaType |
tinyblob |
The MediaType supplied by the user |
MediaTypeId |
integer |
The MediaTypeId |
LabelType |
tinyint |
The type of label on the Volume |
FirstWritten |
datetime |
Time / date when first written |
LastWritten |
datetime |
Time/date when last written |
LabelDate |
datetime |
Time/date when tape labeled |
VolJobs |
integer |
Number of jobs written to this media |
VolFiles |
integer |
Number of files written to this media |
VolBlocks |
integer |
Number of blocks written to this media |
VolMounts |
integer |
Number of time media mounted |
VolBytes |
bigint |
Number of bytes saved in Job |
VolParts |
integer |
The number of parts for a Volume (DVD) |
VolErrors |
integer |
Number of errors during Job |
VolWrites |
integer |
Number of writes to media |
MaxVolBytes |
bigint |
Maximum bytes to put on this media |
VolCapacityBytes |
bigint |
Capacity estimate for this volume |
VolStatus |
enum |
Status of media: Full, Archive, Append, Recycle, Read-Only, Disabled, Error, Busy |
Enabled |
tinyint |
Whether or not Volume can be written |
Recycle |
tinyint |
Whether or not Bacula can recycle the Volumes: <yes/no> |
ActionOnPurge |
tinyint |
What happens to a Volume after purging |
VolRetention |
bigint |
64 bit seconds until expiration |
VolUseDuration |
bigint |
64 bit seconds volume can be used |
MaxVolJobs |
integer |
maximum jobs to put on Volume |
MaxVolFiles |
integer |
maximume EOF marks to put on Volume |
InChanger |
tinyint |
Whether or not Volume in autochanger |
StorageId |
integer |
Storage record ID |
DeviceId |
integer |
Device record ID |
MediaAddressing |
integer |
Method of addressing media |
VolReadTime |
bigint |
Time Reading Volume |
VolWriteTime |
bigint |
Time Writing Volume |
EndFile |
integer |
End File number of Volume |
EndBlock |
integer |
End block number of Volume |
LocationId |
integer |
Location record ID |
RecycleCount |
integer |
Number of times recycled |
InitialWrite |
datetime |
When Volume first written |
ScratchPoolId |
integer |
Id of Scratch Pool |
RecyclePoolId |
integer |
Pool ID where to recycle Volume |
Comment |
blob |
User text field |