Scientific DB Applications » Hardware DB

Hi Steve,

I have just started to look at the cvs file containing the FEB electronics test information. The information I am being sent is a little different than what we had anticipated earlier. I found the original E-mail request sent on 7/11/2017, but of coarse, things have changed. I will forward this old E-mail, too.

Let me go through each of the tables inside the "Electronics Tables".

"front_end_boards" Tables
currently:
feb_id, comment, feb_type, module_id, module_position, location

new (i.e. what I am requesting):
feb_id , comments , feb_type, module_id, module_position

(looks like no change.)

"feb_chips" Tables
currently:
feb_chip_id, feb_id, bias bus, comments, create time

new (i.e. what they are sending and what I am requesting):
feb_id, feb_channel, test_date, slope_bias_0, intercept_bias_0, bias_bus_1, bias_bus_2

The feb-channel runs from 0, 1, 2, 3
(the slope_bias_0, intercept_bias_0, bias_bus_1, bias_bus_2 are being sent in hexadecimal... can we store these quantities in the database as hexadecimal? Also, can the test_date be one of the keys?)

"feb_channels" Tables
Currently:
feb_chip_id, channel, dac_slope, dac_intercept, trim, sipm_id, comments

new (i.e. what they are sending me and what I am requesting):
feb_chip_id, channel, test_date, dac_slope, dac_intercept, trim, sipm_id, comments

(note, the dac_slope, dac_intercept are in hexadecimal, they are not asking for the trim, but let's keep it there and change it to hexadecimal. Again, can the test_date be one of the keys?)

Thanks for all of the help.

Thanks,
Merrill Jenkins

--
++++++++++++++++++++++++
Merrill Jenkins
Professor of Physics ==== Mailing Address ===
Physics
411 University Blvd. N.
ILB RM 115
Mobile, Alabama 36688
phone: (251) 414-8013

Dept: (251) 460-6224
fax: (251) 460-6800