B1pi monitoring dashboard schema

From GlueXWiki
Jump to: navigation, search

Proof of Concept

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    |                |
+----------------+--------------+------+-----+---------+----------------+