| Name | Type | Can be null | Description | |||
|---|---|---|---|---|---|---|
| Run_Nr | PK | I | integer | FK | No | Run number |
| Farm_Id | PK | char(3) | No | Acquisition machine identifier | ||
| Receiver_Nr | PK | integer | No | Builder identifier | ||
| Builder_Nr | PK | |||||
| Stream_Id | PK | I | integer | FK | No | Stream identifier |
| Recorder_Nr | PK | integer | No | Recorder number | ||
| Gb_Nr | PK | integer | No | Sequential number | ||
| Filename | I | varchar(64) | No | File name | ||
| Creation_Time | timestamp | No | Creation time | |||
| Closure_Time | I | timestamp | Yes |
Closure time Can be used to find out if the file is still being written (NULL value) | ||
| First | integer (as boolean) | No | Specifies if this is the first/last file in the sequence produced by the recorder | |||
| Last | ||||||
| Size | integer | Yes | File size | |||
| Total_Events | integer | Yes | Number of events inside the file | |||
| Archived | I | integer | FK | No |
Is the file archived or archiving? (0 - not archived, 1 - archiving, 2 - archived) | |
| Tserver_Id | char(3) | FK | Yes | Filespace where the file is archived. | ||
| Filespace_Id | integer | FK | ||||
| Analyzed | integer | Yes |
The highest version of datarec used to reconstruct this file (NULL if never reconstructed) | |||
Primary key:
|
Unique:
|
| Local field(s) | Foreign table | Foreign field(s) |
|---|---|---|
| Run_Nr | logger.run_logger | run_nr |
| Stream_Id | descript.stream_descript | stream_id |
| Archived | descript.archived_status | status |
| Tserver_Id | descript.fsp_def_farm | tserver_id |
| Stream_Id | stream_id | |
| Filespace_Id | filespace_id | |
Index:
|
Index:
|
Index:
|