Table Cartography

This table stores the results of the geometric measurements on tubes extremities performed by EST-SU. Values are expressed in local (connection and lyre) coordinate systems with origin on end plate.
 
Table CRYOGEO_CARTOGRAPHY
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)
E_DX [m] real Yes -0.02<=?<=0.02 Deviation from the theoretical value of the tube E in the x axis
E_DZ [m] real Yes -0.02<=?<=0.02 Deviation from the theoretical value of the tube E in the z axis (vertical direction)
M1_DX [m] real Yes -0.0075<=?<=0.0075 Deviation from the theoretical value of the tube M1 in the x axis
M1_DZ [m] real Yes -0.0075<=?<=0.0075 Deviation from the theoretical value of the tube M1 in the z axis (vertical direction)
M2_DX [m] real Yes -0.0075<=?<=0.0075 Deviation from the theoretical value of the tube M2 in the x axis
M2_DZ [m] real Yes -0.0075<=?<=0.0075 Deviation from the theoretical value of the tube M2 in the z axis (vertical direction)
M3_DX [m] real Yes -0.0075<=?<=0.0075 Deviation from the theoretical value of the tube M3 in the x axis
M3_DZ [m] real Yes -0.0075<=?<=0.0075 Deviation from the theoretical value of the tube M3 in the z axis (vertical direction)
N_DX [m] real Yes -0.01<=?<=0.01 Deviation from the theoretical value of the tube N in the x axis
N_DZ [m] real Yes -0.01<=?<=0.01 Deviation from the theoretical value of the tube N in the z axis (vertical direction)
V1_DX [m] real No -0.006<=?<=0.006 Deviation from the theoretical value of the tube V1 in the x axis
V1_DZ [m] real No -0.006<=?<=0.006 Deviation from the theoretical value of the tube V1 in the z axis (vertical direction)
V2_DX [m] real No -0.006<=?<=0.006 Deviation from the theoretical value of the tube V2 in the x axis
V2_DZ [m] real No -0.006<=?<=0.006 Deviation from the theoretical value of the tube V2 in the z axis (vertical direction)
W_DX [m] real Yes -0.02<=?<=0.02 Deviation from the theoretical value of the tube W in the x axis
W_DZ [m] real Yes -0.02<=?<=0.02 Deviation from the theoretical value of the tube W in the z axis (vertical direction)
X_DX [m] real Yes -0.005<=?<=0.005 Deviation from the theoretical value of the tube X in the x axis
X_DZ [m] real Yes -0.005<=?<=0.005 Deviation from the theoretical value of the tube X 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 defines an index with order n for the field.