Difference between revisions of "Pi0 RunDatabase"

Revision as of 03:15, 13 April 2008

The Pi0 Run Database (e04007) is currently (online) run on adaqh1. It is automatically generated but can easily be reconstructed with the available scripts.

Available Tables

• RunInfo
  • Generated at the beginning of the run
• scalerinfo
  • Generated at the end of the run using scaler information from the "End of Run" HALOG entries
• AnalysisInfo
  • First entry automatically generated at the start of the run.
  • Further information is filled in by those doing the analysis (online and offline)

Scripts

These are the scripts that generate the database and fill the tables. All are located here:

~a-onl/scripts/mysql

• addRun2runlist.pl

• setAnalysisInfo.pl

• ~a-onl/bbite/scripts/grabRunInfo.pl

Table Descriptions

RunInfo

+----------------+-------------+------+-----+-------------------+-------+
| Field          | Type        | Null | Key | Default           | Extra |
+----------------+-------------+------+-----+-------------------+-------+
| RunNumber      | int(11)     |      | PRI | 0                 |       |
| RunStartTime   | datetime    | YES  |     | NULL              |       |
| EntryTime      | timestamp   | YES  |     | CURRENT_TIMESTAMP |       |
| TargetName     | varchar(50) | YES  |     | NULL              |       |
| TargetPosition | int(11)     | YES  |     | NULL              |       |
| LeftMomentum   | float       | YES  |     | NULL              |       |
| LeftAngle      | float       | YES  |     | NULL              |       |
| Energy         | float       | YES  |     | NULL              |       |
| BBCurrent      | float       | YES  |     | NULL              |       |
| BBAngle        | float       | YES  |     | NULL              |       |
+----------------+-------------+------+-----+-------------------+-------+