Table Mechanical and Magnetic Axis 
 

This table stores the results of the geometric measurements for the axis of the cold mass and cryo magnet performed by companies and CERN. Values are expressed in the theoretical coordinate system (with origin on connection side end cover).

Table CRYOGEO_AXIS
Fields Type Nullable Constraints Comments
Magnet_Nu integer No   [PKey,1] Serial number of the magnet (on 4 digits)
Step string No 'ITP20-GEO' or 'ITP20-MAG' or 'WP01-GEO' or 'WP01-MAG' or 'WP03-FID' or 'WP03-MAG' or 'WP08-FID' or 'WP08-MAG'

[PKey,2] Step where geometrical measurements have been performed

  • ITP20-GEO : Geometrical measurements done in ITP20 (mechanical axis)
  • ITP20-MAG : Geometrical measurements done in ITP20 (magnetic axis)
  • WP01-GEO : Optional geometrical test in WP01
  • WP01-MAG : Optional magnetic test in WP01
  • WP03-FID : Fiducialization in WP03
  • WP03-MAG : Warm magnetic measurements in WP03
  • WP08-FID : Fiducialization in WP08
  • WP08-MAG : Warm magnetic measurements in WP08
Meas_Type string No 'magnetic' or 'mechanic' [PKey,3]
Aperture number No 1 or 2 [PKey,4]
Side string No 'connection' or 'lyre' or 'combined' [PKey,5] indicates the side from measurement started.
Point_Id string No 1,2,3, .... [PKey,6]
Meas_Id string No   [PKey,7]
Magnet_Name string No like 'HC%' Name of the magnet
Stage string No 'cold mass' or 'cryomagnet'  
Final_Meas string No 'T' or 'F' Indicates if it is the final measurement (True or False)
DX [m] real No -0.01<=?<=0.01 Deviation from the theoretical value in the x axis 
Y [m] real No -1<=?<=25 Position of the point on the y axis (longitudinal direction)
DZ [m] real No -0.01<=?<=0.01 Deviation from the theoretical value in the z axis (vertical direction)


Remark :  [PKey,n] at the beginning of the Comments column means that all those fields define a primary key (This set of fields identifies in an unique way each row of this table) and also an index with order n for the field.