Difference between revisions of "Transversity MySQL database"
From Hall A Wiki
| Line 7: | Line 7: | ||
** Primary information is from the "start of run" and "end of run" | ** Primary information is from the "start of run" and "end of run" | ||
** Further information is filled in by those doing the analysis (online and offline) | ** Further information is filled in by those doing the analysis (online and offline) | ||
| + | |||
==Table Descriptions== | ==Table Descriptions== | ||
===RunInfo=== | ===RunInfo=== | ||
| Line 52: | Line 53: | ||
| ShiftWorkerComment | longtext | YES | | NULL | | | | ShiftWorkerComment | longtext | YES | | NULL | | | ||
+-------------------------+-------------+------+-----+---------+-------+ | +-------------------------+-------------+------+-----+---------+-------+ | ||
| − | |||
===EndRunInfo=== | ===EndRunInfo=== | ||
| Line 128: | Line 128: | ||
| BeamCharge_d3_mp | float | YES | | NULL | | | | BeamCharge_d3_mp | float | YES | | NULL | | | ||
+--------------------+---------+------+-----+---------+-------+ | +--------------------+---------+------+-----+---------+-------+ | ||
| − | |||
===AnalysisInfo=== | ===AnalysisInfo=== | ||
Revision as of 06:07, 13 February 2009
Available Tables
- RunInfo
- From the "start of run"
- EndRunInfo
- From the "end of run"
- AnalysisInfo
- Primary information is from the "start of run" and "end of run"
- Further information is filled in by those doing the analysis (online and offline)
Table Descriptions
RunInfo
+-------------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------------+-------------+------+-----+---------+-------+ | RunNumber | int(11) | | PRI | 0 | | | RunStartTime | datetime | YES | | NULL | | | TargetName | varchar(50) | YES | | NULL | | | TargetPolarizeDirection | varchar(50) | YES | | NULL | | | Prescale1 | int(11) | YES | | NULL | | | Prescale2 | int(11) | YES | | NULL | | | Prescale3 | int(11) | YES | | NULL | | | Prescale4 | int(11) | YES | | NULL | | | Prescale5 | int(11) | YES | | NULL | | | Prescale6 | int(11) | YES | | NULL | | | Prescale7 | int(11) | YES | | NULL | | | Prescale8 | int(11) | YES | | NULL | | | RichHV16 | float | YES | | NULL | | | RichCurrent16 | float | YES | | NULL | | | RichHV17 | float | YES | | NULL | | | RichMethaneFlow | float | YES | | NULL | | | UpstreamBCMCurrent | float | YES | | NULL | | | DownstreamBCMCurrent | float | YES | | NULL | | | Energy | float | YES | | NULL | | | RasterWidthX | float | YES | | NULL | | | RasterWidthY | float | YES | | NULL | | | WienAngle | float | YES | | NULL | | | BeamHalfWavePlate | varchar(50) | YES | | NULL | | | SmallCoilCurrent | float | YES | | NULL | | | VerticalCoilCurrent | float | YES | | NULL | | | LargeCoilCurrent | float | YES | | NULL | | | He3FlipID | int(11) | YES | | NULL | | | TargetPolarization | float | YES | | NULL | | | TargetPosition | float | YES | | NULL | | | BBChamber1Threshold | float | YES | | NULL | | | BBChamber2Threshold | float | YES | | NULL | | | BBChamber3Threshold | float | YES | | NULL | | | BBShowerThreshold | float | YES | | NULL | | | BBPreShowerThreshold | float | YES | | NULL | | | BBShower2Threshold | float | YES | | NULL | | | BBCherenkovThreshold | float | YES | | NULL | | | CodaConfig | varchar(50) | YES | | NULL | | | HappexRunNumber | int(11) | YES | | NULL | | | ShiftWorkerComment | longtext | YES | | NULL | | +-------------------------+-------------+------+-----+---------+-------+
EndRunInfo
+--------------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+---------+------+-----+---------+-------+ | RunNumber | int(11) | YES | MUL | NULL | | | Events_0 | int(11) | YES | | NULL | | | Events_pp | int(11) | YES | | NULL | | | Events_mm | int(11) | YES | | NULL | | | Events_pm | int(11) | YES | | NULL | | | Events_mp | int(11) | YES | | NULL | | | Time_0 | float | YES | | NULL | | | Time_pp | float | YES | | NULL | | | Time_mm | float | YES | | NULL | | | Time_pm | float | YES | | NULL | | | Time_mp | float | YES | | NULL | | | DeadTime_0 | float | YES | | NULL | | | DeadTime_pp | float | YES | | NULL | | | DeadTime_mm | float | YES | | NULL | | | DeadTime_pm | float | YES | | NULL | | | DeadTime_mp | float | YES | | NULL | | | T1real_0 | int(11) | YES | | NULL | | | T2real_0 | int(11) | YES | | NULL | | | T3real_0 | int(11) | YES | | NULL | | | T4real_0 | int(11) | YES | | NULL | | | T5real_0 | int(11) | YES | | NULL | | | T6real_0 | int(11) | YES | | NULL | | | T7real_0 | int(11) | YES | | NULL | | | T8real_0 | int(11) | YES | | NULL | | | T1real_pp | int(11) | YES | | NULL | | | T2real_pp | int(11) | YES | | NULL | | | T3real_pp | int(11) | YES | | NULL | | | T4real_pp | int(11) | YES | | NULL | | | T5real_pp | int(11) | YES | | NULL | | | T6real_pp | int(11) | YES | | NULL | | | T7real_pp | int(11) | YES | | NULL | | | T8real_pp | int(11) | YES | | NULL | | | T1real_mm | int(11) | YES | | NULL | | | T2real_mm | int(11) | YES | | NULL | | | T3real_mm | int(11) | YES | | NULL | | | T4real_mm | int(11) | YES | | NULL | | | T5real_mm | int(11) | YES | | NULL | | | T6real_mm | int(11) | YES | | NULL | | | T7real_mm | int(11) | YES | | NULL | | | T8real_mm | int(11) | YES | | NULL | | | T1real_pm | int(11) | YES | | NULL | | | T2real_pm | int(11) | YES | | NULL | | | T3real_pm | int(11) | YES | | NULL | | | T4real_pm | int(11) | YES | | NULL | | | T5real_pm | int(11) | YES | | NULL | | | T6real_pm | int(11) | YES | | NULL | | | T7real_pm | int(11) | YES | | NULL | | | T8real_pm | int(11) | YES | | NULL | | | T1real_mp | int(11) | YES | | NULL | | | T2real_mp | int(11) | YES | | NULL | | | T3real_mp | int(11) | YES | | NULL | | | T4real_mp | int(11) | YES | | NULL | | | T5real_mp | int(11) | YES | | NULL | | | T6real_mp | int(11) | YES | | NULL | | | T7real_mp | int(11) | YES | | NULL | | | T8real_mp | int(11) | YES | | NULL | | | AverageCurrent_x1 | float | YES | | NULL | | | AverageCurrent_x3 | float | YES | | NULL | | | AverageCurrent_x10 | float | YES | | NULL | | | BeamCharge_u3_0 | float | YES | | NULL | | | BeamCharge_u3_pp | float | YES | | NULL | | | BeamCharge_u3_mm | float | YES | | NULL | | | BeamCharge_u3_pm | float | YES | | NULL | | | BeamCharge_u3_mp | float | YES | | NULL | | | BeamCharge_d3_0 | float | YES | | NULL | | | BeamCharge_d3_pp | float | YES | | NULL | | | BeamCharge_d3_mm | float | YES | | NULL | | | BeamCharge_d3_pm | float | YES | | NULL | | | BeamCharge_d3_mp | float | YES | | NULL | | +--------------------+---------+------+-----+---------+-------+
AnalysisInfo
+-----------+------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------+------+-----+-------------------+----------------+ | anaID | int(11) | | PRI | NULL | auto_increment | | EntryTime | timestamp | YES | | CURRENT_TIMESTAMP | | | RunNumber | int(11) | YES | MUL | NULL | | | UserName | longtext | YES | | NULL | | | RunType | longtext | YES | | NULL | | | Flag | tinyint(4) | YES | | NULL | | | Comment | longtext | YES | | NULL | | +-----------+------------+------+-----+-------------------+----------------+
