| Table WMF_MEAS_ENVIRONMENT | ||||
|---|---|---|---|---|
| Fields | Type | Nullable | Constraints | Comments |
| Magnet_Name | string | No | like 'HCMB__A001-0%' | [iA,1] Name of the magnet |
| Magnet_Nu | number | No | Number of the manufacturer on 1 digit + sequential number of the magnet on 3 digits. | |
| Magnet_Progressive_Number | integer | No | ||
| Magnet_Maker | number | No | 1 or 2 or 3 | Number of the manufacturer |
| Meas_Date | date | No | Date of the measurement | |
| Stage | string | No | 'collared coil' or 'cold mass' | State of the magnet |
| Measure_Id | string | No | [PKey,1] date of test + "_" + serial number of the magnet (on 4 digits) | |
| Final_Measure | string | No | 'T' or 'F' | [PKey,2] [iA,3] Indicates if it is the final measurement (True or False) |
| Aperture | integer | No | 1 or 2 | [PKey,3] [iA,2] Aperture number |
| Time | string | No | Duration of the measurement | |
| Mole_Name | string | No | ||
| Operator | string | No | ||
| Controller | string | No | ||
| Coil_Temperature [K] | real | No | 273<=?<=320 | Temperature in this aperture |
| Electric_Current [A] | real | No | ||
| Measures | string | No | ||
| Speed | real | No | ||
| Coil_Length [m] | real | No | ||
| Loader_Name | string | No | Name of one loaded data | |
| Loading_Date | date | No | Date of loading data | |
Table date format: DD-MON-YYYY
String length for the field Comments : 300 characters
For information please send e-email to Ezio
Todesco or Jerome Beauquis.
Remark :[PKey,n] at the beginning of the Comments column means that all
those fields define a primary key (This set of columns identifies in an unique
way each row of this table) and also a search key (a b-tree index) with
order n. [iX,n] at the beginning of the Comments column means that all
those fields define a (b-tree) index with order n.