KLOE Database

Schema: KLOEMAPS


Tables:


KLOEMAPS.BOARD_MAP_VME

Field Type Nullable
CHAIN SMALLINT N
CRATE SMALLINT N
VME_SLOT SMALLINT N
START_OF_VALIDITY INTEGER N
INSERT_TIME TIMESTAMP N
BOARD_ID SMALLINT N
VME_OFFSET INTEGER N
VME_ADDRESS INTEGER N
UPDATE_USER_ID SMALLINT Y
UPDATE_TIME TIMESTAMP Y
SERIAL_NR INTEGER Y
INSERT_USER_ID SMALLINT N
END_OF_VALIDITY INTEGER Y
Validity DESCRIPT.BOARD_DESCRIPT DESCRIPT.BOARD_DESCRIPT.Board_Id


KLOEMAPS.BOARD_MAP_AUX (view)

Field Type Nullable
BOARD_ID SMALLINT N
VME_OFFSET INTEGER N
VME_ADDRESS INTEGER N
UPDATE_USER_ID SMALLINT Y
UPDATE_TIME TIMESTAMP Y
START_OF_VALIDITY INTEGER N
SLOT INTEGER N
SERIAL_NR INTEGER Y
INSERT_USER_ID SMALLINT N
INSERT_TIME TIMESTAMP N
END_OF_VALIDITY INTEGER Y
CRATE SMALLINT N
CHAIN SMALLINT N
Validity DESCRIPT.BOARD_DESCRIPT DESCRIPT.BOARD_DESCRIPT.Board_Id BOARD_MAP_VME


KLOEMAPS.DMAP_CAL

Field Type Nullable
CHAIN SMALLINT N
CRATE SMALLINT N
SLOT SMALLINT N
CHANNEL SMALLINT N
START_OF_VALIDITY INTEGER N
INSERT_TIME TIMESTAMP N
COLUMN SMALLINT N
UPDATE_USER_ID SMALLINT Y
UPDATE_TIME TIMESTAMP Y
SUBDET_ID SMALLINT N
SIDE SMALLINT N
PLANE SMALLINT N
MODULE SMALLINT N
INSERT_USER_ID SMALLINT N
END_OF_VALIDITY INTEGER Y
Validity DESCRIPT.SUBDET_DESCRIPT DESCRIPT.SUBDET_DESCRIPT.Subdet_id


KLOEMAPS.DMAP_CHAMB

Field Type Nullable
CHAIN SMALLINT N
CRATE SMALLINT N
SLOT SMALLINT N
CHANNEL SMALLINT N
START_OF_VALIDITY INTEGER N
INSERT_TIME TIMESTAMP N
END_OF_VALIDITY INTEGER Y
WIRE SMALLINT N
UPDATE_USER_ID SMALLINT Y
UPDATE_TIME TIMESTAMP Y
LAYER SMALLINT N
INSERT_USER_ID SMALLINT N
Validity


KLOEMAPS.DMAP_QCAL

Field Type Nullable
CHAIN SMALLINT N
CRATE SMALLINT N
SLOT SMALLINT N
CHANNEL SMALLINT N
START_OF_VALIDITY INTEGER N
INSERT_TIME TIMESTAMP N
END_OF_VALIDITY INTEGER Y
UPDATE_USER_ID SMALLINT Y
UPDATE_TIME TIMESTAMP Y
SUBDET_ID SMALLINT N
MODULE SMALLINT N
INSERT_USER_ID SMALLINT N
Validity DESCRIPT.SUBDET_DESCRIPT DESCRIPT.SUBDET_DESCRIPT.Subdet_id


KLOEMAPS.DMAP_TRIGGER

Field Type Nullable
CHAIN SMALLINT N
CRATE SMALLINT N
SLOT SMALLINT N
CHANNEL SMALLINT N
START_OF_VALIDITY INTEGER N
INSERT_TIME TIMESTAMP N
END_OF_VALIDITY INTEGER Y
UPDATE_USER_ID SMALLINT Y
UPDATE_TIME TIMESTAMP Y
SUBDET_ID SMALLINT N
SIDE SMALLINT N
SERIAL_KIND SMALLINT N
SECTOR_NR SMALLINT N
INSERT_USER_ID SMALLINT N
Validity DESCRIPT.SUBDET_DESCRIPT DESCRIPT.SUBDET_DESCRIPT.Subdet_Id


KLOEMAPS.DMAP_FIO

Field Type Nullable
CHAIN SMALLINT N
CRATE SMALLINT N
SLOT SMALLINT N
CHANNEL SMALLINT N
START_OF_VALIDITY INTEGER N
INSERT_TIME TIMESTAMP N
END_OF_VALIDITY INTEGER Y
UPDATE_USER_ID SMALLINT Y
UPDATE_TIME TIMESTAMP Y
ROCK_CRATE SMALLINT N
ROCK_CHAIN SMALLINT N
INSERT_USER_ID SMALLINT N
Validity


KLOEMAPS.ROCK_MAP

Field Type Nullable
CHAIN SMALLINT N
CRATE SMALLINT N
START_OF_VALIDITY INTEGER N
INSERT_TIME TIMESTAMP N
END_OF_VALIDITY INTEGER Y
UPDATE_USER_ID SMALLINT Y
UPDATE_TIME TIMESTAMP Y
TOKEN_BYPASS SMALLINT N
INSERT_USER_ID SMALLINT N
Validity


KLOEMAPS.DISH_MAP

Field Type Nullable
CHAIN SMALLINT N
CRATE SMALLINT N
SLOT SMALLINT N
START_OF_VALIDITY INTEGER N
INSERT_TIME TIMESTAMP N
END_OF_VALIDITY INTEGER Y
UPDATE_USER_ID SMALLINT Y
UPDATE_TIME TIMESTAMP Y
TRESHOLDS BLOB N
LOGIC SMALLINT N
INSERT_USER_ID SMALLINT N
Validity


KLOEMAPS.TORTA_MAP

Field Type Nullable
START_OF_VALIDITY INTEGER N
INSERT_TIME TIMESTAMP N
ACQ_ON INTEGER N
UPDATE_USER_ID SMALLINT Y
UPDATE_TIME TIMESTAMP Y
TRG_NR INTEGER N
T2REG INTEGER N
T2ERR INTEGER N
T1P_RNG INTEGER N
T1P_DIV INTEGER N
RSTF INTEGER N
PARTITIONED SMALLINT N
INSERT_USER_ID SMALLINT N
IDFNAME VARCHAR(16) Y
END_OF_VALIDITY INTEGER Y
DOWN_VETO INTEGER N
DOWN_T1D INTEGER N
DOWN_T1C INTEGER N
DOWN_T0D INTEGER N
DOWN_EW INTEGER N
DOWN_EH INTEGER N
DOWN_EC INTEGER N
DOWN_CR INTEGER N
DOWN_BB INTEGER N
DOWN_2 INTEGER N
DOWN_1E INTEGER N
DOWN_1B INTEGER N
Validity DESCRIPT.PARTIT_DESCRIPT DESCRIPT.PARTIT_DESCRIPT.Partitioned


KLOEMAPS.DAQ_DFC

Field Type Nullable
START_OF_VALIDITY INTEGER N
INSERT_TIME TIMESTAMP N
END_OF_VALIDITY INTEGER Y
UPDATE_USER_ID SMALLINT Y
UPDATE_TIME TIMESTAMP Y
PARAMETERS VARCHAR(128) N
NODE_NAME VARCHAR(32) N
INSERT_USER_ID SMALLINT N
Validity


KLOEMAPS.DAQ_RC

Field Type Nullable
START_OF_VALIDITY INTEGER N
INSERT_TIME TIMESTAMP N
END_OF_VALIDITY INTEGER Y
UPDATE_USER_ID SMALLINT Y
UPDATE_TIME TIMESTAMP Y
NODE_NAME VARCHAR(32) N
INSERT_USER_ID SMALLINT N
Validity


KLOEMAPS.DAQ_L2

Field Type Nullable
CHAIN SMALLINT N
START_OF_VALIDITY INTEGER N
INSERT_TIME TIMESTAMP N
END_OF_VALIDITY INTEGER Y
UPDATE_USER_ID SMALLINT Y
UPDATE_TIME TIMESTAMP Y
NODE_NAME VARCHAR(32) N
INSERT_USER_ID SMALLINT N
Validity


KLOEMAPS.DAQ_TRIGGER

Field Type Nullable
START_OF_VALIDITY INTEGER N
INSERT_TIME TIMESTAMP N
END_OF_VALIDITY INTEGER Y
UPDATE_USER_ID SMALLINT Y
UPDATE_TIME TIMESTAMP Y
NODE_NAME VARCHAR(32) N
INSERT_USER_ID SMALLINT N
Validity


KLOEMAPS.DAQ_FARM

Field Type Nullable
NODE_NAME VARCHAR(32) N
START_OF_VALIDITY INTEGER N
INSERT_TIME TIMESTAMP N
END_OF_VALIDITY INTEGER Y
UPDATE_USER_ID SMALLINT Y
UPDATE_TIME TIMESTAMP Y
NR_RECORDERS_PB SMALLINT N
NR_RECEIVERS SMALLINT N
NR_BUILDERS_PR SMALLINT N
INSERT_USER_ID SMALLINT N
Validity DESCRIPT.FARM_NAME DESCRIPT.FARM_NAME.Farm_Name


KLOE Database Top of the page.
Send comments to: Igor Sfiligoi

Created by htmltables on Sun Jan 30 17:53:57 MET 2000