KLOE Database

Schema: DESCRIPT

• DESCRIPT.DETECTOR_DESCRIPT
• DESCRIPT.BOARD_DESCRIPT
• DESCRIPT.SUBDET_DESCRIPT
• DESCRIPT.SUBDET_DSC_CAL
• DESCRIPT.SUBDET_DSC_QCAL
• DESCRIPT.PARTIT_DESCRIPT
• DESCRIPT.RUN_TYPE_DESCRIPT
• DESCRIPT.FILE_STATUS
• DESCRIPT.STREAM_DESCRIPT
• DESCRIPT.ARCHIVED_STATUS
• DESCRIPT.FARMDIR_DESCRIPT
• DESCRIPT.OFFDIR_DESCRIPT
• DESCRIPT.STREAM_OFFLINE
• DESCRIPT.MACHINE_NAME
• DESCRIPT.OS_DESCRIPT
• DESCRIPT.MACHINE_DESCRIPT
• DESCRIPT.FARM_NODE
• DESCRIPT.FARM_NAME
• DESCRIPT.FARM_DESCRIPT
• DESCRIPT.OFFLINE_NODE
• DESCRIPT.OFFLINE_NAME
• DESCRIPT.OFFLINE_DESCRIPT
• DESCRIPT.TSERVER_NODE
• DESCRIPT.TSERVER_NAME
• DESCRIPT.TSERVER_DESCRIPT
• DESCRIPT.DSERVER_NODE
• DESCRIPT.DSERVER_DESCRIPT
• DESCRIPT.DSRVDIR_DESCRIPT
• DESCRIPT.MOUNT_OFF_FARM
• DESCRIPT.MOUNT_OFF_DSRV
• DESCRIPT.MOUNT_TSRV_FARM
• DESCRIPT.MOUNT_TSRV_DSRV
• DESCRIPT.FILESPACE_FARM
• DESCRIPT.FILESPACE_OFFLINE
• DESCRIPT.FS_LAST_FARM
• DESCRIPT.FS_LAST_OFFLINE
• DESCRIPT.DSERVER_NAME
• DESCRIPT.OFFSRV_NODE
• DESCRIPT.OFFSRV_DESCRIPT
• DESCRIPT.OFFSRV_NAME
• DESCRIPT.OFFSRVDIR_DESCRIPT
• DESCRIPT.MOUNT_TSRV_OFF
• DESCRIPT.FILESPACE_MC
• DESCRIPT.FS_LAST_MC
• DESCRIPT.MOUNT_DSRV_FARM
• DESCRIPT.MOUNT_DSRV_OFF
• DESCRIPT.MOUNT_DSRV_DSRV
• DESCRIPT.RECONSTRUCT_DESCR
• DESCRIPT.MCCARD_GROUP
• DESCRIPT.MCCARD_DESCRIPT
• DESCRIPT.MCSTREAM_GROUP
• DESCRIPT.MCSTREAM_DESCRIPT

DESCRIPT.DETECTOR_DESCRIPT Field Type Nullable DETECTOR_ID SMALLINT N DESCRIPTION VARCHAR(32) N

---

DESCRIPT.BOARD_DESCRIPT Field Type Nullable BOARD_ID SMALLINT N DESCRIPTION VARCHAR(32) N DETECTOR_ID SMALLINT N

---

DESCRIPT.SUBDET_DESCRIPT Field Type Nullable SUBDET_ID SMALLINT N DESCRIPTION VARCHAR(16) N DETECTOR_ID SMALLINT N

---

DESCRIPT.SUBDET_DSC_CAL (view) Field Type Nullable DESCRIPTION VARCHAR(16) N SUBDET_ID SMALLINT N DETECTOR_ID SMALLINT N

---

DESCRIPT.SUBDET_DSC_QCAL (view) Field Type Nullable DESCRIPTION VARCHAR(16) N SUBDET_ID SMALLINT N DETECTOR_ID SMALLINT N

---

DESCRIPT.PARTIT_DESCRIPT Field Type Nullable PARTITIONED SMALLINT N DESCRIPTION VARCHAR(32) N

---

DESCRIPT.RUN_TYPE_DESCRIPT Field Type Nullable RUN_TYPE_ID SMALLINT N CODE VARCHAR(8) N WAITSYNC SMALLINT N DESCRIPTION VARCHAR(48) N

---

DESCRIPT.FILE_STATUS Field Type Nullable STATUS SMALLINT N DESCRIPTION VARCHAR(32) N

---

DESCRIPT.STREAM_DESCRIPT Field Type Nullable STREAM_ID SMALLINT N CODE VARCHAR(8) N DESCRIPTION VARCHAR(64) N

---

DESCRIPT.ARCHIVED_STATUS Field Type Nullable STATUS SMALLINT N DESCRIPTION VARCHAR(32) N

---

DESCRIPT.FARMDIR_DESCRIPT Field Type Nullable FARM_ID CHARACTER(3) N FARMDIR_ID SMALLINT N PATH VARCHAR(248) N

---

DESCRIPT.OFFDIR_DESCRIPT Field Type Nullable OFFLINE_ID CHARACTER(3) N OFFDIR_ID SMALLINT N OFFSRV_ID CHARACTER(3) Y PATH VARCHAR(248) N OFFSRVDIR_ID SMALLINT Y

---

DESCRIPT.STREAM_OFFLINE Field Type Nullable STREAM_ID SMALLINT N CODE VARCHAR(8) N DESCRIPTION VARCHAR(64) N

---

DESCRIPT.MACHINE_NAME Field Type Nullable NAME VARCHAR(32) N ID CHARACTER(3) N

---

DESCRIPT.OS_DESCRIPT Field Type Nullable PLATFORM VARCHAR(8) N

---

DESCRIPT.MACHINE_DESCRIPT Field Type Nullable ID CHARACTER(3) N DESCRIPTION VARCHAR(128) N PLATFORM VARCHAR(8) N NR_CPUS INTEGER N

---

DESCRIPT.FARM_NODE Field Type Nullable FARM_ID CHARACTER(3) N

---

DESCRIPT.FARM_NAME (view) Field Type Nullable FARM_ID CHARACTER(3) N FARM_NAME VARCHAR(32) N

---

DESCRIPT.FARM_DESCRIPT (view) Field Type Nullable DESCRIPTION VARCHAR(128) N PLATFORM VARCHAR(8) N NR_CPUS INTEGER N FARM_ID CHARACTER(3) N

---

DESCRIPT.OFFLINE_NODE Field Type Nullable OFFLINE_ID CHARACTER(3) N

---

DESCRIPT.OFFLINE_NAME (view) Field Type Nullable OFFLINE_ID CHARACTER(3) N OFFLINE_NAME VARCHAR(32) N

---

DESCRIPT.OFFLINE_DESCRIPT (view) Field Type Nullable DESCRIPTION VARCHAR(128) N PLATFORM VARCHAR(8) N OFFLINE_ID CHARACTER(3) N NR_CPUS INTEGER N

---

DESCRIPT.TSERVER_NODE Field Type Nullable TSERVER_ID CHARACTER(3) N NR_DRIVES SMALLINT N

---

DESCRIPT.TSERVER_NAME (view) Field Type Nullable TSERVER_ID CHARACTER(3) N TSERVER_NAME VARCHAR(32) N

---

DESCRIPT.TSERVER_DESCRIPT (view) Field Type Nullable DESCRIPTION VARCHAR(128) N TSERVER_ID CHARACTER(3) N PLATFORM VARCHAR(8) N NR_DRIVES SMALLINT N NR_CPUS INTEGER N

---

DESCRIPT.DSERVER_NODE Field Type Nullable DSERVER_ID CHARACTER(3) N

---

DESCRIPT.DSERVER_DESCRIPT (view) Field Type Nullable DESCRIPTION VARCHAR(128) N PLATFORM VARCHAR(8) N NR_CPUS INTEGER N DSERVER_ID CHARACTER(3) N

---

DESCRIPT.DSRVDIR_DESCRIPT Field Type Nullable DSERVER_ID CHARACTER(3) N DSRVDIR_ID SMALLINT N PATH VARCHAR(248) N

---

DESCRIPT.MOUNT_OFF_FARM Field Type Nullable OFFLINE_ID CHARACTER(3) N FARM_ID CHARACTER(3) N FARMDIR_ID SMALLINT N MOUNTPOINT VARCHAR(248) N

---

DESCRIPT.MOUNT_OFF_DSRV Field Type Nullable OFFLINE_ID CHARACTER(3) N DSERVER_ID CHARACTER(3) N DSRVDIR_ID SMALLINT N MOUNTPOINT VARCHAR(248) N

---

DESCRIPT.MOUNT_TSRV_FARM Field Type Nullable TSERVER_ID CHARACTER(3) N FARM_ID CHARACTER(3) N FARMDIR_ID SMALLINT N MOUNTPOINT VARCHAR(248) N

---

DESCRIPT.MOUNT_TSRV_DSRV Field Type Nullable TSERVER_ID CHARACTER(3) N DSERVER_ID CHARACTER(3) N DSRVDIR_ID SMALLINT N MOUNTPOINT VARCHAR(248) N

---

DESCRIPT.FILESPACE_FARM Field Type Nullable TSERVER_ID CHARACTER(3) N STREAM_ID SMALLINT N FILESPACE_ID INTEGER N FILESPACE VARCHAR(248) N

---

DESCRIPT.FILESPACE_OFFLINE Field Type Nullable TSERVER_ID CHARACTER(3) N STREAM_ID SMALLINT N FILESPACE_ID INTEGER N FILESPACE VARCHAR(248) N

---

DESCRIPT.FS_LAST_FARM (view) Field Type Nullable FILESPACE VARCHAR(248) N TSERVER_ID CHARACTER(3) N STREAM_ID SMALLINT N FILESPACE_ID INTEGER N

---

DESCRIPT.FS_LAST_OFFLINE (view) Field Type Nullable FILESPACE VARCHAR(248) N TSERVER_ID CHARACTER(3) N STREAM_ID SMALLINT N FILESPACE_ID INTEGER N

---

DESCRIPT.DSERVER_NAME (view) Field Type Nullable DSERVER_ID CHARACTER(3) N DSERVER_NAME VARCHAR(32) N

---

DESCRIPT.MOUNT_TSRV_OFF Field Type Nullable TSERVER_ID CHARACTER(3) N OFFSRV_ID CHARACTER(3) N OFFSRVDIR_ID SMALLINT N MOUNTPOINT VARCHAR(248) N

---