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} 106