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