Table Magnetic Length

This table stores the results of the warm magnetic measurements for the magnetic length performed by companies

Table WMF_LENGTH
Fields	Type	Nullable	Constraints	Comments
Magnet_Name	string	No	like 'HCMB__A001-0%'	[iA,1] Name of the magnet
Magnet_Nu	number	No		Number of the manufacturer on 1 digit + sequential number of the magnet on 3 digits.
Stage	string	No	'collared coil' or 'cold mass'	State of the magnet
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] [iA,3] Indicates if it is the final measurement (True or False)
Aperture	integer	No	1 or 2	[PKey,3]  [iA,2] Aperture number
Magnetic_Length [m]	real	No	10<=?<=20
Int_Transfer_Function [T.m/A]	real	No	0.006<=?<=0.012	Integrated transfer function
Coil_Waviness [m]	real	No	5E-6<=?<=5E-4

For information please send e-email to Ezio Todesco or Jerome Beauquis.

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