| 1 |
\begin{longtable}{llX} |
| 2 |
\caption{Media table layout}\label{blb:dev:media:table:layout} \\ |
| 3 |
\toprule |
| 4 |
\rowcolor{bheader} |
| 5 |
\multicolumn{1}{c}{\bheader{Column Name}} & |
| 6 |
\multicolumn{1}{c}{\bheader{Data Type}} & |
| 7 |
\multicolumn{1}{c}{\bheader{Remark}} \\ |
| 8 |
\midrule |
| 9 |
\endfirsthead |
| 10 |
\toprule |
| 11 |
\rowcolor{bheader} |
| 12 |
\multicolumn{1}{c}{\bheader{Column Name}} & |
| 13 |
\multicolumn{1}{c}{\bheader{Data Type}} & |
| 14 |
\multicolumn{1}{c}{\bheader{Remark}} \\ |
| 15 |
\midrule |
| 16 |
\endhead |
| 17 |
\midrule |
| 18 |
\multicolumn{3}{c}{\bnextpage{}} \\ |
| 19 |
\endfoot |
| 20 |
\bottomrule |
| 21 |
\endlastfoot |
| 22 |
MediaId & integer & Primary Key \\ |
| 23 |
\midrule |
| 24 |
VolumeName & tinyblob & Volume name \\ |
| 25 |
\midrule |
| 26 |
Slot & integer & Autochanger Slot number or zero \\ |
| 27 |
\midrule |
| 28 |
PoolId & integer & Link to Pool Record \\ |
| 29 |
\midrule |
| 30 |
MediaType & tinyblob & The MediaType supplied by the user \\ |
| 31 |
\midrule |
| 32 |
MediaTypeId & integer & The MediaTypeId \\ |
| 33 |
\midrule |
| 34 |
LabelType & tinyint & The type of label on the Volume \\ |
| 35 |
\midrule |
| 36 |
FirstWritten & datetime & Time / date when first written \\ |
| 37 |
\midrule |
| 38 |
LastWritten & datetime & Time/date when last written \\ |
| 39 |
\midrule |
| 40 |
LabelDate & datetime & Time/date when tape labeled \\ |
| 41 |
\midrule |
| 42 |
VolJobs & integer & Number of jobs written to this media \\ |
| 43 |
\midrule |
| 44 |
VolFiles & integer & Number of files written to this media \\ |
| 45 |
\midrule |
| 46 |
VolBlocks & integer & Number of blocks written to this media \\ |
| 47 |
\midrule |
| 48 |
VolMounts & integer & Number of time media mounted \\ |
| 49 |
\midrule |
| 50 |
VolBytes & bigint & Number of bytes saved in Job \\ |
| 51 |
\midrule |
| 52 |
VolParts & integer & The number of parts for a Volume (DVD) \\ |
| 53 |
\midrule |
| 54 |
VolErrors & integer & Number of errors during Job \\ |
| 55 |
\midrule |
| 56 |
VolWrites & integer & Number of writes to media \\ |
| 57 |
\midrule |
| 58 |
MaxVolBytes & bigint & Maximum bytes to put on this media \\ |
| 59 |
\midrule |
| 60 |
VolCapacityBytes & bigint & Capacity estimate for this volume \\ |
| 61 |
\midrule |
| 62 |
VolStatus & enum & Status of media: Full, Archive, Append, Recycle, Read-Only, Disabled, Error, Busy \\ |
| 63 |
\midrule |
| 64 |
Enabled & tinyint & Whether or not Volume can be written \\ |
| 65 |
\midrule |
| 66 |
Recycle & tinyint & Whether or not Bacula can recycle the Volumes: \byesorno{} \\ |
| 67 |
\midrule |
| 68 |
ActionOnPurge & tinyint & What happens to a Volume after purging \\ |
| 69 |
\midrule |
| 70 |
VolRetention & bigint & 64 bit seconds until expiration \\ |
| 71 |
\midrule |
| 72 |
VolUseDuration & bigint & 64 bit seconds volume can be used \\ |
| 73 |
\midrule |
| 74 |
MaxVolJobs & integer & maximum jobs to put on Volume \\ |
| 75 |
\midrule |
| 76 |
MaxVolFiles & integer & maximume EOF marks to put on Volume \\ |
| 77 |
\midrule |
| 78 |
InChanger & tinyint & Whether or not Volume in autochanger \\ |
| 79 |
\midrule |
| 80 |
StorageId & integer & Storage record ID \\ |
| 81 |
\midrule |
| 82 |
DeviceId & integer & Device record ID \\ |
| 83 |
\midrule |
| 84 |
MediaAddressing & integer & Method of addressing media \\ |
| 85 |
\midrule |
| 86 |
VolReadTime & bigint & Time Reading Volume \\ |
| 87 |
\midrule |
| 88 |
VolWriteTime & bigint & Time Writing Volume \\ |
| 89 |
\midrule |
| 90 |
EndFile & integer & End File number of Volume \\ |
| 91 |
\midrule |
| 92 |
EndBlock & integer & End block number of Volume \\ |
| 93 |
\midrule |
| 94 |
LocationId & integer & Location record ID \\ |
| 95 |
\midrule |
| 96 |
RecycleCount & integer & Number of times recycled \\ |
| 97 |
\midrule |
| 98 |
InitialWrite & datetime & When Volume first written \\ |
| 99 |
\midrule |
| 100 |
ScratchPoolId & integer & Id of Scratch Pool \\ |
| 101 |
\midrule |
| 102 |
RecyclePoolId & integer & Pool ID where to recycle Volume \\ |
| 103 |
\midrule |
| 104 |
Comment & blob & User text field \\ |
| 105 |
\end{longtable} |