B1pi monitoring dashboard schema
From GlueXWiki
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 | | +----------------+--------------+------+-----+---------+----------------+