1\begin{longtable}{llX}
2  \caption{Job table layout}\label{blb:dev:job:table:layout} \\
3  \toprule
4  \rowcolor{bheader}
5  \multicolumn{1}{c}{\bheader{Column Name}} &
6  \multicolumn{1}{l}{\bheader{Data Type}} &
7  \multicolumn{1}{l}{\bheader{Remark}} \\
8  \midrule
9  \endfirsthead
10  \toprule
11  \rowcolor{bheader}
12  \multicolumn{1}{c}{\bheader{Column Name}} &
13  \multicolumn{1}{l}{\bheader{Data Type}} &
14  \multicolumn{1}{l}{\bheader{Remark}} \\
15  \midrule
16  \endhead
17  \midrule
18  \multicolumn{3}{c}{\bnextpage{}} \\
19  \endfoot
20  \bottomrule
21  \endlastfoot
22  JobId & integer & Primary Key \\
23  \midrule
24  Job & tinyblob & Unique Job Name \\
25  \midrule
26  Name & tinyblob & Job Name \\
27  \midrule
28  PurgedFiles & tinyint & Used by Bacula for purging/retention periods \\
29  \midrule
30  Type & binary(1) & Job Type: Backup, Copy, Clone, Archive, Migration \\
31  \midrule
32  Level & binary(1) & Job Level \\
33  \midrule
34  ClientId & integer & Client index \\
35  \midrule
36  JobStatus & binary(1) & Job Termination Status \\
37  \midrule
38  SchedTime & datetime & Time/date when Job scheduled \\
39  \midrule
40  StartTime & datetime & Time/date when Job started \\
41  \midrule
42  EndTime & datetime & Time/date when Job ended \\
43  \midrule
44  RealEndTime & datetime & Time/date when original Job ended \\
45  \midrule
46  JobTDate & bigint & Start day in Unix format but 64 bits; used for Retention period. \\
47  \midrule
48  VolSessionId & integer & Unique Volume Session ID \\
49  \midrule
50  VolSessionTime & integer & Unique Volume Session Time \\
51  \midrule
52  JobFiles & integer & Number of files saved in Job \\
53  \midrule
54  JobBytes & bigint & Number of bytes saved in Job \\
55  \midrule
56  ReadBytes & bigint & Number of bytes read in Job \\
57  \midrule
58  JobErrors & integer & Number of errors during Job \\
59  \midrule
60  JobMissingFiles & integer & Number of files not saved (not yet used) \\
61  \midrule
62  PoolId & integer & Link to Pool Record \\
63  \midrule
64  FileSetId & integer & Link to FileSet Record \\
65  \midrule
66  PrioJobId & integer & Link to prior Job Record when migrated \\
67  \midrule
68  PurgedFiles & tiny integer & Set when all File records purged \\
69  \midrule
70  HasBase & tiny integer & Set when Base Job run \\
71  \midrule
72  Reviewed & tiny integer & Set when the error is acknowledged \\
73 \midrule
74 Comment  & tinyblob & Comment about this Job\\
75 \midrule
76 PrioJob & tinyblob & Prior Job name when migrated \\
77\end{longtable}
78