[Halld-controls] JInventory and slot number

[Elliott Wolin]

Hi,

Josh asked for a telecom field in the JInventory system, which I added.  
In discussion with him we realized we need a place to put a slot number 
or range of slot numbers.

The housing hierarchy holds the parent id, so e.g. the parent of an A-B 
module will be an A-B chassis.  But where to keep the slot number?  I 
was planning to eliminate the five location tables.  I could replace it 
with a single "location" field, but one that wouldn't be unique (there 
will be many slot 5's).  I could add a "slot" field specifically for 
this where you could enter a slot or range of slots (e.g. "5" or "1-2").

Specifying a parent is adequate for many but not all cases.  E.g. the 
parent of an A-B chassis will be another entry corresponding to a rack.  
But there is no point in entering "slots" as independent entries in the 
database.  Thus the need for an additional field.  "Slot" may suffice, 
maybe "location" is better, not sure...

Thoughts?  Suggestions?

-- 

				Sincerely,
					Elliott


================================================================================


  Those raised in a morally relative or neutral environment will hold
		    no truths to be self-evident.
				

Elliott Wolin
Staff Physicist, Jefferson Lab
12000 Jefferson Ave
Suite 8 MS 12A1
Newport News, VA 23606
757-269-7365

================================================================================