run

Name	Description	Type	Key	NULL	Default	Relation
run_id		INT UNSIGNED AUTO_INCREMENT	P	N
run_number	Number of run from CODA	INT UNSIGNED		N
run_type	Type of run	ENUM("G0", "polarization")
start_time	Time run began	DATETIME
end_time	Time run ended	DATETIME
n_mps	Number of MPSs in run	INT UNSIGNED
n_qrt	Number of quartets in run	INT UNSIGNED
n_fastbus	Number of fastbus events in run	INT UNSIGNED

analysis

Name	Description	Type	Key	NULL	Default	Relation
analysis_id		INT UNSIGNED AUTO_INCREMENT	P	N
run_id	Run that was replayed	INT UNSIGNED	F	N		run.run_id
time	Time run was replayed	DATETIME
flags	Important flags from g0analysis (calculate raw slopes, calculate corrected slopes, perform corrections)	SET("r_slopes", "c_slopes", "corr")
calibration_id	Specifies set of calibrations used to replay this run	INT UNSIGNED	F	N		calibration.calibration_id
cut_id	Specifies set of cuts used to replay this run	INT UNSIGNED	F	N		cut.cut_id
deadtime_rates_id	Specifies set of deadtime rates used to replay this run	INT UNSIGNED	F	N		deadtime_rates.deadtime_rates_id
n_mps_good	Number of good MPS	INT UNSIGNED
n_qrt_good	Number of good quartets	INT UNSIGNED
first_event	First event replayed (g0analysis flag)	INT UNSIGNED
last_event	Last event replayed (g0analysis flag)	INT UNSIGNED
segment	Run segment replayed (if specified on g0analysis command line)	INT
nacfg	NA configuration file name	TEXT
na_dt	NA deadtime correction (on/off)	ENUM("off", "dog_only", "dog_singles", "70ns")
french_dt	FR deadtime correction (off, npn, buddy)	ENUM("off", "npn", "buddy")
french_dnl	FR DNL correction	ENUM("on", "off")
dmchs	DMCH boards file name	TEXT
tscfg	Trigger supervisor configuration file name	TEXT
slope_calculation	Calculation of yield slopes enabled (on/off)	ENUM("on", "off")
slope_correction	Correction of yield slopes enabled (on/off)	ENUM("on", "off")
fb_setup	FastBus setup file name	TEXT

measurement

Name	Description	Type	Key	NULL	Default	Relation
measurement_id		INT UNSIGNED AUTO_INCREMENT	P	N
analysis_id	Run that was replayed	INT UNSIGNED	F	N		analysis.analysis_id
detector_id	Detector for this measurement	INT UNSIGNED	F	N		detectors.detector_id
timebin_id	Timebin for this measurement	INT UNSIGNED	F	N		timebins.timebin_id
measurement_type_id	Type of measurement (yield, asymmetry, etc.)	CHAR(4)	F	N		measurement_types.measurement_type_id
value	Value of measurement	FLOAT
error	Error on measurement	FLOAT

slopes

Name	Description	Type	Key	NULL	Default	Relation
slope_id		INT UNSIGNED AUTO_INCREMENT	P	N
analysis_id	Run that was replayed	INT UNSIGNED	F	N		analysis.analysis_id
detector_id	Detector for this measurement	INT UNSIGNED	F	N		detectors.detector_id
timebin_id	Timebin for this measurement	INT UNSIGNED	F	N		timebins.timebin_id
slope_type_id	Type of slope	INT UNSIGNED	F	N		slopes.slope_type_id
value	Value of slope	FLOAT
error	Error on slope	FLOAT

beam

Name	Description	Type	Key	NULL	Default	Relation
beam_id		INT UNSIGNED AUTO_INCREMENT	P	N
analysis_id	Run that was replayed	INT UNSIGNED	F	N		analysis.analysis_id
monitor_id	Monitor for this measurement	INT UNSIGNED	F	N		monitors.monitor_id
measurement_type_id	Type of measurement (yield, asymmetry, etc.)	CHAR(4)	F	N		measurement_types.measurement_type_id
value	Value of measurement	FLOAT
error	Error on measurement	FLOAT

deadtime_rates

Name	Description	Type	Key	NULL	Default	Relation
deadtime_rates_id		INT UNSIGNED AUTO_INCREMENT	P	N
analysis_id	Run that was replayed	INT UNSIGNED	F	N		analysis.analysis_id
comment	User comment	TEXT

na_rates

Name	Description	Type	Key	NULL	Default	Relation
na_rates_id		INT UNSIGNED AUTO_INCREMENT	P	N
deadtime_rates_id	Set of deadtime rates this measurement belongs to	INT UNSIGNED	F	N		deadtime_rates.deadtime_rates_id
detector_id	Detector for this deadtime measurement	INT UNSIGNED	F	N		detectors.detector_id
left_id	Left position in tartan table	INT UNSIGNED	F			tartan_axis.tartan_axis_id
right_id	Right position in tartan table	INT UNSIGNED	F			tartan_axis.tartan_axis_id
mt_id	Mean timer position in tartan table	INT UNSIGNED	F			tartan_axis.tartan_axis_id
value	Value of measurement	FLOAT

fr_mt_rates

Name	Description	Type	Key	NULL	Default	Relation
fr_mt_rates_id		INT UNSIGNED AUTO_INCREMENT	P	N
deadtime_rates_id	Set of deadtime rates this measurement belongs to	INT UNSIGNED	F	N		deadtime_rates.deadtime_rates_id
scintillator_id	Scintillator (mean timer) for this measurement	INT UNSIGNED	F	N		scintillators.scintillator_id
value	Value of measurement	FLOAT

fr_cfd_rates

Name	Description	Type	Key	NULL	Default	Relation
fr_cfd_rates_id		INT UNSIGNED AUTO_INCREMENT	P	N
deadtime_rates_id	Set of deadtime rates this measurement belongs to	INT UNSIGNED	F	N		deadtime_rates.deadtime_rates_id
phototube_id	Phototube (CFD) for this measurement	INT UNSIGNED	F	N		phototubes.phototube_id
value	Value of measurement	FLOAT

cuts

Name	Description	Type	Key	NULL	Default	Relation
cut_id		INT UNSIGNED AUTO_INCREMENT	P	N
analysis_id	Run that was replayed to generate these cuts	INT UNSIGNED	F	N		analysis.analysis_id
time	Time cuts were inserted into database	DATETIME
comment	User comment	TEXT

cuts_data

Name	Description	Type	Key	NULL	Default	Relation
cuts_data_id		INT UNSIGNED AUTO_INCREMENT	P	N
cut_id	Set of cuts that this cut belongs to	INT UNSIGNED	F	N		cuts.cut_id
monitor_id	Quantity to cut on	INT UNSIGNED	F	N		monitors.monitor_id
min	Minimum value of cut	FLOAT
max	Maximum value of cut	FLOAT

calibrations

Name	Description	Type	Key	NULL	Default	Relation
calibration_id		INT UNSIGNED AUTO_INCREMENT	P	N
first_run_id	First run that this calibration applies to	INT UNSIGNED	F	N		run.run_id
last_run_id	Last run that this calibration applies to	INT UNSIGNED	F	N		run.run_id
time	Time this calibration set was put into the database	DATETIME
comment	User comment	TEXT
dnl_id	DNL calibrations to use	INT UNSIGNED	F	N		dnl.dnl_id
na_deadtime_id	NA deadtimes to use	INT UNSIGNED	F	N		na_deadtimes.na_deadtime_id
fr_deadtime_id	FR deadtimes to use	INT UNSIGNED	F	N		fr_deadtimes.fr_deadtime_id
monitor_calibration_id	Beam monitor calibrations to use	INT UNSIGNED	F	N		monitor_calibrations.monitor_calibrations_id
pid_id	Particle ID set to use	INT UNSIGNED	F	N		pid.pid_id
caesura_id	Set of caesurae to use	INT UNSIGNED	F	N		caesurae.caesura_id
tdc_calibration_id	Set of TDC resolutions to use	INT UNSIGNED	F	N		tdc_calibrations.tdc_calibration_id

dnl

Name	Description	Type	Key	NULL	Default	Relation
dnl_id		INT UNSIGNED AUTO_INCREMENT	P	N
run_id	Run from which these DNL were extracted	INT UNSIGNED	F			run.run_id
first_run_id	First run of range for which this calibration is valid	INT UNSIGNED	F			run.run_id
last_run_id	Last run of range for which this calibration is valid	INT UNSIGNED	F			run.run_id
time	Time this calibration set was put into the database	DATETIME
comment	User comment	TEXT

dnl_data

Name	Description	Type	Key	NULL	Default	Relation
dnl_data_id		INT UNSIGNED AUTO_INCREMENT	P	N
dnl_id	DNL set this measurement belongs to	INT UNSIGNED	F	N		dnl.dnl_id
detector_id	Detector for this measurement	INT UNSIGNED	F	N		detectors.detector_id
timebin_id	Timebin of this measurement	INT UNSIGNED	F	N		timebins.timebin_id
width	Width of timebin	FLOAT
error	Error on width	FLOAT

na_deadtimes

Name	Description	Type	Key	NULL	Default	Relation
na_deadtime_id		INT UNSIGNED AUTO_INCREMENT	P	N
run_id	Run from which these deadtimes were extracted	INT UNSIGNED	F			run.run_id
first_run_id	First run of range for which this calibration is valid	INT UNSIGNED	F			run.run_id
last_run_id	Last run of range for which this calibration is valid	INT UNSIGNED	F			run.run_id
time	Time this calibration set was put into the database	DATETIME
comment	User comment	TEXT

na_deadtime_data

Name	Description	Type	Key	NULL	Default	Relation
na_deadtime_data_id		INT UNSIGNED AUTO_INCREMENT	P	N
na_deadtime_id	Set to which this deadtime measurement belongs	INT UNSIGNED	F	N		na_deadtimes.na_deadtime_id
detector_id	Detector for this deadtime measurement	INT UNSIGNED	F	N		detectors.detector_id
left_id	Left position in tartan table	INT UNSIGNED	F			tartan_axis.tartan_axis_id
right_id	Right position in tartan table	INT UNSIGNED	F			tartan_axis.tartan_axis_id
mt_id	Mean timer position in tartan table	INT UNSIGNED	F			tartan_axis.tartan_axis_id
value	Value of deadtime	FLOAT
a	Value of constant A (rate = A*I + B*I*I)	FLOAT
b	Value of constant B (rate = A*I + B*I*I)	FLOAT

fr_deadtimes

Name	Description	Type	Key	NULL	Default	Relation
fr_deadtime_id		INT UNSIGNED AUTO_INCREMENT	P	N
run_id	Run from which these deadtimes were extracted	INT UNSIGNED	F			run.run_id
first_run_id	First run of range for which this calibration is valid	INT UNSIGNED	F			run.run_id
last_run_id	Last run of range for which this calibration is valid	INT UNSIGNED	F			run.run_id
time	Time this calibration set was put into the database	DATETIME
comment	User comment	TEXT

fr_mt_deadtime_data

Name	Description	Type	Key	NULL	Default	Relation
fr_mt_deadtime_data_id		INT UNSIGNED AUTO_INCREMENT	P	N
fr_deadtime_id	Set to which this deadtime measurement belongs	INT UNSIGNED	F	N		fr_deadtimes.fr_deadtime_id
scintillator_id	Scintillator (MT) to which this deadtime measurement belongs	INT UNSIGNED	F	N		scintillators.scintillator_id
value	Value of deadtime	FLOAT

fr_cfd_deadtime_data

Name	Description	Type	Key	NULL	Default	Relation
fr_cfd_deadtime_data_id		INT UNSIGNED AUTO_INCREMENT	P	N
fr_deadtime_id	Set to which this deadtime measurement belongs	INT UNSIGNED	F	N		fr_deadtimes.fr_deadtime_id
phototube_id	Phototube (CFD) for this deadtime measurement	INT UNSIGNED	F	N		phototubes.phototube_id
value	Value of deadtime	FLOAT

monitor_calibrations

Name	Description	Type	Key	NULL	Default	Relation
monitor_calibration_id		INT UNSIGNED AUTO_INCREMENT	P	N
run_id	Run from which these calibrations were extracted	INT UNSIGNED	F			run.run_id
first_run_id	First run of range for which this calibration is valid	INT UNSIGNED	F			run.run_id
last_run_id	Last run of range for which this calibration is valid	INT UNSIGNED	F			run.run_id
time	Time this calibration set was put into the database	DATETIME
comment	User comment	TEXT

monitor_calibration_data

Name	Description	Type	Key	NULL	Default	Relation
monitor_calibration_data_id		INT UNSIGNED AUTO_INCREMENT	P	N
monitor_calibration_id	Set to which this calibration belongs	INT UNSIGNED	F	N		monitor_calibrations.monitor_calibration_id
monitor_id	Monitor to which this calibration belongs	INT UNSIGNED	F	N		monitors.monitor_id
gain	Gain of monitor	FLOAT
offset	Offset of monitor	FLOAT

pid

Name	Description	Type	Key	NULL	Default	Relation
pid_id		INT UNSIGNED AUTO_INCREMENT	P	N
run_id	Run from which these particle IDs were extracted	INT UNSIGNED	F			run.run_id
first_run_id	First run of range for which this calibration is valid	INT UNSIGNED	F			run.run_id
last_run_id	Last run of range for which this calibration is valid	INT UNSIGNED	F			run.run_id
time	Time this calibration set was put into the database	DATETIME
comment	User comment	TEXT

pid_data

Name	Description	Type	Key	NULL	Default	Relation
pid_data_id		INT UNSIGNED AUTO_INCREMENT	P	N
pid_id	Set to which this particle ID datum belongs	INT UNSIGNED	F	N		pid.pid_id
detector_id	Detector to which this particle ID belongs	INT UNSIGNED	F	N		detectors.detector_id
particle_id	Particle type	INT UNSIGNED	F	N		particles.particle_id
timebin_low	Lowest timebin this particle appears in	INT UNSIGNED	F	N		timebins.timebin_id
timebin_high	Highest timebin this particle appears in	INT UNSIGNED	F	N		timebins.timebin_id

particles

Name	Description	Type	Key	NULL	Default	Relation
particle_id		INT UNSIGNED AUTO_INCREMENT	P	N
name	Particle name	TEXT
timebin_id	Special timebin ID for this particle	INT UNSIGNED	F	N		timebins.timebin_id

caesurae

Name	Description	Type	Key	NULL	Default	Relation
caesura_id		INT UNSIGNED AUTO_INCREMENT	P	N
run_id	Run from which these caesurae were extracted	INT UNSIGNED	F			run.run_id
first_run_id	First run of range for which this calibration is valid	INT UNSIGNED	F			run.run_id
last_run_id	Last run of range for which this calibration is valid	INT UNSIGNED	F			run.run_id
time	Time this calibration set was put into the database	DATETIME
comment	User comment	TEXT

caesura_data

Name	Description	Type	Key	NULL	Default	Relation
caesura_data_id		INT UNSIGNED AUTO_INCREMENT	P	N
caesura_id	Set to which these caesurae belong	INT UNSIGNED	F	N		caesurae.caesura_id
detector_id	Detector to which these caesurae belong	INT UNSIGNED	F	N		detectors.detector_id
upstream	Upstream caesura	INT UNSIGNED
downstream	Downstream caesura	INT UNSIGNED

tdc_calibrations

Name	Description	Type	Key	NULL	Default	Relation
tdc_calibration_id		INT UNSIGNED AUTO_INCREMENT	P	N
run_id		INT UNSIGNED	F			run.run_id
first_run_id	First run of range for which this calibration is valid	INT UNSIGNED	F			run.run_id
last_run_id	Last run of range for which this calibration is valid	INT UNSIGNED	F			run.run_id
time	Time this calibration set was put into the database	DATETIME
comment	User comment	TEXT

tdc_cfd_calibrations

Name	Description	Type	Key	NULL	Default	Relation
tdc_cfd_calibration_id		INT UNSIGNED AUTO_INCREMENT	P	N
tdc_calibration_id	Set to which this datum belongs	INT UNSIGNED	F	N		tdc_calibrations.tdc_calibration_id
phototube_id	Phototube to which this datum belongs	INT UNSIGNED	F	N		phototubes.phototube_id
gain	Channel-to-time gain	FLOAT
offset	Channel-to-time offset	FLOAT

tdc_mt_calibrations

Name	Description	Type	Key	NULL	Default	Relation
tdc_mt_calibration_id		INT UNSIGNED AUTO_INCREMENT	P	N
tdc_calibration_id	Set to which this datum belongs	INT UNSIGNED	F	N		tdc_calibrations.tdc_calibration_id
scintillator_id	Meantime to which this datum belongs	INT UNSIGNED	F	N		scintillators.scintillator_id
gain	Channel-to-time gain	FLOAT
offset	Channel-to-time offset	FLOAT

detectors

Name	Description	Type	Key	NULL	Default	Relation
detector_id		INT UNSIGNED AUTO_INCREMENT	P	N
make	Make of detector (FR or NA)	ENUM('fr', 'na')		N
octant	Octant number	INT UNSIGNED		N
detector	Detector number	INT UNSIGNED		N

scintillators

Name	Description	Type	Key	NULL	Default	Relation
scintillator_id		INT UNSIGNED AUTO_INCREMENT	P	N
detector_id	Detector this scintillator belongs to	INT UNSIGNED	F	N		detectors.detector_id
position	Position of scintillator ("front", "back")	ENUM("f", "b")		N

phototubes

Name	Description	Type	Key	NULL	Default	Relation
phototube_id		INT UNSIGNED AUTO_INCREMENT	P	N
scintillator_id	Scintillator this phototube belongs to	INT UNSIGNED	F	N		scintillators.scintillator_id
position	Position of phototube (left, right)	ENUM("l", "r")		N

timebins

Name	Description	Type	Key	NULL	Default	Relation
timebin_id		INT UNSIGNED	P	N
quantity	Quantity stored	ENUM("integrated","timebin", "particle")

measurement_types

Name	Description	Type	Key	NULL	Default	Relation
measurement_type_id	Type of measurement (yield, asymmetry, etc.)	CHAR(4)	P	N
units	Units of measurement (?, ppm)	TEXT
title	Axis title ("Detector Yield", "Detector Asymmetry")	TEXT

slope_types

Name	Description	Type	Key	NULL	Default	Relation
slope_type_id	Type of slope	INT UNSIGNED AUTO_INCREMENT	P	N
slope	Name of slope	TEXT
units	Units of slope	TEXT
title	Axis title	TEXT

monitors

Name	Description	Type	Key	NULL	Default	Relation
monitor_id		INT UNSIGNED AUTO_INCREMENT	P	N
quantity	Name of beam property	TEXT
title	Axis title	TEXT

tartan_axis

Name	Description	Type	Key	NULL	Default	Relation
tartan_axis_id		INT UNSIGNED AUTO_INCREMENT	P	N
name	tartan quantity (coincidence level?)	TEXT

na_electronics

Name	Description	Type	Key	NULL	Default	Relation
na_electronics_id		INT UNSIGNED AUTO_INCREMENT	P	N
run_id	Run these settings apply to	INT UNSIGNED	F	N		run.run_id
threshold	CFD threshold setting	FLOAT
prescalers	Prescaler value(s?)	INT UNSIGNED

fr_electronics

Name	Description	Type	Key	NULL	Default	Relation
fr_electronics_id		INT UNSIGNED AUTO_INCREMENT	P	N
run_id	Run these settings apply to	INT UNSIGNED	F	N		run.run_id
npn	NPN on or off	ENUM("on", "off")
fr_config_id	Configuration value	INT UNSIGNED	F	N		fr_config.fr_config_id
gms	GMS on or off	ENUM("on", "off")
gdmch	GDMCH (internal test generator) on or off	ENUM("on", "off")
width	Detection window width	ENUM("512", "64")

fr_dmch_settings

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

fr_buddy_delays

Name	Description	Type	Key	NULL	Default	Relation
fr_buddy_delay_id		INT UNSIGNED AUTO_INCREMENT	P	N
fr_electronics_id	Run these settings apply to	INT UNSIGNED	F	N		fr_electronics.fr_electronics_id
scintillator_id	MT this delay belongs to	INT UNSIGNED	F	N		scintillators.scintillator_id
value	Amount of delay	FLOAT

fr_mt_delays

Name	Description	Type	Key	NULL	Default	Relation
fr_mt_delay_id		INT UNSIGNED AUTO_INCREMENT	P	N
fr_electronics_id	Run these settings apply to	INT UNSIGNED	F	N		fr_electronics.fr_electronics_id
scintillator_id	MT this delay belongs to	INT UNSIGNED	F	N		scintillators.scintillator_id
value	Amount of delay	FLOAT

fr_cfd_thresholds

Name	Description	Type	Key	NULL	Default	Relation
fr_cfd_threshold_id		INT UNSIGNED AUTO_INCREMENT	P	N
fr_electronics_id	Run these settings apply to	INT UNSIGNED	F	N		fr_electronics.fr_electronics_id
phototube_id	CFD this threshold belongs to	INT UNSIGNED	F	N		phototubes.phototube_id
value	Threshold setting	FLOAT

fr_dmch

Name	Description	Type	Key	NULL	Default	Relation
fr_dmch_id		INT UNSIGNED	P	N
octant_1	Octant run by this DMCH	INT UNSIGNED	F	N		detectors.octant
octant_2	Octant run by this DMCH	INT UNSIGNED	F	N		detectors.octant
detector_low	Lowest detector run by this DMCH	INT UNSIGNED	F	N		detectors.detector
detector_high	Highest detector run by this DMCH	INT UNSIGNED	F	N		detectors.detector

fr_config

Name	Description	Type	Key	NULL	Default	Relation
fr_config_id		INT UNSIGNED	P	N
setting	French configuration setting (FifB, etc.)	TEXT

polarized_source

Name	Description	Type	Key	NULL	Default	Relation
polarized_source_id		INT UNSIGNED AUTO_INCREMENT	P	N
run_id	Run this data comes from	INT UNSIGNED	F	N		run.run_id
slow_helicity_plate	State of slow helicity reversal half-wave plate	ENUM("in", "out")
charge_feedback	Charge feedback state	ENUM("on", "off")

polarized_source_measurements

Name	Description	Type	Key	NULL	Default	Relation
polarized_source_measurement_id		INT UNSIGNED AUTO_INCREMENT	P	N
polarized_source_id	Run for this set of measurements	INT UNSIGNED	F	N		sms.sms_id
polarized_source_monitor_id	Monitor for this measurement	INT UNSIGNED	F	N		sms_monitors.sms_monitor_id
average_value	Average value of measurement	FLOAT
error	Error on average	FLOAT
min_value	Minimum value of measurement	FLOAT
max_value	Maximum value of measurement	FLOAT

polarized_source_monitors

Name	Description	Type	Key	NULL	Default	Relation
polarized_source_monitor_id		INT UNSIGNED AUTO_INCREMENT	P	N
quantity	Name of monitor	TEXT
units	Measurement units	TEXT
title	Graph axis title	TEXT

polarimetry

Name	Description	Type	Key	NULL	Default	Relation
polarimetry_id		INT UNSIGNED AUTO_INCREMENT	P	N
run_id	Run this data comes from	INT UNSIGNED	F	N		run.run_id
polarimeter_id	Polarimeter used for this measurement	INT UNSIGNED	F	N		polarimeters.polarimeter_id
value	Value of polarization (%)	FLOAT
error	Error on polarization (%)	FLOAT

polarimeters

Name	Description	Type	Key	NULL	Default	Relation
polarimeter_id		INT UNSIGNED AUTO_INCREMENT	P	N
name	Name of polarimeter	TEXT
type	Type of polarimeter (Moller, Compton, etc.)	TEXT

sms

Name	Description	Type	Key	NULL	Default	Relation
sms_id		INT UNSIGNED AUTO_INCREMENT	P	N
run_id	Run for this set of measurements	INT UNSIGNED	F	N		run.run_id

sms_measurements

Name	Description	Type	Key	NULL	Default	Relation
sms_measurement_id		INT UNSIGNED AUTO_INCREMENT	P	N
sms_id	Run for this set of measurements	INT UNSIGNED	F	N		sms.sms_id
sms_monitor_id	Monitor for this measurement	INT UNSIGNED	F	N		sms_monitors.sms_monitor_id
average_value	Average value of measurement	FLOAT
error	Error on average	FLOAT
min_value	Minimum value of measurement	FLOAT
max_value	Maximum value of measurement	FLOAT

sms_monitors

Name	Description	Type	Key	NULL	Default	Relation
sms_monitor_id		INT UNSIGNED AUTO_INCREMENT	P	N
type	Type of monitor (temperature, vacuum, pressure, level, current)	ENUM("t", "v", "p", "l","i")		N
quantity	Name of monitor	TEXT
units	Measurement units	TEXT
title	Graph axis title	TEXT

target

Name	Description	Type	Key	NULL	Default	Relation
target_id		INT UNSIGNED AUTO_INCREMENT	P	N
run_id	Run for this set of measurements	INT UNSIGNED	F	N		run.run_id
type	Target position (LH2, C12, small hole, large hole, out-of-beam, undefined)	ENUM("h", "c", "s", "l", "o", "u")

target_measurements

Name	Description	Type	Key	NULL	Default	Relation
target_measurement_id		INT UNSIGNED AUTO_INCREMENT	P	N
target_id	Run for this set of measurements	INT UNSIGNED	F	N		target.target_id
target_monitor_id	Monitor for this measurement	INT UNSIGNED	F	N		target_monitors.target_monitor_id
average_value	Average value of this measurement	FLOAT
error	Error on average	FLOAT
min_value	Minimum value of this measurement	FLOAT
max_value	Maximum value of this measurement	FLOAT

target_monitors

Name	Description	Type	Key	NULL	Default	Relation
target_monitor_id		INT UNSIGNED AUTO_INCREMENT	P	N
type	Type of monitor (temperature, vacuum, pressure, level)	ENUM("t", "v", "p", "l")		N
quantity	Name of monitor	TEXT
units	Measurement units	TEXT
title	Graph axis title	TEXT

gms

Name	Description	Type	Key	NULL	Default	Relation
gms_id		INT UNSIGNED AUTO_INCREMENT	P	N
run_id	Run for this set of measurements	INT UNSIGNED	F	N		run.run_id
laser_on	Laser on or off	ENUM("t", "f")
attenuator	Attenuator setting	FLOAT
reference_pmt_hv	HV setting for reference PMT	FLOAT

high_voltage_files

Name	Description	Type	Key	NULL	Default	Relation
high_voltage_file_id		INT UNSIGNED AUTO_INCREMENT	P	N
name	Name of high voltage file	TEXT

high_voltage_settings

Name	Description	Type	Key	NULL	Default	Relation
high_voltage_setting_id		INT UNSIGNED AUTO_INCREMENT	P	N
high_voltage_file_id	Name of high voltage file	INT UNSIGNED	F	N		high_voltage_files.high_voltage_file_id
phototube_id	Phototube	INT UNSIGNED	F	N		phototubes.phototube_id
setting	High voltage setting	FLOAT
gain	Gain value	FLOAT

high_voltage

Name	Description	Type	Key	NULL	Default	Relation
high_voltage_id		INT UNSIGNED AUTO_INCREMENT	P	N
run_id	Run for these measurements	INT UNSIGNED	F	N		run.run_id
high_voltage_file_id	HV file used for this run	INT UNSIGNED	F	N		high_voltage_files.high_voltage_file_id

high_voltage_readings

Name	Description	Type	Key	NULL	Default	Relation
high_voltage_reading_id		INT UNSIGNED AUTO_INCREMENT	P	N
high_voltage_id	Run for these measurements	INT UNSIGNED	F	N		high_voltage.high_voltage_id
phototube_id	Phototube for this measurement	INT UNSIGNED	F	N		phototubes.phototube_id
value	High voltage value	FLOAT