| 1 |
\begin{longtable}{llX} |
| 2 |
\caption{JobMedia table layout}\label{blb:dev:jobmedia: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 |
JobMediaId & integer & Primary Key \\ |
| 23 |
\midrule |
| 24 |
JobId & integer & Link to Job Record \\ |
| 25 |
\midrule |
| 26 |
MediaId & integer & Link to Media Record \\ |
| 27 |
\midrule |
| 28 |
FirstIndex & integer & The index (sequence number) of the first file written for this Job to the Media \\ |
| 29 |
\midrule |
| 30 |
LastIndex & integer & The index of the last file written for this Job to the Media \\ |
| 31 |
\midrule |
| 32 |
StartFile & integer & The physical media (tape) file number of the first block written for this Job \\ |
| 33 |
\midrule |
| 34 |
EndFile & integer & The physical media (tape) file number of the last block written for this Job \\ |
| 35 |
\midrule |
| 36 |
StartBlock & integer & The number of the first block written for this Job \\ |
| 37 |
\midrule |
| 38 |
EndBlock & integer & The number of the last block written for this Job \\ |
| 39 |
\midrule |
| 40 |
VolIndex & integer & The Volume use sequence number within the Job \\ |
| 41 |
\end{longtable} |