Difference between revisions of "SiPM Database"
From GlueXWiki
m (→Tables) |
(→MySQL Database At Jefferson Lab) |
||
| Line 1: | Line 1: | ||
= MySQL Database At Jefferson Lab = | = MySQL Database At Jefferson Lab = | ||
| + | |||
| + | A copy can be found in [https://halldweb1.jlab.org/elog-halld/SiPM/20 HallD-ELOG]. | ||
== MySQL Server == | == MySQL Server == | ||
Revision as of 18:18, 7 March 2012
Contents
MySQL Database At Jefferson Lab
A copy can be found in HallD-ELOG.
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 mm2 cells. List of columns:
- sn: Serial Number
- cell: Cell number (1-16)
- voltage: Voltage of individual channels for a 7.5×105 gain at 25C (V)
- dark_rate: Dark rate of individual channels (MHz)
