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