Difference between revisions of "Compton Database Scheme"

From PolWiki
Jump to navigationJump to search
Line 39: Line 39:
 
*title: TEXT
 
*title: TEXT
  
== Unorganized list of values we want to record for every laser cycle==
+
== Unorganized list of values we want to record for every laser cycle(Laser On and Laser Off separately?)==
 
*IHWP #1 and #2
 
*IHWP #1 and #2
 
*Beam Slope(?)
 
*Beam Slope(?)
Line 51: Line 51:
 
**IPM3P02B.XPOS,IPM3P02B.YPOS,
 
**IPM3P02B.XPOS,IPM3P02B.YPOS,
 
**IPM3P03A.XPOS,IPM3P03A.XPOS,
 
**IPM3P03A.XPOS,IPM3P03A.XPOS,
 +
*IPM3C12.XPOS
 +
*IPM3C19.XPOS
 
*MCP3P03, MCP3P03M
 
*MCP3P03, MCP3P03M
 +
*photon-detector HV
 
*photon-detector Accum0 yield, Accum2 yield ...
 
*photon-detector Accum0 yield, Accum2 yield ...
*
+
*background scintillator HV
 
+
*background scintillator yield (?)
 +
*electron-detector strip yield for all individual strips
  
 
=== PhDet ===
 
=== PhDet ===
 
=== eDet ===
 
=== eDet ===

Revision as of 15:57, 27 June 2012

This page contains the proposed database scheme to store laser cycle analysis information per run. This scheme is modeled in part with the QWeak database scheme presented in Damon Spayde's collaboration talk slide 6.

good_for

  • good_for_id: INT UNSIGNED AUTO_INCREMENT
  • type: TEXT

run_quality

  • run_quality_id: INT UNSIGNED AUTO_INCREMENT
  • type: TEXT

run

  • run_id: INT_UNSIGNED AUTO_INCREMENT
  • run_number: INT UNSIGNED
  • run_type: TEXT
  • good_for_id: SET(1-40)
  • run_quality_id: SET(1-40)
  • start_time: DATETIME
  • end_time: DATETIME
  • comment: TEXT

measurement_type

  • measurement_type_id: INT UNSIGNED AUTO_INCREMENT
  • units: TEXT
  • title: TEXT

beam

  • beam_id: INT UNSIGNED AUTO_INCREMENT
  • analysis_id: INT UNSIGEND
  • monitor_id: INT UNSIGNED
  • measurement_type_id: CHAR(4)
  • subblock: TINYINT UNSIGNED
  • n: INT UNSIGNED
  • value: FLOAT
  • error:FLOAT

monitor

  • monitor_id: INT UNSIGNED AUTO_INCREMENT
  • quantity: TEXT
  • title: TEXT

Unorganized list of values we want to record for every laser cycle(Laser On and Laser Off separately?)

  • IHWP #1 and #2
  • Beam Slope(?)
  • Laser power
  • Beamline asymmetries
  • Beam current:
    • BCM6
  • Compton BPM:
    • IPM3P01A.XPOS,IPM3P01A.YPOS,
    • IPM3P02A.XPOS,IPM3P02A.YPOS,
    • IPM3P02B.XPOS,IPM3P02B.YPOS,
    • IPM3P03A.XPOS,IPM3P03A.XPOS,
  • IPM3C12.XPOS
  • IPM3C19.XPOS
  • MCP3P03, MCP3P03M
  • photon-detector HV
  • photon-detector Accum0 yield, Accum2 yield ...
  • background scintillator HV
  • background scintillator yield (?)
  • electron-detector strip yield for all individual strips

PhDet

eDet