Table Cold Mass Length and Cold Feet Pads

This table stores the results of the geometric measurements for the cold mass total length and the cold feet pads height performed by companies and CERN.

Table CRYOGEO_CM_CFP
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_Id string No   [PKey,3]
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)
CM_Length [m] real No 15.138<=?<=15.178  Cold Mass total length
CFP_Connection_Z [m] real Yes -0.299<=?<=-0.289  Cold feet pad height on connection side
CFP_Center_Z [m] real Yes -0.299<=?<=-0.289  Cold feet pad height in the center
CFP_Lyre_Z [m] real Yes  -0.299<=?<=-0.289 Cold feet pad height on lyre side

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.