Difference between revisions of "Compton Database Scheme"

From PolWiki
Jump to navigationJump to search
(New page: 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...)
 
Line 18: Line 18:
 
*end_time: DATETIME
 
*end_time: DATETIME
 
*comment: TEXT
 
*comment: TEXT
 +
 +
==== Unorganized list of values we want to record per laser cycle =====
 +
=== PhDet ===
 +
=== eDet ===

Revision as of 14:10, 26 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

Unorganized list of values we want to record per laser cycle =

PhDet

eDet