Subproject 8

CFD Database Table Definitions

**tblCFD_DACALinearity**
Timestamp	CFDid	DACSetting	AnalogValue	HistogramNumber
datetime	unsigned smallint	unsigned smallint	double	int
Time entry was made in database	CFD serial number	DACA setting range 0 to 4095	Center of bin in mV	Number of measurements at this setting/voltage

Contacts: Thomas Roche (table 1)

**tblCFD_DACBLinearity**
Timestamp	CFDid	DACSetting	AnalogValue	HistogramNumber
datetime	unsigned smallint	unsigned smallint	double	int
Time entry was made in database	CFD serial number	DACB setting range 0 to 4095	Center of bin in mV	Number of measurements at this setting/voltage

Contacts: Thomas Roche (table 2)

**tblCFD_info**
CFDid primary key	DACAlinearity	DACBlinearity	DACAwidth	Timing	NoiseCalibration	DACBrate	RateFeedBack	RFBlinearity	Mode	Comments
unsigned smallint	enum	enum	enum	enum	enum	enum	enum	enum	enum	blob
CFD serial number	These columns specificy whether or not the corresponding test has been performed. A NULL value means the test has not been performed, Y means the test was passed and N means the the test was failed.									Any comments about the specified CFD. Generally reasons for test failure and repairs done.

Contacts: Thomas Roche (table 0)

**tblCFD_DACAwidth**
Timestamp	CFDid	DACSetting	Width	HistogramNumber
datetime	unsigned smallint	unsigned smallint	double	int
Time entry was made in database	CFD serial number	DACA setting range 0 to 4095	Center of bin in nsec	Number of measurements at this setting/width

Contacts: Thomas Roche (table 4)

**tblCFD_NoiseCalibration**
Timestamp	CFDid	Mode	DigitalSetting	NSBLevel	Rate
datetime	unsigned smallint	enum	unsigned smallint	float	double
Time entry was made in database	CFD serial number	CFD Mode	DACB setting range 0 to 4095	Noise Level	Rate of triggers

Contacts: Thomas Roche (table 6)

**tblCFD_DACBthreshold**
Timestamp	CFDid	DigitalSetting	CFDRate	ThresholdRate
datetime	unsigned smallint	unsigned smallint	double	double
Time entry was made in database	CFD serial number	DACB setting range 0 to 4095	Trigger rate in CFD mode	Trigger rate in Threshold mode

Contacts: Thomas Roche (table 5)

**tblCFD_RateFeedBack**
Timestamp	CFDid	RFBSetting	NoiseLevel	RFBOffset	Number
datetime	unsigned smallint	unsigned smallint	float	double	int
Time entry was made in database	CFD serial number	RFB setting range 0 to 127	Noise level for these measurements	DC offset measured at this setting	Number of measurements at this setting/value/level

Contacts: Thomas Roche (table 7)

**tblCFD_Timing**
Timestamp	CFDid	RFBSetting	PulseAmplitude	NSBLevel	PulseOffset	HistogramNumber
datetime	unsigned smallint	unsigned smallint	float	float	float	int
Time entry was made in database	CFD serial number	RFB value range 0 to 127	Amplitude of input pulse (in mV)	Noise level (in pe/ns)	Offset from control pulse (in ns)	Number of events

Contacts: Thomas Roche (table 8)

**tblCFD_RFBlinearity**
Timestamp	CFDid	RFBSetting	RFBOffset	HistogramNumber
datetime	unsigned smallint	unsigned smallint	double	int
Time entry was made in database	CFD serial number	RFB value range 0 to 127	Measured DC Offset (in mV)	Number of events

Contacts: Thomas Roche (table 9)

**tblCFD_DACCoefficients**
db_start_time	db_end_time	CFDid primary key	ThresholdA	ThresholdB	WidthA	WidthB	WidthW	RFBScale	RFBPole
datetime	datetime	unsigned smallint	double	double	double	double	double	double	double
	If NULL then setting is currently active.	CFD serial number	Linear term coefficient for threshold	Constant term for threshold	Cubic term for width	Linear term for width	Constant term for width	Linear term for RFB	Pole term for RFB

Contacts: Thomas Roche (table 10)