| Column Name | Column Type | Description | Primary Key | Foreign Key | Foreign Key Relation |
| run_id | UNSIGNED INT AUTOINCREMENT | Y | N | ||
| run_number | UNSIGNED INT | Run number assigned by shift crew | N | N | |
| run_type | ENUM or CHAR | Type of run (e.g. time-encoding, Fastbus, halo monitor, Moller, calibration, etc.) | N | N | |
| start_time | DATETIME | Time that run was started | N | N | |
| stop_time | DATETIME | Time that run was ended | N | N |
| Column Name | Column Type | Description | Primary Key | Foreign Key | Foreign Key Relation |
| analysis_id | UNSIGNED INT AUTOINCREMENT | Y | N | ||
| run_id | UNSIGNED INT | Run that was replayed | N | Y | run.run_id |
| calibration_set | UNSIGNED INT | Set of calibrations used to replay run | N | Y | calibration.calibration_set |
| cut_set | UNSIGNED INT | Set of cuts used to replay run | N | Y | cuts.cut_set |
| replay_time | DATETIME | Time at which replay was started (finished?) | N | N |
| Column Name | Column Type | Description | Primary Key | Foreign Key | Foreign Key Relation |
| cuts_id | UNSIGNED INT AUTOINCREMENT | Y | N | ||
| cut_set | UNSIGNED INT | Identifier for a set of cuts used to replay runs | N | Y | analysis.cut_set |
| quantity | TEXT or CHAR(*) | Quantity to place a cut on | N | N | |
| min | REAL | Minimum allowable value of quantity | N | N | |
| max | REAL | Maximum allowable value of quantity | N | N |
| Column Name | Column Type | Description | Primary Key | Foreign Key | Foreign Key Relation |
| calibration_set | UNSIGNED INT AUTO_INCREMENT | Identifier for a set of calibration quantities used to replay runs | Y | N | analysis.calibration_set, na_time_encoding.calibration_set, monitor_parameters.calibration_set |
| run_id | UNSIGNED INT | Identifies which run used to set calibration parameters | N | Y | run.run_id |
| update_time | DATETIME | Time at which calibration set was generated | N | N | |
| first_run | UNSIGNED INT | First run that this calibration set applies to | N | N | |
| last_run | UNSIGNED INT | Last run that this calibration set applies to | N | N |
| Column Name | Column Type | Description | Primary Key | Foreign Key | Foreign Key Relation |
| na_time_encoding_id | UNSIGNED INT AUTOINCREMENT | Y | N | ||
| calibration_set | UNSIGNED INT | Identifier for set to which this calibration belongs | N | Y | calibration.calibration_set |
| detector_id | UNSIGNED INT | Identifier for detector to which this calibration applies | N | Y | detector.detector_id |
| timebin_id | UNSIGNED INT | Identifier for which timebin this calibration applies to | N | Y | measurement.timebin_id |
| timebin | UNSIGNED INT | Actual timebin number | N | N | |
| length | REAL | Length of timebin in ns | N | N |
| Column Name | Column Type | Description | Primary Key | Foreign Key | Foreign Key Relation |
| monitor_parameters_id | UNSIGNED INT AUTOINCREMENT | Y | N | ||
| calibration_set | UNSIGNED INT | Identifier for set to which this calibration belongs | N | Y | calibration.calibration_set |
| monitor_id | UNSIGNED INT | Identifier for monitor to which this calibration applies | N | Y | monitor.monitor_id |
| gain | REAL | Gain of monitor | N | N | |
| offset | REAL | Offset of monitor | N | N | |
| Column Name | Column Type | Description | Primary Key | Foreign Key | Foreign Key Relation |
| french_time_encoding_id | UNSIGNED INT AUTOINCREMENT | Y | N | ||
| calibration_set | UNSIGNED INT | Identifier for set to which this calibration belongs | N | Y | calibration.calibration_set |
| detector_id | UNSIGNED INT | Identifier for detector to which this calibration applies | N | Y | detector.detector_id |
| timebin_id | UNSIGNED INT | Identifier for which timebin this calibration applies to | N | Y | measurement.timebin_id |
| timebin | UNSIGNED INT | Actual timebin number | N | N | |
| length | REAL | Length of timebin in ns | N | N |
| Column Name | Column Type | Description | Primary Key | Foreign Key | Foreign Key Relation | |
| monitor_id | UNSIGNED INT AUTOINCREMENT | Identifier for a beam monitor or beam quantity | Y | N | ||
| quantity | TEXT | Name of monitor or quantity | N | N | ||
| type | ENUM | Type of measurement (yield, asymmetry, difference, etc.) | N | N | ||
| units | TEXT | Units quantity should be expressed in | N | N | ||
| title | TEXT | Descriptive title for this quantity (axis title) | N | N |
| Column Name | Column Type | Description | Primary Key | Foreign Key | Foreign Key Relation |
| beam_id | UNSIGNED INT AUTOINCREMENT | Y | N | ||
| analysis_id | UNSIGNED INT | Identifier for replayed run | N | Y | analysis.analysis_id |
| monitor_id | UNSIGNED INT | Identifier for monitor for which a measurement is recorded | N | Y | monitor.monitor_id |
| value | REAL | Measured value | N | N | |
| error | REAL | Measured error | N | N |
| Column Name | Column Type | Description | Primary Key | Foreign Key | Foreign Key Relation |
| detector_id | UNSIGNED INT AUTOINCREMENT | Y | N | ||
| octant | UNSIGNED INT | Octant in which detector is located | N | N | |
| detector | UNSIGNED INT | Detector number | N | N | |
| Column Name | Column Type | Description | Primary Key | Foreign Key | Foreign Key Relation |
| measurement_type | ENUM or CHAR | Type of measurement (yield, asymmetry, difference, etc.) | Y | N | |
| units | TEXT | Units of measurement | N | N | |
| title | TEXT | Descriptive title (e.g. for axis titles) | N | N |
| Column Name | Column Type | Description | Primary Key | Foreign Key | Foreign Key Relation |
| phototube_id | UNSIGNED INT AUTOINCREMENT | Y | N | ||
| detector_id | UNSIGNED INT | Identifier for detector | N | Y | detector.detector_id |
| position | ENUM or CHAR(2) | Position of phototube in detector (e.g. front-left, back-right, etc. | N | N |
| Column Name | Column Type | Description | Primary Key | Foreign Key | Foreign Key Relation |
| high_voltage_id | UNSIGNED INT AUTOINCREMENT | Y | N | ||
| run_id | UNSIGNED INT | Identifier for run | N | Y | run.run_id |
| phototube_id | UNSIGNED INT | Identifier for phototube | N | Y | phototubes.phototube_id |
| voltage_setting | REAL | Voltage setting for this phototube | N | N | |
| voltage_measured | REAL | Voltage readback for this phototube | N | N |
| Column Name | Column Type | Description | Primary Key | Foreign Key | Foreign Key Relation |
| polarimetry_id | UNSIGNED INT AUTOINCREMENT | Y | N | ||
| run_id | UNSIGNED INT | Identifier for run | N | Y | run.run_id |
| polarimeter_id | UNSIGNED INT | Identifier for polarimeter | N | Y | polarimeter.polarimeter_id |
| polarization | REAL | Measured polarization | N | N | |
| polarization_error | REAL | Error on polarization | N | N |
| Column Name | Column Type | Description | Primary Key | Foreign Key | Foreign Key Relation |
| polarimeter_id | UNSIGNED INT | Identifier for polarimeter | Y | N | |
| name | TEXT | Polarimeter name | N | N | |
| type | TEXT | Polarimeter type (Moller, Compton, etc.) | N | N | |
| Column Name | Column Type | Description | Primary Key | Foreign Key | Foreign Key Relation |
| measurement_id | UNSIGNED INT AUTOINCREMENT | Y | N | ||
| analysis_id | UNSIGNED INT | Identifier for replayed run | N | Y | analysis.analysis_id |
| detector_id | UNSIGNED INT | Identifier for detector for which a measurement is recorded | N | Y | detector.detector_id |
| measurement_type | ENUM or CHAR | Type of measurement (yield, asymmetry, difference, etc.) | N | Y | mesurement_type.measurement_type |
| timebin_id | UNSIGNED INT | Identifier for which timebin this calibration applies to | N | Y | na_time_encoding.timebin_id, french_time_encoding.timebin_id |
| value | REAL | Measured value | N | N | |
| error | REAL | Measured error | N | N |
| Column Name | Column Type | Description | Primary Key | Foreign Key | Foreign Key Relation |
| phototube_quantities_id | UNSIGNED INT AUTOINCREMENT | Y | N | ||
| run_id | UNSIGNED INT | Identifier for replayed run | N | Y | analysis.analysis_id |
| phototube_id | UNSIGNED INT | Identifier for phototube for which a measurement is recorded | N | Y | phototubes.phototube_id |
| measurement_type | ENUM or CHAR | Type of measurement (gain, time peak position, time resolution, proton peak position, TDC rates, pedestal) | N | Y | detector_measurement_types.measurement_type |
| electronics_type | ENUM or CHAR | Type of electronics (FastBus or GMS) | N | Y | |
| value | REAL | Measured value | N | N | |
| error | REAL | Error on value | N | N |
| Column Name | Column Type | Description | Primary Key | Foreign Key | Foreign Key Relation |
| scintillator_quantities_id | UNSIGNED INT AUTOINCREMENT | Y | N | ||
| run_id | UNSIGNED INT | Identifier for replayed run | N | Y | analysis.analysis_id |
| scintillator_id | UNSIGNED INT | Identifier for scinitillator for which a measurement is recorded | N | Y | scintillators.scintillator_id |
| measurement_type | ENUM or CHAR | Type of measurement (gain, time peak position, time resolution, proton peak position, TDC rates, pedestal) | N | Y | detector_measurement_types.measurement_type |
| electronics_type | ENUM or CHAR | Type of electronics (FastBus or GMS) | N | N | |
| value | REAL | Measured value | N | N | |
| error | REAL | Error on value | N | N |
| Column Name | Column Type | Description | Primary Key | Foreign Key | Foreign Key Relation |
| measurement_type | ENUM or CHAR | Type of measurement (gain, time peak position, time resolution, proton peak position, TDC rates, pedestal) | Y | N | |
| units | TEXT | Units of measurement | N | N | |
| title | TEXT | Descriptive title (e.g. for axis titles) | N | N | |