| Table WMF_HOLDING_POINT | ||||
|---|---|---|---|---|
| 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. | |
| 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,2] Indicates if it is the final measurement (True or False) |
| CERN_Arrival | date | Yes | Date of measurements arrival at CERN. | |
| Analyser | string | No | Person who analyzed the warm magnetic measurements. | |
| Answer2MMSLD | date | Yes | Date of the answer given by the analyser to the section MMS-LD. | |
| Answer2Manufacturer | date | Yes | Date of the answer given by MMS-LD to the manufacturer. | |
| Results | string | No | Holding Point Results | |
| Comments | string | Yes | comments about the magnet analysis. | |
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.