Debian Codegraph @

manuals/en/developers/t-dev-dbmedia.tex

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