Difference between revisions of "SiPM Database"

From GlueXWiki
Jump to: navigation, search
m
m
Line 7: Line 7:
 
* port: 3306 (MySQL default)
 
* port: 3306 (MySQL default)
 
* database name: '''halld_sipm'''
 
* database name: '''halld_sipm'''
 +
 
== Tables ==
 
== Tables ==
 +
 
=== sipm_spec ===
 
=== sipm_spec ===
 +
 +
Stores the Hamamatsu specifications for each SiPM array, list of columns:
 +
 +
* '''sn''': Serial Number
 +
* '''voltage''': Average voltage at 25C (V)
 +
* '''vol_var''': Standard deviation in voltage of individual channels (mV)
 +
* '''m_var''': Variation of gain (%, from Hamamatsu spec sheet)
 +
* '''dark_rate''': Total dark rate (MHz)
 +
* '''dr_var''': Relative standard deviation in dark rate of individual channels (%)
 +
* '''remark''': Remarks

Revision as of 18:14, 7 March 2012

MySQL Database At Jefferson Lab

MySQL Server

  • halldweb1.jlab.org
  • login: halld
  • password: the normal "halld" password as linux boxes, or ask Yi to get it
  • port: 3306 (MySQL default)
  • database name: halld_sipm

Tables

sipm_spec

Stores the Hamamatsu specifications for each SiPM array, list of columns:

  • sn: Serial Number
  • voltage: Average voltage at 25C (V)
  • vol_var: Standard deviation in voltage of individual channels (mV)
  • m_var: Variation of gain (%, from Hamamatsu spec sheet)
  • dark_rate: Total dark rate (MHz)
  • dr_var: Relative standard deviation in dark rate of individual channels (%)
  • remark: Remarks