| Table WMF_COLLARED_COIL_ASSEMBLY | ||||
|---|---|---|---|---|
| Fields | Type | Nullable | Constraints | Comments |
| Magnet_Name | string | No | like 'HCMB__A001-0%' | Name of the magnet |
| Magnet_Nu | number | No | Number of the manufacturer on 1 digit + sequential number of the magnet on 3 digits. | |
| 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] Indicates if it is the final measurement (True or False) |
| Aperture | integer | No | 1 or 2 | [PKey,3] Aperture number |
| Cross-Section | integer | No | 1<=?<=10 | Cross Section Type |
| End_Spacer_Id | string | No | 1<=?<=10 | Generation of End Spacers |
| End_Spacer_Generation | string | Yes | End Spacers Comments | |
| Shim_UIL [m] | real | No | 0<=?<=0.002 | Upper Pole, Inner Layer, Left Shim thickness |
| Shim_UIR [m] | real | No | 0<=?<=0.002 | Upper Pole, Inner Layer, Right Shim thickness |
| Shim_UOL [m] | real | No | 0<=?<=0.002 | Upper Pole, Outer Layer, Left Shim thickness |
| Shim_UOR [m] | real | No | 0<=?<=0.002 | Upper Pole, Outer Layer, Right Shim thickness |
| Shim_DIL [m] | real | No | 0<=?<=0.002 | Lower Pole (D= Down), Inner Layer, Left Shim thickness |
| Shim_DIR [m] | real | No | 0<=?<=0.002 | Lower Pole (D= Down), Inner Layer, Right Shim thickness |
| Shim_DOL [m] | real | No | 0<=?<=0.002 | Lower Pole (D= Down), Outer Layer, Left Shim thickness |
| Shim_DOR [m] | real | No | 0<=?<=0.002 | Lower Pole (D= Down), Outer Layer, Right Shim thickness |
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 with order n.