FABCOMPONENT

Table Czar(s):

Mark Dierckxsens

Description:

This is the main table of a set that keeps track of changes to the hardware. Each component should have an entry in this table that tells what type of device it is (an int referring to DEVICE_ID in FABDEVICETYPE table), its serial number, the model and the manufacturer's name. Each time something has happened to a particular device and is entered into the database, the revision number gets increased. There is a comment column to record the reason for this change. A graphical user interface is under development to enter data into these tables.

Usage in the offline software:

This data is currently not used in the offline software.

Validation for entering new data:

Validation is done by the underlying classes of the user interface.

Process for automated filling:

Table not updated automatically or info not available.

Additional information:

More details about the HWDB tables and their development can be found here.

Structure:

Field	Type	Description
SEQNO	int(11)	the sequence number
ROW_COUNTER	int(11)
DEVICE_ID	int(11)	points to DEVICE_ID in FABDEVICETYPE table
SERIAL_NUM	varchar(20)	serail number of the component
MODEL	varchar(20)	the model of the component
MANUFACTURER	varchar(20)	the manufacturer's name
REVISION_NUM	int(11)	number of component changes
REVISION_REASON	text	comment field for revision reason

Updating status:

Detector		Responsible	Frequency	Method
caldet	data	N/A	N/A	N/A
caldet	MC	N/A	N/A	N/A
neardet	data	Dave Boehnlein, Mark Dierckxsens	irregular	gui
neardet	MC	N/A	N/A	N/A
fardet	data	Bill Miller, Mark Dierckxsens	irregular	gui
fardet	MC	N/A	N/A	N/A

This information was provided by Mark Dierckxsens and last updated on Fri Feb 25 05:03:35 2005

Send comments to: Mark Dierckxsens