KLOE Database

Schema: LOGGER

• LOGGER.RUN_LOGGER
• LOGGER.RAW_LOGGER
• LOGGER.DATAREC_LOGGER
• LOGGER.DATAREC_RAWS
• LOGGER.RAW_DATA
• LOGGER.DATAREC_DATA
• LOGGER.MC_RUNS
• LOGGER.MC_LOGGER
• LOGGER.MC_DATA
• LOGGER.MC_STREAMS
• LOGGER.MC_STREAMS_DATA

LOGGER.RUN_LOGGER Field Type Nullable RUN_NR INTEGER N COMMENT VARCHAR(40) N ZERO_SUP SMALLINT N USER_ID SMALLINT N TRGMON_LUMINOSITY DOUBLE Y TRGMON_INT_LUM DOUBLE Y TRGMON_BHABHA INTEGER Y TOTAL_EVENTS INTEGER Y START_TIME TIMESTAMP N RUN_TYPE_ID SMALLINT N RECONSTRUCT_ID SMALLINT Y ON_DISK SMALLINT N NORMAL_END SMALLINT Y L3_LUMINOSITY DOUBLE Y L3_INT_LUM DOUBLE Y L3_BHABHA INTEGER Y END_TIME TIMESTAMP Y DAFNE_VACUUM DOUBLE Y DAFNE_TSW4 INTEGER Y DAFNE_TSW3 INTEGER Y DAFNE_TSW2 INTEGER Y DAFNE_TSW1 INTEGER Y DAFNE_LUMINOSITY DOUBLE Y DAFNE_LTP INTEGER Y DAFNE_LTM INTEGER Y DAFNE_IP REAL Y DAFNE_IM REAL Y DAFNE_FILL INTEGER Y

---

LOGGER.RAW_LOGGER Field Type Nullable RUN_NR INTEGER N FARM_ID CHARACTER(3) N RECEIVER_NR SMALLINT N BUILDER_NR SMALLINT N STREAM_ID SMALLINT N RECORDER_NR SMALLINT N GB_NR SMALLINT N ANALYZED INTEGER Y TSERVER_ID CHARACTER(3) Y TOTAL_EVENTS INTEGER Y SIZE INTEGER Y LAST SMALLINT N FIRST SMALLINT N FILESPACE_ID INTEGER Y FILENAME VARCHAR(64) N CREATION_TIME TIMESTAMP N CLOSURE_TIME TIMESTAMP Y ARCHIVED SMALLINT N

---

LOGGER.DATAREC_LOGGER Field Type Nullable RUN_NR INTEGER N VERSION INTEGER N OFFLINE_ID CHARACTER(3) N DATAREC_NR SMALLINT N STREAM_ID SMALLINT N GB_NR SMALLINT N ANALYZED INTEGER Y TSERVER_ID CHARACTER(3) Y TOTAL_EVENTS INTEGER Y SIZE INTEGER Y LAST SMALLINT N FIRST SMALLINT N FILESPACE_ID INTEGER Y FILENAME VARCHAR(64) N CREATION_TIME TIMESTAMP N CLOSURE_TIME TIMESTAMP Y ARCHIVED SMALLINT N

---

LOGGER.DATAREC_RAWS Field Type Nullable RUN_NR INTEGER N DATAREC_VERSION INTEGER N DATAREC_OFFLINE_ID CHARACTER(3) N DATAREC_NR SMALLINT N DATAREC_STREAM_ID SMALLINT N DATAREC_GB_NR SMALLINT N RAW_FARM_ID CHARACTER(3) N RAW_RECEIVER_NR SMALLINT N RAW_BUILDER_NR SMALLINT N RAW_STREAM_ID SMALLINT N RAW_RECORDER_NR SMALLINT N RAW_GB_NR SMALLINT N

---