Compton Database Scheme

From PolWiki
Revision as of 13:34, 26 June 2012 by Cornejo (talk | contribs) (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...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

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