Fields description:

Field name	Field type		Can be NULL?	Description
Run_Nr	integera		no	Run number
Farm_Id	char(3)		no	Acqusition machine identifier
Reiceiver_Nr	integer		no	Builder identifier
Builder_Nr
Stream_Id	integerb		no	Stream identifier
Recorder_Nr	integer		no	Recorder number
Gb_Nr	integer		no	Sequential number
Filename	varchar(64)		no	File name
Creation_Time	timestamp		no	Creation time
Closure_Time	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	integerc		no	Is the file archived or archiving?(0-not archived,1-archiving,2-archived)
TServer_Id	char(3)	d	yes	Filespace where the file is archived.
Filespace_Id	integer
Analyzed	integer		yes	The highest version of datarec used to reconstruct this file(NULL if never reconstructed)

Primary key:

• Run_Nr
• Farm_Id
• Receiver_Nr
• Builder_Nr
• Stream_Id
• Recorder_Nr
• Gb_Nr

1. foreign key of logger.run_logger
2. foreign of descript.stream_descript
3. foreign key of descript.archived_status
4. foreign key of descript.filespace_farm(together with Stream_Id)