Difference between revisions of "E04018 Database structure"
From Hall A Wiki
| Line 1: | Line 1: | ||
| − | +------------------+ | + | |
| + | <TABLE BORDER=1><TR><TH>Tables_in_e04018</TH></TR><TR><TD>e04018kin</TD></TR><TR><TD>e04018kinematics</TD></TR><TR><TD>e04018kins</TD></TR><TR><TD>e04018kins3</TD></TR><TR><TD>e04018rsum</TD></TR><TR><TD>e04018runs</TD></TR><TR><TD>e04018runsm</TD></TR><TR><TD>e04018runsum</TD></TR><TR><TD>e04018runsummary</TD></TR><TR><TD>meandetect</TD></TR><TR><TD>runsum</TD></TR><TR><TD>runtableall</TD></TR></TABLE> | ||
| + | +------------------+ | ||
| Tables_in_e04018 | | | Tables_in_e04018 | | ||
+------------------+ | +------------------+ | ||
Latest revision as of 18:24, 1 June 2007
| Tables_in_e04018 |
|---|
| e04018kin |
| e04018kinematics |
| e04018kins |
| e04018kins3 |
| e04018rsum |
| e04018runs |
| e04018runsm |
| e04018runsum |
| e04018runsummary |
| meandetect |
| runsum |
| runtableall |
+------------------+
| Tables_in_e04018 | +------------------+ | e04018kin | | e04018kinematics | | e04018kins | runs by kinematic | e04018kins3 | | e04018rsum | | e04018runs | | e04018runsm | | e04018runsum | | e04018runsummary | data for runs | meandetect | Normalized rates | runsum | | runtableall | +------------------+
Table used on webpage :
e04018runsummary
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| run | int(10) | YES | NULL | ||
| e | float(10,4) | YES | NULL | ||
| p_e | float(10,4) | YES | NULL | ||
| t_e | float(10,3) | YES | NULL | ||
| p_r | float(10,4) | YES | NULL | ||
| t_r | float(10,3) | YES | NULL | ||
| target | varchar(15) | YES | NULL | ||
| te | float(10,2) | YES | NULL | ||
| pr | float(10,3) | YES | NULL | ||
| ch | float(10,4) | YES | NULL | ||
| ct | float(10,2) | YES | NULL | ||
| tm | float(10,2) | YES | NULL | ||
| lti | varchar(7) | YES | NULL | ||
| ps5 | int(10) | YES | NULL | ||
| ps6 | int(10) | YES | NULL | ||
| ps3 | int(10) | YES | NULL |
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| run | int(10) | YES | NULL | ||
| e | float(10,4) | YES | NULL | ||
| kin | int(3) | YES | NULL | ||
| number | int(10) | PRI | NULL | auto_increment |
