Difference between revisions of "B1pi monitoring dashboard schema"
From GlueXWiki
(Created page with "<pre> id - unique identified platform - string (BMS_OSNAME) run - int recon_pi0 - int recon_omega -int recon_b1 -int recon_b1pi - int gen_photons - int gen_protons - int ge...") |
|||
(4 intermediate revisions by one other user not shown) | |||
Line 1: | Line 1: | ||
+ | [https://halldweb.jlab.org/data_monitoring/Dashboard.html Proof of Concept] | ||
+ | |||
+ | database = data_monitoring table = b1pi_test_data | ||
+ | |||
<pre> | <pre> | ||
− | id - unique | + | id - unique identifier |
platform - string (BMS_OSNAME) | platform - string (BMS_OSNAME) | ||
+ | date_generated - date | ||
run - int | run - int | ||
recon_pi0 - int | recon_pi0 - int | ||
Line 18: | Line 23: | ||
comment - string | comment - string | ||
− | <pre> | + | |
+ | +----------------+--------------+------+-----+---------+----------------+ | ||
+ | | Field | Type | Null | Key | Default | Extra | | ||
+ | +----------------+--------------+------+-----+---------+----------------+ | ||
+ | | id | int(11) | NO | PRI | NULL | auto_increment | | ||
+ | | platform | varchar(100) | YES | | NULL | | | ||
+ | | date_generated | date | NO | | NULL | | | ||
+ | | run | int(11) | NO | | NULL | | | ||
+ | | recon_pi0 | int(11) | YES | | NULL | | | ||
+ | | recon_omega | int(11) | YES | | NULL | | | ||
+ | | recon_b1 | int(11) | YES | | NULL | | | ||
+ | | recon_b1pi | int(11) | YES | | NULL | | | ||
+ | | gen_photons | int(11) | YES | | NULL | | | ||
+ | | gen_protons | int(11) | YES | | NULL | | | ||
+ | | gen_pip | int(11) | YES | | NULL | | | ||
+ | | gen_pim | int(11) | YES | | NULL | | | ||
+ | | recon_photons | int(11) | YES | | NULL | | | ||
+ | | recon_protons | int(11) | YES | | NULL | | | ||
+ | | recon_pip | int(11) | YES | | NULL | | | ||
+ | | recon_pim | int(11) | YES | | NULL | | | ||
+ | | config | text | YES | | NULL | | | ||
+ | | comment | varchar(255) | YES | | NULL | | | ||
+ | +----------------+--------------+------+-----+---------+----------------+ | ||
+ | </pre> |
Latest revision as of 13:41, 19 April 2018
database = data_monitoring table = b1pi_test_data
id - unique identifier platform - string (BMS_OSNAME) date_generated - date run - int recon_pi0 - int recon_omega -int recon_b1 -int recon_b1pi - int gen_photons - int gen_protons - int gen_pip - int gen_pim - int recon_photons - int recon_protons - int recon_pip - int recon_pim - int config - string comment - string +----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | platform | varchar(100) | YES | | NULL | | | date_generated | date | NO | | NULL | | | run | int(11) | NO | | NULL | | | recon_pi0 | int(11) | YES | | NULL | | | recon_omega | int(11) | YES | | NULL | | | recon_b1 | int(11) | YES | | NULL | | | recon_b1pi | int(11) | YES | | NULL | | | gen_photons | int(11) | YES | | NULL | | | gen_protons | int(11) | YES | | NULL | | | gen_pip | int(11) | YES | | NULL | | | gen_pim | int(11) | YES | | NULL | | | recon_photons | int(11) | YES | | NULL | | | recon_protons | int(11) | YES | | NULL | | | recon_pip | int(11) | YES | | NULL | | | recon_pim | int(11) | YES | | NULL | | | config | text | YES | | NULL | | | comment | varchar(255) | YES | | NULL | | +----------------+--------------+------+-----+---------+----------------+