<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>tabelle</title>
</head>
<body bgcolor=white>
<table border=3>
<i>Unique constraint:</i>
<ul>
<li>Filename
</ul>
<p>
<i>Foreing keys:</i>
<tr bgcolor="silver">
<th><i>Local fields(s)</i></th>
<th><i>Foreing table</i></th>
<th><i>Foreing field(s)</i></th>
</tr>
<tr>
<td>Run_Nr</td>
<td>logger.run_logger</td>
<td>Run_Nr</td>
</tr>
<tr>
<td>Stream_Id</td>
<td>descript.stream_descript</td>
<td>Stream_Id</td>
</tr>
<tr>
<td>Archived</td>
<td>decsript.archived_status</td>
<td>Status</td>
</tr>
<tr>
<td>TServer_Id</td>
<td valing=top rowspan=3>descript.filespace_farm</td>
<td>TServer_Id</td>
</tr>
<tr>
<td>Stream_Id</td>
<td>Stream_Id</td>
</tr>
<tr>
<td>Filespace_Id</td>
<td>Filespace_Id</td>
</tr>
</table>
<p>
<b>descript.stream_descript</b><br>
This table contains the list of all the possible sources of raw
files.Moreover,since not all the sources contain equally important
data,there are also some flags that classify each source.
<p>
<i>Fields description:</i>
<table border=3>
<tr bgcolor="silver">
<th><i>Field name</i></th>
<th><i>Field type</i></th>
<th><i>Can be NULL?</i></th>
<th><i>Description</i></th>
</tr>
<tr>
<td>Stream_id</td>
<td align=center>integer</td>
<td align=center>no</td>
<td>Stream identifier,used for foreign keys</td>
</tr>
<tr>
<td>Code</td>
<td align=center>varchar(8)</td>
<td align=center>no</td>
<td>stream code,used for human readable interaction</td>
</tr>
<tr>
<td>Analyze</td>
<td align=center>integer (as boolean)</td>
<td align=center>no</td>
<td>If false,it will not be reconstructed.</td>
</tr>
<tr>
<td>All_Data</td>
<td align=center>integer (as boolean)</td>
<td align=center>no</td>
<td>If false,it could have been produced using only a subset of avaible
events (i.e. by a spy proces).</td>
</tr>
<tr>
<td>Description</td>
<td align=center>varchar(32)</td>
<td align=center>no</td>
<td>Free text description</td>
</tr>
</table>
<p>
<i>Primary key:</i>
<ul>
<li>Stream_Id
</ul>
<p>
<i>Unique contrastrain:</i>
<ul>
<li>Code
</ul>
<p>
<p>
<address><a href="mailto:igor.sfiligoi@lnf.infn.it">Giordani Chiara</a></address>
<!-- Created: Mon Jun 10 12:10:33 MEST 2002 -->
<!-- hhmts start -->
Last modified: Fri Jul 5 15:47:42 MEST 2002
<!-- hhmts end -->
</body>
</html>