Compton Database Scheme

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