G0 Database Table Structure

Tables

run

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Default Value
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")		Yes	NULL
data_quality	Quality of this run (does it belong in the final physics result)	SET("good", "bad", "junk", "spiky")		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

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
flags	Important flags from g0analysis (calculate raw slopes, calculate corrected slopes, perform corrections)	SET("r_slopes", "c_slopes", "corr")		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
n_mps_good	Number of good MPS	INT UNSIGNED		Yes	NULL
n_qrt_good	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
nacfg	NA configuration file name	TEXT		Yes	NULL
na_dt	NA deadtime correction (on/off)	ENUM("off", "dog_only", "dog_singles", "70ns")		Yes	NULL
french_dt	FR deadtime correction (off, npn, buddy, npn_single_tof)	ENUM("off", "npn", "buddy", "npn_single_tof")		Yes	NULL
french_dnl	FR DNL correction	ENUM("on", "off")		Yes	NULL
dmchs	DMCH boards file name	TEXT		Yes	NULL
tscfg	Trigger supervisor configuration file name	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	10 sigma yield cut enabled (on/off)	ENUM("on", "off")		Yes	NULL
beam_mode	Beam motion used to calculate slopes, natural or pulsed.	ENUM("nbm", "cp")

Additional Indices
Name	Type	Fields
	unique	run_id, analysis_id
		run_id, slope_correction, beam_mode, analysis_id

measurement

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Default Value	Key Relation
measurement_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
analysis_id	Run that was replayed	INT UNSIGNED	Foreign	No		analysis.analysis_id
detector_id	Detector for this measurement	INT UNSIGNED	Foreign	No		detectors.detector_id
timebin_id	Timebin for this measurement	INT UNSIGNED	Foreign	No		timebins.timebin_id
measurement_type_id	Type of measurement (yield, asymmetry, etc.)	CHAR(4)	Foreign	No		measurement_types.measurement_type_id
bad_flag	Flag indicating whether this measurement is bad.	BOOL		Yes	NULL
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, detector_id, timebin_id, measurement_type_id
	unique	analysis_id, timebin_id, detector_id, measurement_type_id
	unique	analysis_id, detector_id, measurement_type_id, timebin_id
		detector_id, timebin_id, measurement_type_id

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
detector_id	Detector for this measurement	INT UNSIGNED	Foreign	No		detectors.detector_id
timebin_id	Timebin for this measurement	INT UNSIGNED	Foreign	No		timebins.timebin_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, detector_id, timebin_id, slope_type_id
	unique	analysis_id, timebin_id, detector_id, slope_type_id
	unique	analysis_id, detector_id, slope_type_id, timebin_id
		detector_id, timebin_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

deadtime_rates

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Default Value	Key Relation
deadtime_rates_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
analysis_id	Run that was replayed	INT UNSIGNED	Foreign	No		analysis.analysis_id
comment	User comment	TEXT		Yes	NULL

Additional Indices
Name	Type	Fields
	unique	analysis_id, deadtime_rates_id

na_rates

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

Additional Indices
Name	Type	Fields
	unique	deadtime_rates_id, detector_id, left_id, right_id, mt_id
	unique	deadtime_rates_id, detector_id, right_id, left_id, mt_id
	unique	deadtime_rates_id, detector_id, mt_id, left_id, right_id
	unique	deadtime_rates_id, detector_id, mt_id, right_id, left_id

fr_mt_rates

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Default Value	Key Relation
fr_mt_rates_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
deadtime_rates_id	Set of deadtime rates this measurement belongs to	INT UNSIGNED	Foreign	No		deadtime_rates.deadtime_rates_id
scintillator_id	Scintillator (mean timer) for this measurement	INT UNSIGNED	Foreign	No		scintillators.scintillator_id
value	Value of measurement	FLOAT		Yes	NULL

Additional Indices
Name	Type	Fields
	unique	deadtime_rates_id, scintillator_id

fr_cfd_rates

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Default Value	Key Relation
fr_cfd_rates_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
deadtime_rates_id	Set of deadtime rates this measurement belongs to	INT UNSIGNED	Foreign	No		deadtime_rates.deadtime_rates_id
phototube_id	Phototube (CFD) for this measurement	INT UNSIGNED	Foreign	No		phototubes.phototube_id
value	Value of measurement	FLOAT		Yes	NULL

Additional Indices
Name	Type	Fields
	unique	deadtime_rates_id, phototube_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
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
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
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

detectors

Table Fields
Name	Description	Type	Key Type	NULL Allowed
detector_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
make	Make of detector (FR or NA)	ENUM('fr', 'na')		No
octant	Octant number	INT UNSIGNED		No
detector	Detector number	INT UNSIGNED		No

Additional Indices
Name	Type	Fields
	unique	octant, detector, detector_id, make
	unique	detector, octant, detector_id, make
	unique	detector_id, detector, octant, make
	unique	detector_id, octant, detector, make
	unique	make, detector, detector_id, octant
	unique	make, detector_id, detector, octant

scintillators

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

Additional Indices
Name	Type	Fields
	unique	scintillator_id, detector_id, position
	unique	detector_id, scintillator_id, position
	unique	detector_id, position, scintillator_id
	unique	scintillator_id, position, detector_id
	unique	position, scintillator_id, detector_id
	unique	position, detector_id, scintillator_id

phototubes

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

Additional Indices
Name	Type	Fields
	unique	phototube_id, scintillator_id, position
	unique	scintillator_id, phototube_id, position
	unique	scintillator_id, position, phototube_id
	unique	phototube_id, position, scintillator_id
	unique	position, phototube_id, scintillator_id
	unique	position, scintillator_id, phototube_id

timebins

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Default Value	Key Relation
timebin_id		INT UNSIGNED	Primary	No
quantity	Quantity stored	ENUM("integrated","timebin", "particle")		Yes	NULL

Additional Indices
Name	Type	Fields
	unique	timebin_id, quantity
	unique	quantity, timebin_id

tartan_axis

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Default Value	Key Relation
tartan_axis_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
name	tartan quantity (coincidence level?)	TEXT		Yes	NULL

na_buddy_same

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Key Relation
na_buddy_same_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
analysis_id	Run that was replayed	INT UNSIGNED	Foreign	No	analysis.analysis_id
detector_id	Detector for this measurement	INT UNSIGNED	Foreign	No	detectors.detector_id
fom	Figure of merit	FLOAT
sigma	Width/sqrt(N) of FOM distribution.	FLOAT
error	Mean of fom error distribution	FLOAT

Additional Indices
Name	Type	Fields
	unique	analysis_id, detector_id, na_buddy_same_id
	unique	detector_id, analysis_id, na_buddy_same_id

na_buddy_prev

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Key Relation
na_buddy_prev_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
analysis_id	Run that was replayed	INT UNSIGNED	Foreign	No	analysis.analysis_id
detector_id	Detector for this measurement	INT UNSIGNED	Foreign	No	detectors.detector_id
fom	Figure of merit	FLOAT
sigma	Width/sqrt(N) of FOM distribution.	FLOAT
error	Mean of fom error distribution	FLOAT

Additional Indices
Name	Type	Fields
	unique	analysis_id, detector_id, na_buddy_prev_id
	unique	detector_id, analysis_id, na_buddy_prev_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
	unique	analysis_id, monitor_id, monitor_slope_type_id
	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
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

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
na_dnl_id	NA DNL calibrations to use	INT UNSIGNED	Foreign	No		na_dnl.na_dnl_id
fr_dnl_id	FR DNL calibrations to use	INT UNSIGNED	Foreign	No		fr_dnl.fr_dnl_id
na_deadtime_id	NA deadtimes to use	INT UNSIGNED	Foreign	No		na_deadtimes.na_deadtime_id
fr_deadtime_id	FR deadtimes to use	INT UNSIGNED	Foreign	No		fr_deadtimes.fr_deadtime_id
monitor_calibration_id	Beam monitor calibrations to use	INT UNSIGNED	Foreign	No		monitor_calibrations.monitor_calibrations_id
pid_id	Particle ID set to use	INT UNSIGNED	Foreign	No		pid.pid_id
caesura_id	Set of caesurae to use	INT UNSIGNED	Foreign	No		caesurae.caesura_id
tdc_calibration_id	Set of TDC resolutions to use	INT UNSIGNED	Foreign	No		tdc_calibrations.tdc_calibration_id

Additional Indices
Name	Type	Fields
	unique	first_run_id, last_run_id, calibration_id
	unique	last_run_id, first_run_id, calibration_id

na_dnl

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Default Value	Key Relation
na_dnl_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
run_id	Run from which these DNL 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
		first_run_id, last_run_id, na_dnl_id
		na_dnl_id, first_run_id, last_run_id
		run_id, na_dnl_id

na_dnl_data

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Default Value	Key Relation
na_dnl_data_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
na_dnl_id	DNL set this measurement belongs to	INT UNSIGNED	Foreign	No		na_dnl.na_dnl_id
detector_id	Detector for this measurement	INT UNSIGNED	Foreign	No		detectors.detector_id
timebin_id	Timebin of this measurement	INT UNSIGNED	Foreign	No		timebins.timebin_id
width	Width of timebin	FLOAT		Yes	NULL
error	Error on width	FLOAT		Yes	NULL

Additional Indices
Name	Type	Fields
		na_dnl_id, detector_id, timebin_id
		na_dnl_id, timebin_id, detector_id

fr_dnl

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Default Value	Key Relation
fr_dnl_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
run_id	Run from which these DNL 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
		first_run_id, last_run_id, fr_dnl_id
		fr_dnl_id, first_run_id, last_run_id
		run_id, fr_dnl_id

fr_dnl_data

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Default Value	Key Relation
fr_dnl_data_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
fr_dnl_id	DNL set this measurement belongs to	INT UNSIGNED	Foreign	No		fr_dnl.fr_dnl_id
detector_id	Detector for this measurement	INT UNSIGNED	Foreign	No		detectors.detector_id
timebin_id	Timebin of this measurement	INT UNSIGNED	Foreign	No		timebins.timebin_id
width	Width of timebin	FLOAT		Yes	NULL
error	Error on width	FLOAT		Yes	NULL

Additional Indices
Name	Type	Fields
		fr_dnl_id, detector_id, timebin_id
		fr_dnl_id, timebin_id, detector_id

na_deadtimes

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Default Value	Key Relation
na_deadtime_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
run_id	Run from which these deadtimes 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	first_run_id, last_run_id, na_deadtime_id
	unique	run_id, na_deadtime_id, first_run_id, last_run_id

na_deadtime_data

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

Additional Indices
Name	Type	Fields
	unique	na_deadtime_id, detector_id, left_id, right_id, mt_id
	unique	na_deadtime_id, detector_id, right_id, left_id, mt_id

fr_deadtimes

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Default Value	Key Relation
fr_deadtime_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
run_id	Run from which these deadtimes 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	first_run_id, last_run_id, fr_deadtime_id
	unique	run_id, fr_deadtime_id

fr_deadtime_data

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Default Value	Key Relation
fr_deadtime_data_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
fr_deadtime_id	Set to which this deadtime measurement belongs	INT UNSIGNED	Foreign	No		fr_deadtimes.fr_deadtime_id
detector_id	Detector to which this deadtime measurement belongs	INT UNSIGNED	Foreign	No		detectors.detector_id
timebin_id	Timebin to which this deadtime measurement belongs	INT UNSIGNED	Foreign	No		timebins.timebin_id
cfd	CFD deadtime correction value	FLOAT		Yes	NULL
mt	MT deadtime correction value	FLOAT		Yes	NULL
rb_mt	MT deadtime correction value (RB_MT)	FLOAT		Yes	NULL

Additional Indices
Name	Type	Fields
		fr_deadtime_id, detector_id, timebin_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		Yes	NULL

Additional Indices
Name	Type	Fields
		monitor_calibration_id, monitor_id

pid

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Default Value	Key Relation
pid_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
run_id	Run from which these particle IDs 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	pid_id, first_run_id, last_run_id, run_id
	unique	first_run_id, last_run_id, pid_id, run_id
	unique	run_id, pid_id, first_run_id, last_run_id

pid_data

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Key Relation
pid_data_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
pid_id	Set to which this particle ID datum belongs	INT UNSIGNED	Foreign	No	pid.pid_id
detector_id	Detector to which this particle ID belongs	INT UNSIGNED	Foreign	No	detectors.detector_id
particle_id	Particle type	INT UNSIGNED	Foreign	No	particles.particle_id
timebin_low	Lowest timebin this particle appears in	INT UNSIGNED	Foreign	No	timebins.timebin_id
timebin_high	Highest timebin this particle appears in	INT UNSIGNED	Foreign	No	timebins.timebin_id

Additional Indices
Name	Type	Fields
	unique	pid_id, detector_id, particle_id
	unique	pid_id, particle_id, detector_id

particles

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Default Value	Key Relation
particle_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
name	Particle name	TEXT		Yes	NULL
timebin_id	Special timebin ID for this particle	INT UNSIGNED	Foreign	No		timebins.timebin_id

Additional Indices
Name	Type	Fields
	unique	name, timebin_id, particle_id
	unique	timebin_id, name, particle_id
	unique	particle_id, timebin_id, name
	unique	particle_id, name, timebin_id

caesurae

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Default Value	Key Relation
caesura_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
run_id	Run from which these caesurae 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	first_run_id, last_run_id, caesura_id, run_id
	unique	run_id, caesura_id, first_run_id, last_run_id
	unique	caesura_id, first_run_id, last_run_id, run_id

caesura_data

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Default Value	Key Relation
caesura_data_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
caesura_id	Set to which these caesurae belong	INT UNSIGNED	Foreign	No		caesurae.caesura_id
detector_id	Detector to which these caesurae belong	INT UNSIGNED	Foreign	No		detectors.detector_id
upstream	Upstream caesura	INT UNSIGNED		Yes	NULL
downstream	Downstream caesura	INT UNSIGNED		Yes	NULL

Additional Indices
Name	Type	Fields
		caesura_id, detector_id

tdc_calibrations

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Default Value	Key Relation
tdc_calibration_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
run_id		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	tdc_calibration_id, first_run_id, last_run_id, run_id
	unique	first_run_id, last_run_id, tdc_calibration_id, run_id
	unique	run_id, tdc_calibration_id, first_run_id, last_run_id
	unique	tdc_calibration_id, run_id, first_run_id, last_run_id

tdc_cfd_calibrations

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Default Value	Key Relation
tdc_cfd_calibration_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
tdc_calibration_id	Set to which this datum belongs	INT UNSIGNED	Foreign	No		tdc_calibrations.tdc_calibration_id
phototube_id	Phototube to which this datum belongs	INT UNSIGNED	Foreign	No		phototubes.phototube_id
gain	Channel-to-time gain	FLOAT		Yes	NULL
offset	Channel-to-time offset	FLOAT		Yes	NULL

Additional Indices
Name	Type	Fields
		tdc_calibration_id, phototube_id

tdc_mt_calibrations

Table Fields
Name	Description	Type	Key Type	NULL Allowed	Default Value	Key Relation
tdc_mt_calibration_id		INT UNSIGNED AUTO_INCREMENT	Primary	No
tdc_calibration_id	Set to which this datum belongs	INT UNSIGNED	Foreign	No		tdc_calibrations.tdc_calibration_id
scintillator_id	Meantime to which this datum belongs	INT UNSIGNED	Foreign	No		scintillators.scintillator_id
gain	Channel-to-time gain	FLOAT		Yes	NULL
offset	Channel-to-time offset	FLOAT		Yes	NULL

Additional Indices
Name	Type	Fields
		tdc_calibration_id, scintillator_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	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
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
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
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")		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
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	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

fb

Table Fields
Name	Description	Type	Key Type	NULL Allowed
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	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	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	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
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

G0 Database Table Structure

Table of Contents

Tables

run

analysis

measurement

slopes

beam

deadtime_rates

na_rates

fr_mt_rates

fr_cfd_rates

cuts

cuts_data

measurement_types

slope_types

monitors

detectors

scintillators

phototubes

timebins

tartan_axis

na_buddy_same

na_buddy_prev

monitor_slopes

monitor_slope_types

calibrations

na_dnl

na_dnl_data

fr_dnl

fr_dnl_data

na_deadtimes

na_deadtime_data

fr_deadtimes

fr_deadtime_data

monitor_calibrations

monitor_calibration_data

pid

pid_data

particles

caesurae

caesura_data

tdc_calibrations

tdc_cfd_calibrations

tdc_mt_calibrations

na_electronics

fr_electronics

fr_dmch_settings

fr_buddy_delays

fr_mt_delays

fr_cfd_thresholds

fr_dmch

fr_config

polarized_source

polarized_source_measurements

polarized_source_monitors

polarimetry

polarimeters

sms

sms_measurements

sms_monitors

target

target_measurements

target_monitors

gms

high_voltage_files

high_voltage_settings

high_voltage

high_voltage_readings

fb

fb_runs

fb_detector_measurements

fb_phototube_measurements

fb_measurement_types