Version: 10.08.01
========

Contact: joerg.dubbert@physik.uni-muenchen.de
========


Documentation for the LMM Local Database
=========================================

- The Local Template version 0.0 of 01.01.2001 is used

- The original Tube table has been deleted

- Contains the LocBat, QcOpPar, PlugBat, Tube and WirBat tables from the
  JNR local database

- The Tube table from the JNR database is renamed to TubeJNR_local

  The RepMeasMarker is set if the tube has been remeasured at LMM


- LMM measurements are contained in the new TubeLMM_local table

  It contains the following fields:

  IdTube             tube id
  RejCode            rejection code, see RejCode table  
  QcDateTime         date/time of Qc
  QcOp               operator
  QcWdyA             wire displacement y-coord. side A at 0 degree meas. 
  QcWdzA             wire displacement z-coord. side A at 0 degree meas. 
  QcWdyB             wire displacement y-coord. side B at 0 degree meas. 
  QcWdzB             wire displacement z-coord. side B at 0 degree meas. 
  QcWdyA180          wire displacement y-coord. side A at 180 degree meas. 
  QcWdzA180          wire displacement z-coord. side A at 180 degree meas. 
  QcWdyB180          wire displacement y-coord. side B at 180 degree meas. 
  QcWdzB180          wire displacement z-coord. side B at 180 degree meas. 
  QcWirFrq           uncorrected wire frequency
  QcTemp             temperature during wire frequency meas.
  QcGasLeak          gas leakage (currently not filled)
  QcCurrLeak         leakage current at 3400 V in nA
  QcCosmic           rate in cosmic ray test (not filled)
  Comment            tube location, see Comment table 
  
- New CommentLMM table 
  
  LMM                tube kept at LMM
  MPI                tube send to MPI
  RIP                tube destroyed at LMM

- New OcOpLMM table

  contains the abrevations and names of the QC operators


- MPI measurements are contained in the new TubeMPI_local table

  It contains the following fields

  IdTube             tube id
  IdLayer            layer id
  AsTubeLoc          tube location
  QcDateTime         date/time of Qc
  QcQcWirFrq         uncorrected wire frequency
  QcTemp             temperature during wire frequency meas.
  AsWirYSiteRO       y wire position measured during assembly
  AsWirYSiteHV       y wire position measured during assembly