E04018 Database structure
From Hall A Wiki
| 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 |
