Privacy and Security Notice

G0 Database Table Structure

G0 Database Table Structure

Table of Contents

Tables

run

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
run_id INT UNSIGNED AUTO_INCREMENT Primary No
run_number Number of run from CODA INT UNSIGNED No
run_type Type of run (filled from run_control) TEXT Yes NULL
good_for Data set(s) to which this run belongs SET("production", "pzt_scan", "ia_scan", "wells_q", "wells_p", "target_density", "calibration_bcm", "calibration_bpm", "dnl", "rwp_scan", "cosmics", "green_blocks", "fb_calib", "120_hz", "daq_test", "gms", "deadtime", "q2", "coil_pulsing", "other", "halo", "harp_scan", "polarimetry", "sos_cerenkov", "reverse_polarity", "wire_chamber", "31MHz", "transverse", "sms_scan") Yes NULL
data_quality Quality of this run (does it belong in the final physics result) SET("good", "bad", "junk", "spiky", "high_halo", "not_all_good", "unstable_beam") Yes NULL
start_time Time run began DATETIME Yes NULL
end_time Time run ended DATETIME Yes NULL
n_mps Number of MPSs in run INT UNSIGNED Yes NULL
n_qrt Number of quartets in run INT UNSIGNED Yes NULL
n_fastbus Number of fastbus events in run INT UNSIGNED Yes NULL
comment Additional comment on the purpose or data quality of the run, if required. TEXT Yes NULL
Additional Indices
Name Type Fields
unique run_number, run_id
unique good_for, data_quality, run_number, run_id
unique run_number, good_for, data_quality, run_id

analysis

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
analysis_id INT UNSIGNED AUTO_INCREMENT Primary No
run_id Run that was replayed INT UNSIGNED Foreign No run.run_id
time Time run was replayed DATETIME Yes NULL
calibration_id Specifies set of calibrations used to replay this run INT UNSIGNED Foreign No calibration.calibration_id
cut_id Specifies set of cuts used to replay this run INT UNSIGNED Foreign No cut.cut_id
deadtime_rates_id Specifies set of deadtime rates used to replay this run INT UNSIGNED Foreign No deadtime_rates.deadtime_rates_id
seed_id ID of seed used for blinding factor calculation. INT UNSIGNED Foreign Yes NULL seeds.seed_id
bf_checksum Blinding factor checksum (NULL if blinding factor calculation not performed) CHAR(32) Yes NULL
n_mps_good Number of good MPS INT UNSIGNED Yes NULL
n_qrt Number of good quartets INT UNSIGNED Yes NULL
first_event First event replayed (g0analysis flag) INT UNSIGNED Yes NULL
last_event Last event replayed (g0analysis flag) INT UNSIGNED Yes NULL
segment Run segment replayed (if specified on g0analysis command line) INT Yes NULL
tscfg Trigger supervisor configuration file name TEXT Yes NULL
na_dt North American deadtime correction flag TEXT Yes NULL
fr_dt French deadtime correction flag TEXT Yes NULL
na_rd North American random correction flag TEXT Yes NULL
french_rd French random correction flag TEXT Yes NULL
na_e_pi North American electron pion correction flag TEXT Yes NULL
french_e_pi French electron pion correction flag TEXT Yes NULL
slope_calculation Calculation of yield slopes enabled (on/off) ENUM("on", "off") Yes NULL
slope_correction Correction of yield slopes enabled (on/off) ENUM("on", "off") Yes NULL
fb_setup FastBus setup file name TEXT Yes NULL
yield_cut Cut on yield (on/off) ENUM("on", "off") Yes NULL
high_yield_cut Number of quarter "0.25" sigma used for high yield cut INT UNSIGNED Yes NULL
low_yield_cut Number of quarter "0.25" sigma used for low yield cut INT UNSIGNED Yes NULL
beam_mode Beam motion used to calculate slopes, natural or pulsed. ENUM("nbm", "cp")
analyzer_version Full path to the G0ANALYSIS directory used for this analysis. TEXT Yes NULL
NCD_correction_number_mps Number of mps used in NCD calculation INT UNSIGNED Yes NULL
Additional Indices
Name Type Fields
unique run_id, analysis_id
run_id, slope_correction, analysis_id

matrix_sums

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
matrix_sum_id INT UNSIGNED AUTO_INCREMENT Primary No
analysis_id Run that was replayed INT UNSIGNED Foreign No analysis.analysis_id
octant_id Octant number INT UNSIGNED No
measurement_type_id Type of measurement (yield, asymmetry, etc.) CHAR(4) Foreign No measurement_types.measurement_type_id
particle cerenkov off or on (pion or electron) ENUM("pi", "e") Yes NULL
locus_type_id INT UNSIGNED No locus_types.locus_type_id
n_qrt Number of good quartets INT UNSIGNED Yes NULL
value Value of measurement FLOAT Yes NULL
error Error on measurement FLOAT Yes NULL
Additional Indices
Name Type Fields
analysis_id, measurement_type_id

pion_matrix

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
pion_matrix_id INT UNSIGNED AUTO_INCREMENT Primary No
run_id Run ID INT UNSIGNED Foreign No run.run_id
octant_id Octant number INT UNSIGNED No
pion_matrix_type contents of pion matrix ENUM("pion", "random","other") Yes NULL

coincidence

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
coincidence_id INT UNSIGNED AUTO_INCREMENT Primary No
analysis_id Run that was replayed INT UNSIGNED Foreign No analysis.analysis_id
c_detector_id Detector for this measurement INT UNSIGNED Foreign No c_detectors.c_detector_id
measurement_type_id Type of measurement (yield, asymmetry, etc.) CHAR(4) Foreign No measurement_types.measurement_type_id
n_qrt Number of good quartets INT UNSIGNED Yes NULL
value Value of measurement FLOAT Yes NULL
error Error on measurement FLOAT Yes NULL
Additional Indices
Name Type Fields
unique analysis_id, c_detector_id, measurement_type_id
c_detector_id, measurement_type_id

singles_ced

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
single_ced_id INT UNSIGNED AUTO_INCREMENT Primary No
analysis_id Run that was replayed INT UNSIGNED Foreign No analysis.analysis_id
s_ced_detector_id Detector for this measurement INT UNSIGNED Foreign No s_ced_detectors.s_ced_detector_id
measurement_type_id Type of measurement (yield, asymmetry, etc.) CHAR(4) Foreign No measurement_types.measurement_type_id
n_qrt Number of good quartets INT UNSIGNED Yes NULL
value Value of measurement FLOAT Yes NULL
error Error on measurement FLOAT Yes NULL
Additional Indices
Name Type Fields
unique analysis_id, s_ced_detector_id, measurement_type_id
s_ced_detector_id, measurement_type_id

NCD_correction

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
NCD_correction_id INT UNSIGNED AUTO_INCREMENT Primary No
ced_id ced with missing data INT UNSIGNED No
NCD_slope slope used to calculate value FLOAT Yes NULL
NCD_intercept value of intercept FLOAT Yes NULL

singles_fpd

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
single_fpd_id INT UNSIGNED AUTO_INCREMENT Primary No
analysis_id Run that was replayed INT UNSIGNED Foreign No analysis.analysis_id
s_fpd_detector_id Detector for this measurement INT UNSIGNED Foreign No s_fpd_detectors.s_fpd_detector_id
measurement_type_id Type of measurement (yield, asymmetry, etc.) CHAR(4) Foreign No measurement_types.measurement_type_id
n_qrt Number of good quartets INT UNSIGNED Yes NULL
value Value of measurement FLOAT Yes NULL
error Error on measurement FLOAT Yes NULL
Additional Indices
Name Type Fields
unique analysis_id, s_fpd_detector_id, measurement_type_id
s_fpd_detector_id, measurement_type_id

bad_octants

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
bad_octants_id INT UNSIGNED AUTO_INCREMENT Primary No
bad_octant_type_id identifies what is wrong with the octant INT UNSIGNED No bad_octant_types.bad_octant_type_id
run_id run id INT UNSIGNED No run.run_id
octant_id octant id INT UNSIGNED No

bad_octant_types

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
bad_octant_type_id INT UNSIGNED AUTO_INCREMENT Primary No
bad_octant_type describes what is wrong with the octant TEXT No

multihits_ced

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
multihit_ced_id INT UNSIGNED AUTO_INCREMENT Primary No
analysis_id Run that was replayed INT UNSIGNED Foreign No analysis.analysis_id
mh_ced_detector_id Detector for this measurement INT UNSIGNED Foreign No mh_ced_detectors.mh_ced_detector_id
measurement_type_id Type of measurement (yield, asymmetry, etc.) CHAR(4) Foreign No measurement_types.measurement_type_id
n_qrt Number of good quartets INT UNSIGNED Yes NULL
value Value of measurement FLOAT Yes NULL
error Error on measurement FLOAT Yes NULL
Additional Indices
Name Type Fields
unique analysis_id, mh_ced_detector_id, measurement_type_id
mh_ced_detector_id, measurement_type_id

multihits_fpd

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
multihit_fpd_id INT UNSIGNED AUTO_INCREMENT Primary No
analysis_id Run that was replayed INT UNSIGNED Foreign No analysis.analysis_id
mh_fpd_detector_id Detector for this measurement INT UNSIGNED Foreign No mh_fpd_detectors.mh_fpd_detector_id
measurement_type_id Type of measurement (yield, asymmetry, etc.) CHAR(4) Foreign No measurement_types.measurement_type_id
n_qrt Number of good quartets INT UNSIGNED Yes NULL
value Value of measurement FLOAT Yes NULL
error Error on measurement FLOAT Yes NULL
Additional Indices
Name Type Fields
unique analysis_id, mh_fpd_detector_id, measurement_type_id
mh_fpd_detector_id, measurement_type_id

locus

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
locus_id INT UNSIGNED AUTO_INCREMENT Primary No
first_run_id First run_id for this range INT UNSIGNED Yes NULL
last_run_id Last run_id for this range INT UNSIGNED Yes NULL
min_run_id Minimum run_id for this range (deprecated) INT UNSIGNED Yes NULL
max_run_id Maximum run_id for this range(deprecated) INT UNSIGNED Yes NULL

deadtime

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
deadtime_id INT UNSIGNED AUTO_INCREMENT Primary No
first_run_id First run_id for this range INT UNSIGNED Yes NULL
last_run_id Last run_id for this range INT UNSIGNED Yes NULL

locus_data

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
locus_data_id INT UNSIGNED AUTO_INCREMENT Primary No
locus_id Range for this data INT UNSIGNED Foreign No locus.locus_id
c_detector_id Detectors for this range INT UNSIGNED Foreign No c_detectors.c_detector_id
type Type of detector data (deprecated) ENUM("elastic", "inelastic", "background") Yes NULL
locus_type_id Type of detector data INT UNSIGNED No

deadtime_data

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
deadtime_data_id INT UNSIGNED AUTO_INCREMENT Primary No
deadtime_id Range for this data INT UNSIGNED Foreign No deadtime.deadtime_id
deadtime_type_id deadtime parameter for this range INT UNSIGNED Foreign No deadtime_types.deadtime_type_id
octant_id Octant number INT UNSIGNED No
value Value of deadtime parameter FLOAT Yes NULL

slopes

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
slope_id INT UNSIGNED AUTO_INCREMENT Primary No
analysis_id Run that was replayed INT UNSIGNED Foreign No analysis.analysis_id
c_detector_id Detector for this measurement INT UNSIGNED Foreign No c_detectors.c_detector_id
slope_type_id Type of slope INT UNSIGNED Foreign No slopes.slope_type_id
n_mps Number of good MPS INT UNSIGNED Yes NULL
value Value of slope FLOAT Yes NULL
error Error on slope FLOAT Yes NULL
Additional Indices
Name Type Fields
unique analysis_id, c_detector_id, slope_type_id
c_detector_id, slope_type_id

beam

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
beam_id INT UNSIGNED AUTO_INCREMENT Primary No
analysis_id Run that was replayed INT UNSIGNED Foreign No analysis.analysis_id
monitor_id Monitor for this measurement INT UNSIGNED Foreign No monitors.monitor_id
measurement_type_id Type of measurement (yield, asymmetry, etc.) CHAR(4) Foreign No measurement_types.measurement_type_id
value Value of measurement FLOAT Yes NULL
error Error on measurement FLOAT Yes NULL
Additional Indices
Name Type Fields
unique analysis_id, monitor_id, measurement_type_id
unique analysis_id, measurement_type_id, monitor_id

cuts

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
cut_id INT UNSIGNED AUTO_INCREMENT Primary No
analysis_id Run that was replayed to generate these cuts INT UNSIGNED Foreign No analysis.analysis_id
time Time cuts were inserted into database DATETIME Yes NULL
comment User comment TEXT Yes NULL
Additional Indices
Name Type Fields
unique analysis_id, cut_id

cuts_data

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
cuts_data_id INT UNSIGNED AUTO_INCREMENT Primary No
cut_id Set of cuts that this cut belongs to INT UNSIGNED Foreign No cuts.cut_id
monitor_id Quantity to cut on INT UNSIGNED Foreign No monitors.monitor_id
min Minimum value of cut FLOAT Yes NULL
max Maximum value of cut FLOAT Yes NULL
Additional Indices
Name Type Fields
unique cut_id, monitor_id

measurement_types

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
measurement_type_id Type of measurement (yield, asymmetry, etc.) CHAR(4) Primary No
units Units of measurement (?, ppm) TEXT Yes NULL
title Axis title ("Detector Yield", "Detector Asymmetry") TEXT Yes NULL

slope_types

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
slope_type_id Type of slope INT UNSIGNED AUTO_INCREMENT Primary No
slope Name of slope TEXT Yes NULL
units Units of slope TEXT Yes NULL
title Axis title TEXT Yes NULL

monitors

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
monitor_id INT UNSIGNED AUTO_INCREMENT Primary No
quantity Name of beam property TEXT Yes NULL
title Axis title TEXT Yes NULL
Additional Indices
Name Type Fields
unique quantity, monitor_id

monitor_slopes

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
monitor_slope_id INT UNSIGNED AUTO_INCREMENT Primary No
analysis_id Run that was replayed INT UNSIGNED Foreign No analysis.analysis_id
monitor_id Monitor for this measurement INT UNSIGNED Foreign No monitors.monitor_id
monitor_slope_type_id Type of monitor_slope INT UNSIGNED Foreign No monitor_slopes.monitor_slope_type_id
n_mps Number of good MPS INT UNSIGNED Yes NULL
value Value of monitor_slope FLOAT Yes NULL
error Error on monitor_slope FLOAT Yes NULL
Additional Indices
Name Type Fields
unique analysis_id, monitor_id, monitor_slope_type_id
monitor_id, monitor_slope_type_id

monitor_slope_types

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
monitor_slope_type_id Type of monitor_slope INT UNSIGNED AUTO_INCREMENT Primary No
monitor_slope Name of monitor_slope TEXT Yes NULL
units Units of monitor_slope TEXT Yes NULL
title Axis title TEXT Yes NULL

c_detectors

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
c_detector_id INT UNSIGNED AUTO_INCREMENT Primary No
octant_id Octant number INT UNSIGNED No
ced_id CED number INT UNSIGNED No
fpd_id FPD number INT UNSIGNED No
particle Cerenkov off or on (pion or electron) ENUM('pi', 'e') No
make Make of detector (NA or FR) ENUM('na', 'fr') No
Additional Indices
Name Type Fields
unique octant_id, ced_id, fpd_id, particle, c_detector_id

s_ced_detectors

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
s_ced_detector_id INT UNSIGNED AUTO_INCREMENT Primary No
octant_id Octant number INT UNSIGNED No
ced_id CED number INT UNSIGNED No
particle Cerenkov off or on (pion or electron) ENUM('pi', 'e') Yes NULL
`condition` Condtion of counter ENUM('ncdc', 'cdc', 'dc','left','right') Yes NULL
make Make of detector (NA or FR) ENUM('na', 'fr') No
Additional Indices
Name Type Fields
unique octant_id, ced_id, particle, `condition`, s_ced_detector_id

s_fpd_detectors

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
s_fpd_detector_id INT UNSIGNED AUTO_INCREMENT Primary No
octant_id Octant number INT UNSIGNED No
fpd_id FPD number INT UNSIGNED No
particle Cerenkov off or on (pion or electron) ENUM('pi', 'e') Yes NULL
`condition` Condtion of counter ENUM('ncdc', 'cdc', 'dc','left','right') Yes NULL
make Make of detector (NA or FR) ENUM('na', 'fr') No
Additional Indices
Name Type Fields
unique octant_id, fpd_id, particle, `condition`, s_fpd_detector_id

mh_ced_detectors

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
mh_ced_detector_id INT UNSIGNED AUTO_INCREMENT Primary No
octant_id Octant number INT UNSIGNED No
ced_id CED number INT UNSIGNED No
particle Cerenkov off or on (pion or electron) ENUM('pi', 'e') Yes NULL
`condition` Condtion of counter ENUM('1', '2') Yes NULL
make Make of detector (NA or FR) ENUM('na', 'fr') No
Additional Indices
Name Type Fields
unique octant_id, ced_id, particle, `condition`, mh_ced_detector_id

mh_fpd_detectors

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
mh_fpd_detector_id INT UNSIGNED AUTO_INCREMENT Primary No
octant_id Octant number INT UNSIGNED No
fpd_id FPD number INT UNSIGNED No
particle Cerenkov off or on (pion or electron) ENUM('pi', 'e') Yes NULL
`condition` Condtion of counter ENUM('1', '2') Yes NULL
make Make of detector (NA or FR) ENUM('na', 'fr') No
Additional Indices
Name Type Fields
unique octant_id, fpd_id, particle, `condition`, mh_fpd_detector_id

cerenkov

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
cerenkov_id INT UNSIGNED AUTO_INCREMENT Primary No
analysis_id Run that was replayed INT UNSIGNED Foreign No analysis.analysis_id
octant_id Octant number INT UNSIGNED No
pmt_id Sum of photomultipliertube hits id INT UNSIGNED Foreign No
measurement_type_id Type of measurement (yield, asymmetry, etc.) CHAR(4) Foreign No measurement_types.measurement_type_id
n_qrt Number of good quartets INT UNSIGNED No
value Value of measurement FLOAT Yes NULL
error Error on measurement FLOAT Yes NULL

pmt_types

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
pmt_id Cerenkov PMT ID INT UNSIGNED AUTO_INCREMENT Primary Yes NULL cerenkov.pmt_id
quantity cerenkov pmt value (pmt1, multlogic, etc) TEXT Yes NULL
title cerenkov full title (PMT1, Cerenkov Majority Logic, etc) TEXT Yes NULL

calibrations

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
calibration_id INT UNSIGNED AUTO_INCREMENT Primary No
first_run_id First run that this calibration applies to INT UNSIGNED Foreign No run.run_id
last_run_id Last run that this calibration applies to INT UNSIGNED Foreign No run.run_id
time Time this calibration set was put into the database DATETIME Yes NULL
comment User comment TEXT Yes NULL
monitor_calibration_id Beam monitor calibrations to use INT UNSIGNED Foreign No monitor_calibrations.monitor_calibration_id

monitor_calibrations

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
monitor_calibration_id INT UNSIGNED AUTO_INCREMENT Primary No
run_id Run from which these calibrations were extracted INT UNSIGNED Foreign Yes NULL run.run_id
first_run_id First run of range for which this calibration is valid INT UNSIGNED Foreign Yes NULL run.run_id
last_run_id Last run of range for which this calibration is valid INT UNSIGNED Foreign Yes NULL run.run_id
time Time this calibration set was put into the database DATETIME Yes NULL
comment User comment TEXT Yes NULL
Additional Indices
Name Type Fields
unique monitor_calibration_id, first_run_id, last_run_id, run_id
unique first_run_id, last_run_id, monitor_calibration_id, run_id
unique run_id, monitor_calibration_id, first_run_id, last_run_id

monitor_calibration_data

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
monitor_calibration_data_id INT UNSIGNED AUTO_INCREMENT Primary No
monitor_calibration_id Set to which this calibration belongs INT UNSIGNED Foreign No monitor_calibrations.monitor_calibration_id
monitor_id Monitor to which this calibration belongs INT UNSIGNED Foreign No monitors.monitor_id
gain Gain of monitor FLOAT Yes NULL
offset Offset of monitor FLOAT Foreign Yes NULL
Additional Indices
Name Type Fields
unique monitor_calibration_id, monitor_id

seeds

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
seed_id Seed identifier INT UNSIGNED AUTO_INCREMENT Primary No
seed Seed value in ASCII (hexadecimal representation TEXT No
comment Information about seed value TEXT Yes NULL

locus_types

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
locus_type_id Primary key for table INT UNSIGNED AUTO_INCREMENT Primary No
locus Name of CED-FPD locus TEXT No
title Title of CED-FPD locus for output TEXT No

deadtime_types

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
deadtime_type_id Primary key for table INT UNSIGNED AUTO_INCREMENT Primary No
deadtime_type Name of deadtime parameter TEXT No
title Title of deadtime parameter TEXT No

bf_tests

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
bf_test_id Primary key for table INT UNSIGNED AUTO_INCREMENT Primary No
analysis_id INT UNSIGNED Foreign No analysis.analysis_id
test_number Test value identifier INT UNSIGNED No
test_value Test value FLOAT No
Additional Indices
Name Type Fields
analysis_id
test_number

matrix_sum_slopes

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
matrix_sum_slope_id Primary key for table INT UNSIGNED AUTO_INCREMENT Primary No
analysis_id INT UNSIGNED No analysis.analysis_id
octant_id Octant number INT UNSIGNED No
locus_type_id INT UNSIGNED No locus_types.locus_type_id
particle ENUM('pi','e') No
slope_type_id INT UNSIGNED No slope_types.slope_type_id
n_mps Number of MPS in slope calculation INT UNSIGNED Yes NULL
value Value of slope FLOAT Yes NULL
error Error on slope FLOAT Yes NULL
Additional Indices
Name Type Fields
analysis_id, slope_type_id

na_electronics

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
na_electronics_id INT UNSIGNED AUTO_INCREMENT Primary No
run_id Run these settings apply to INT UNSIGNED Foreign No run.run_id
threshold CFD threshold setting FLOAT Yes NULL
prescalers Prescaler value(s?) INT UNSIGNED Yes NULL
Additional Indices
Name Type Fields
unique run_id, na_electronics_id

fr_electronics

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
fr_electronics_id INT UNSIGNED AUTO_INCREMENT Primary No
run_id Run these settings apply to INT UNSIGNED Foreign No run.run_id
npn NPN on or off ENUM("on", "off") Yes NULL
fr_config_id Configuration value INT UNSIGNED Foreign No fr_config.fr_config_id
gms GMS on or off ENUM("on", "off") Yes NULL
gdmch GDMCH (internal test generator) on or off ENUM("on", "off") Yes NULL
width Detection window width ENUM("512", "64") Yes NULL
Additional Indices
Name Type Fields
unique run_id, fr_electronics_id

fr_dmch_settings

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
fr_dmch_setting_id INT UNSIGNED AUTO_INCREMENT Primary No
fr_electronics_id Run these settings apply to INT UNSIGNED Foreign No fr_electronics.fr_electronics_id
fr_dmch_id DMCH these settings apply to INT UNSIGNED Foreign No fr_dmch.fr_dmch_id
dac0 TDC linearity tuning, MT channels 0-7 INT UNSIGNED Yes NULL
dac1 TDC linearity tuning, MT channels 8-15 INT UNSIGNED Yes NULL
hf0 Position of downstream cutoff associated with NPN INT UNSIGNED Yes NULL
hf1 Controls end of differential buddy marker INT UNSIGNED Yes NULL
gdmch_left Amplitude of GDMCH signal sent to left CFDs in DAC units (channels) INT UNSIGNED Yes NULL
gdmch_right Amplitude of GDMCH signal sent to right CFDs in DAC units (channels) INT UNSIGNED Yes NULL
Additional Indices
Name Type Fields
fr_electronics_id, fr_dmch_id
fr_dmch_id, fr_electronics_id

fr_buddy_delays

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
fr_buddy_delay_id INT UNSIGNED AUTO_INCREMENT Primary No
fr_electronics_id Run these settings apply to INT UNSIGNED Foreign No fr_electronics.fr_electronics_id
scintillator_id MT this delay belongs to INT UNSIGNED Foreign No scintillators.scintillator_id
value Amount of delay FLOAT Yes NULL
Additional Indices
Name Type Fields
fr_electronics_id, scintillator_id
scintillator_id, fr_electronics_id

fr_mt_delays

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
fr_mt_delay_id INT UNSIGNED AUTO_INCREMENT Primary No
fr_electronics_id Run these settings apply to INT UNSIGNED Foreign No fr_electronics.fr_electronics_id
scintillator_id MT this delay belongs to INT UNSIGNED Foreign No scintillators.scintillator_id
value Amount of delay FLOAT Yes NULL
Additional Indices
Name Type Fields
fr_electronics_id, scintillator_id
scintillator_id, fr_electronics_id

fr_cfd_thresholds

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
fr_cfd_threshold_id INT UNSIGNED AUTO_INCREMENT Primary No
fr_electronics_id Run these settings apply to INT UNSIGNED Foreign No fr_electronics.fr_electronics_id
phototube_id CFD this threshold belongs to INT UNSIGNED Foreign No phototubes.phototube_id
value Threshold setting FLOAT Yes NULL
Additional Indices
Name Type Fields
fr_electronics_id, phototube_id
phototube_id, fr_electronics_id

fr_dmch

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
fr_dmch_id INT UNSIGNED Primary No
octant_1 Octant run by this DMCH INT UNSIGNED Foreign No detectors.octant
octant_2 Octant run by this DMCH INT UNSIGNED Foreign No detectors.octant
detector_low Lowest detector run by this DMCH INT UNSIGNED Foreign No detectors.detector
detector_high Highest detector run by this DMCH INT UNSIGNED Foreign No detectors.detector

fr_config

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
fr_config_id INT UNSIGNED Primary No
setting French configuration setting (FifB, etc.) TEXT Yes NULL
Additional Indices
Name Type Fields
unique setting, fr_config_id

polarized_source

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
polarized_source_id INT UNSIGNED AUTO_INCREMENT Primary No
run_id Run this data comes from INT UNSIGNED Foreign No run.run_id
slow_helicity_plate State of slow helicity reversal half-wave plate ENUM("in", "out") Yes NULL
charge_feedback Charge feedback state ENUM("on", "off") Yes NULL
sign_in_neg Arbitrary sign to apply such that the measured asymmetry when the half wave plate is IN is negative. SMALLINT No 1
Additional Indices
Name Type Fields
unique run_id, polarized_source_id

polarized_source_measurements

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
polarized_source_measurement_id INT UNSIGNED AUTO_INCREMENT Primary No
polarized_source_id Run for this set of measurements INT UNSIGNED Foreign No sms.sms_id
polarized_source_monitor_id Monitor for this measurement INT UNSIGNED Foreign No sms_monitors.sms_monitor_id
average_value Average value of measurement FLOAT Yes NULL
error Error on average FLOAT Yes NULL
min_value Minimum value of measurement FLOAT Yes NULL
max_value Maximum value of measurement FLOAT Yes NULL
Additional Indices
Name Type Fields
polarized_source_id, polarized_source_monitor_id
polarized_source_monitor_id, polarized_source_id

polarized_source_monitors

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
polarized_source_monitor_id INT UNSIGNED AUTO_INCREMENT Primary No
quantity Name of monitor TEXT Yes NULL
units Measurement units TEXT Yes NULL
title Graph axis title TEXT Yes NULL
Additional Indices
Name Type Fields
unique quantity, polarized_source_monitor_id

polarimetry

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
polarimetry_id INT UNSIGNED AUTO_INCREMENT Primary No
run_id Run this data comes from INT UNSIGNED Foreign No run.run_id
polarimeter_id Polarimeter used for this measurement INT UNSIGNED Foreign No polarimeters.polarimeter_id
value Value of polarization (%) FLOAT Yes NULL
error Error on polarization (%) FLOAT Yes NULL
Additional Indices
Name Type Fields
run_id, polarimeter_id
polarimeter_id, run_id

polarimeters

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
polarimeter_id INT UNSIGNED AUTO_INCREMENT Primary No
name Name of polarimeter TEXT Yes NULL
type Type of polarimeter (Moller, Compton, etc.) TEXT Yes NULL
Additional Indices
Name Type Fields
unique name, polarimeter_id

sms

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
sms_id INT UNSIGNED AUTO_INCREMENT Primary No
run_id Run for this set of measurements INT UNSIGNED Foreign No run.run_id
Additional Indices
Name Type Fields
unique run_id, sms_id
unique sms_id, run_id

sms_measurements

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
sms_measurement_id INT UNSIGNED AUTO_INCREMENT Primary No
sms_id Run for this set of measurements INT UNSIGNED Foreign No sms.sms_id
sms_monitor_id Monitor for this measurement INT UNSIGNED Foreign No sms_monitors.sms_monitor_id
average_value Average value of measurement FLOAT Yes NULL
error Error on average FLOAT Yes NULL
min_value Minimum value of measurement FLOAT Yes NULL
max_value Maximum value of measurement FLOAT Yes NULL
Additional Indices
Name Type Fields
sms_id, sms_monitor_id
sms_monitor_id, sms_id

sms_monitors

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
sms_monitor_id INT UNSIGNED AUTO_INCREMENT Primary No
type Type of monitor (temperature, vacuum, pressure, level, current) ENUM("t", "v", "p", "l","i") No
quantity Name of monitor TEXT Yes NULL
units Measurement units TEXT Yes NULL
title Graph axis title TEXT Yes NULL
Additional Indices
Name Type Fields
unique quantity, sms_monitor_id, type

target

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
target_id INT UNSIGNED AUTO_INCREMENT Primary No
run_id Run for this set of measurements INT UNSIGNED Foreign No run.run_id
type Target position (LH2, C12, small hole, large hole, out-of-beam, undefined, radiator) ENUM("h", "c", "s", "l", "o", "u", "r", "f") Yes NULL
flyswatter Position of flyswatter. ENUM("out", "in")
halo_target Halo target position (mm) FLOAT
Additional Indices
Name Type Fields
unique run_id, target_id, type
unique type, run_id, target_id

target_measurements

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
target_measurement_id INT UNSIGNED AUTO_INCREMENT Primary No
target_id Run for this set of measurements INT UNSIGNED Foreign No target.target_id
target_monitor_id Monitor for this measurement INT UNSIGNED Foreign No target_monitors.target_monitor_id
average_value Average value of this measurement FLOAT Yes NULL
error Error on average FLOAT Yes NULL
min_value Minimum value of this measurement FLOAT Yes NULL
max_value Maximum value of this measurement FLOAT Yes NULL
Additional Indices
Name Type Fields
target_id, target_monitor_id
target_monitor_id, target_id

target_monitors

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
target_monitor_id INT UNSIGNED AUTO_INCREMENT Primary No
type Type of monitor (temperature, vacuum, pressure, level) ENUM("t", "v", "p", "l") Yes NULL
quantity Name of monitor TEXT Yes NULL
units Measurement units TEXT Yes NULL
title Graph axis title TEXT Yes NULL
Additional Indices
Name Type Fields
unique quantity, target_monitor_id, type

gms

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
gms_id INT UNSIGNED AUTO_INCREMENT Primary No
run_id Run for this set of measurements INT UNSIGNED Foreign No run.run_id
laser_on Laser on or off ENUM("t", "f") Yes NULL
attenuator Attenuator setting FLOAT Yes NULL
reference_pmt_hv HV setting for reference PMT FLOAT Yes NULL
Additional Indices
Name Type Fields
unique run_id, gms_id
unique gms_id, run_id

high_voltage_files

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
high_voltage_file_id INT UNSIGNED AUTO_INCREMENT Primary No
name Name of high voltage file TEXT Yes NULL
Additional Indices
Name Type Fields
unique name, high_voltage_file_id

high_voltage_settings

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
high_voltage_setting_id INT UNSIGNED AUTO_INCREMENT Primary No
high_voltage_file_id Name of high voltage file INT UNSIGNED Foreign No high_voltage_files.high_voltage_file_id
phototube_id Phototube INT UNSIGNED Foreign No phototubes.phototube_id
setting High voltage setting FLOAT Yes NULL
gain Gain value FLOAT Yes NULL
Additional Indices
Name Type Fields
high_voltage_file_id, phototube_id

high_voltage

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
high_voltage_id INT UNSIGNED AUTO_INCREMENT Primary No
run_id Run for these measurements INT UNSIGNED Foreign No run.run_id
high_voltage_file_id HV file used for this run INT UNSIGNED Foreign No high_voltage_files.high_voltage_file_id
Additional Indices
Name Type Fields
unique run_id, high_voltage_id, high_voltage_file_id
unique run_id, high_voltage_file_id, high_voltage_id

high_voltage_readings

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
high_voltage_reading_id INT UNSIGNED AUTO_INCREMENT Primary No
high_voltage_id Run for these measurements INT UNSIGNED Foreign No high_voltage.high_voltage_id
phototube_id Phototube for this measurement INT UNSIGNED Foreign No phototubes.phototube_id
value High voltage value FLOAT Yes NULL
Additional Indices
Name Type Fields
high_voltage_id, phototube_id
phototube_id, high_voltage_id

scintillators

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
scintillator_id INT UNSIGNED AUTO_INCREMENT Primary No
c_detector_id Detector this scintillator belongs to INT UNSIGNED Foreign No c_detectors.c_detector_id
position Position of scintillator (front, back) ENUM("f", "b") No

phototubes

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
phototube_id INT UNSIGNED AUTO_INCREMENT Primary No
scintillator_id Scintillator this phototube belongs to INT UNSIGNED Foreign No scintillaors.scintillator_id
position Position of phototube (left, right) ENUM("l", "r") No

fb

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
fb_id INT UNSIGNED AUTO_INCREMENT Primary No
time Time this Fastbus result set was put into the database. TIMESTAMP
comment User comment TEXT

fb_runs

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
fb_run_id INT UNSIGNED AUTO_INCREMENT Primary No
fb_id Fastbus measurement set this run belongs to. INT UNSIGNED Foreign No fb.fb_id
run_id Run containing data included in this measurement set. INT UNSIGNED Foreign No run.run_id
Additional Indices
Name Type Fields
fb_id

fb_detector_measurements

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
fb_detector_measurement_id INT UNSIGNED AUTO_INCREMENT Primary No
fb_id Fastbus measurement set this run belongs to. INT UNSIGNED Foreign No fb.fb_id
detector_id Detector for this measurement INT UNSIGNED Foreign No detectors.detector_id
fb_measurement_type_id Type of Fastbus measurement (TDC or MT resolution) ENUM("tdc_res", "mt_res") Foreign No fb_measurement_types.fb_measurement_types_id
value Value of measurement FLOAT
error Error on measurement FLOAT
Additional Indices
Name Type Fields
fb_id, detector_id, fb_measurement_type_id
fb_id, fb_measurement_type_id, detector_id

fb_phototube_measurements

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
fb_phototube_measurement_id INT UNSIGNED AUTO_INCREMENT Primary No
fb_id Fastbus measurement set this run belongs to. INT UNSIGNED Foreign No fb.fb_id
phototube_id Detector for this measurement INT UNSIGNED Foreign No phototubes.phototube_id
fb_measurement_type_id Type of Fastbus measurement (TDC or MT resolution) ENUM("proton_eff", "gain") Foreign No fb_measurement_types.fb_measurement_types_id
value Value of measurement FLOAT
error Error on measurement FLOAT
Additional Indices
Name Type Fields
fb_id, phototube_id, fb_measurement_type_id
fb_id, fb_measurement_type_id, phototube_id

fb_measurement_types

Table Fields
Name Description Type Key Type NULL Allowed Default Value Key Relation
fb_measurement_type_id Type of Fastbus measurement ENUM("tdc_res", "mt_res", "proton_eff", "gain") Primary No
units Units of measurement. TEXT
title Axis title. TEXT