Difference between revisions of "SiPM Database"

From GlueXWiki
Jump to: navigation, search
m (sipm_spec)
m (sipm_spec)
Line 12: Line 12:
 
=== sipm_spec ===
 
=== sipm_spec ===
  
The table stores the Hamamatsu specifications for each SiPM array.
+
The table stores the Hamamatsu specifications for SiPM arrays. List of columns:
 
+
List of columns:
+
  
 
* '''sn''': Serial Number
 
* '''sn''': Serial Number
Line 23: Line 21:
 
* '''dr_var''': Relative standard deviation in dark rate of individual channels (%)
 
* '''dr_var''': Relative standard deviation in dark rate of individual channels (%)
 
* '''remark''': Remarks
 
* '''remark''': Remarks
 +
 +
=== sipm_spec_tile ===
 +
 +
The table stores the Hamamatsu specifications for individual 3×3 cells. List of columns:

Revision as of 18:16, 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

The table stores the Hamamatsu specifications for SiPM arrays. 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

sipm_spec_tile

The table stores the Hamamatsu specifications for individual 3×3 cells. List of columns: