<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>test</title>
<!--VISUALIZZAZIONE TABELLE-->
</head>
<body bgcolor=white>
<font size=6><b>logger.raw_logger</b></font><br>
This table contains the list of all the raw files produced during the data
taking.
<p>
<i>Fields description:</i>
<table border=3>
<body link="blue">
<tr bgcolor="silver">
<th><i>Field name</i></th>
<td colspan=2><i>Field type</i></td>
<th><i>Can be NULL?</i></th>
<th><i>Description</i></th>
<tr>
<td>Run_Nr</td>
<td align=center colspan=2>integer<sup>a</sup></td>
<td align=center>no</td>
<td>Run number</td>
</tr>
<tr>
<td>Farm_Id</td>
<td align=center colspan=2>char(3)</td>
<td align=center>no</td>
<td>Acqusition machine identifier</td>
</tr>
<tr>
<td>Reiceiver_Nr</td>
<td valing=top rowspan=2 colspan=2><center>integer</center></td>
<td valing=top rowspan=2><center>no</center></td>
<td valing=top rowspan=2>Builder identifier</td>
</tr>
<tr>
<td>Builder_Nr</td>
</tr>
<tr>
<td>Stream_Id</td>
<td align=center colspan=2>integer<sup>b</sup></td>
<td align=center>no</td>
<td>Stream identifier</td>
</tr>
<tr>
<td>Recorder_Nr</td>
<td align=center colspan=2>integer</td>
<td align=center>no</td>
<td>Recorder number</td>
</tr>
<tr>
<td>Gb_Nr</td>
<td align=center colspan=2>integer</td>
<td align=center>no</td>
<td>Sequential number</td>
</tr>
<tr>
<td>Filename</td>
<td align=center colspan=2>varchar(64)</td>
<td align=center>no</td>
<td>File name</td>
</tr>
<tr>
<td>Creation_Time</td>
<td align=center colspan=2>timestamp</td>
<td align=center>no</td>
<td>Creation time</td>
</tr>
<tr>
<td>Closure_Time</td>
<td align=center colspan=2>timestamp</td>
<td align=center>yes</td>
<td>Closure time<br>Can be used to find out if the
file is still being written(NULL value)</td>
</tr>
<tr>
<td>First</td>
<td valing=top rowspan=2 colspan=2><center>integer<br>(as boolean)</center></td>
<td valing=top rowspan=2><center>no</center></td>
<td valing=top rowspan=2>Specifies if this is the first/last file in the
sequence produced by the recorder.</td>
</tr>
<tr>
<td>Last</td>
</tr>
<tr>
<td>Size</td>
<td align=center colspan=2>integer</td>
<td align=center>yes</td>
<td>File size</td>
</tr>
<tr>
<td>Total_events</td>
<td align=center colspan=2>integer</td>
<td align=center>yes</td>
<td>Number of events inside the file</td>
</tr>
<tr>
<td>?Archived</td>
<td align=center colspan=2>integer<sup>c</sup></td>
<td align=center>no</td>
<td>Is the file archived or archiving?(0-not
archived,1-archiving,2-archived)</td>
</tr>
<tr>
<td>TServer_Id</td>
<td align=center>char(3)</td>
<td valing=top rowspan=2><center>d</center></td>
<td valing=top rowspan=2><center>yes</center></td>
<td valing=top rowspan=2>Filespace where the file is archived.</td>
</tr>
<tr>
<td>Filespace_Id</td>
<td align=center>integer</td>
</tr>
<tr>
<td>Analyzed</td>
<td align=center colspan=2>integer</td>
<td align=center>yes</td>
<td>The highest version of datarec used to reconstruct this file(NULL if
never reconstructed)</td>
</tr>
</table>
<p>
<i>Primary key:</i>
<ul>
<li>Run_Nr
<li>Farm_Id
<li>Receiver_Nr
<li>Builder_Nr
<li>Stream_Id
<li>Recorder_Nr
<li>Gb_Nr
</ul>
<div><hr width=20% size=6></div>
<ol type=a>
<li>foreign key of logger.run_logger
<li>foreign of descript.stream_descript
<li>foreign key of descript.archived_status
<li>foreign key of descript.filespace_farm(together with
Stream_Id)
</ol>
<hr>
<address><a href="mailto:igor.sfiligoi@lnf.infn.it">Mariotti Valentina</a></address>
<!-- Created: Mon Jun 10 14:13:23 MEST 2002 -->
<!-- hhmts start -->
Last modified: Wed Jun 12 10:13:31 MEST 2002
<!-- hhmts end -->
</body>
</html>