Table End Covers

This table stores the results of the geometric measurements on the end covers performed by companies and CERN. Values are expressed in local (connection and lyre) coordinate systems with origin on end cover.
 
Table CRYOGEO_END_COVERS
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
Side string No 'connection' or 'lyre' [PKey,3] Side of the cold mass
Meas_Id string No   [PKey,4]
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)
D9_DX [m] real No   Deviation from the theoretical value of D9 in the x axis
D9_DY [m] real No   Deviation from the theoretical value of D9 in the y axis (longitudinal direction)
D9_DZ [m] real No   Deviation from the theoretical value of D9 in the z axis (vertical direction)
D10_DX [m] real No   Deviation from the theoretical value of D10 in the x axis
D10_DY [m] real No   Deviation from the theoretical value of D10 in the y axis (longitudinal direction)
D10_DZ [m] real No   Deviation from the theoretical value of D10 in the z axis (vertical direction)
D11_DX [m] real No   Deviation from the theoretical value of D11 in the x axis
D11_DY [m] real No   Deviation from the theoretical value of D11 in the y axis (longitudinal direction)
D11_DZ [m] real No   Deviation from the theoretical value of D11 in the z axis (vertical direction)
Center_DX [m] real No  -0.005<=?<=0.005 Deviation from the theoretical value of the center in the x axis
Center_DY [m] real No   Deviation from the theoretical value of the center in the y axis (longitudinal direction)
Center_DZ [m] real No  -0.005<=?<=0.005 Deviation from the theoretical value of the center in the z axis (vertical direction)
Angle_X [Rad] real No  -0.0045<=?<=0.0045 Angle around X axis
Angle_Y [Rad] real No   Angle around Y axis
Angle_Z [Rad] real No  -0.0045<=?<=0.0045 Angle around Z axis


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 defines an index with order n for the field.