| FAB_VFB_LOC |
Mark Dierckxsens
This table holds the physical location of a specific VFB device and the reason for inserting or removing it from that position in the detector. The MID in this table refers to the SEQNO in the main table FABCOMPONENT. The table has a number of columns to indicate the location of the device. The motivation for inserting or removing a device is indicated in the INSERT_MOTID and REMOVE_MOTID fields which point to the MOTID column in the table FABMOTIVATION. There are also extra columns for recording comments about the changes made.
This data is currently not used in the offline software.
Validation is done by the underlying classes of the user interface.
Table not updated automatically or info not available.
More details about the HWDB tables and their development can be found here.
| Field | Type | Description |
|---|---|---|
| SEQNO | int(11) | the sequence number |
| ROW_COUNTER | int(11) | |
| MID | int(11) | points to the SEQNO in FABCOMPONENT table |
| CRATE | smallint(6) | |
| VARC | tinyint(4) | |
| VMM | tinyint(4) | |
| VAADC | tinyint(4) | |
| INSERT_MOTID | int(11) | motivation for inserting points to MOTID from FABMOTIVATION |
| INSERT_COMMENT | text | comment field |
| REMOVE_MOTID | int(11) | motivation for removing points to MOTID from FABMOTIVATION |
| REMOVE_COMMENT | text | comment field |
| Detector | Responsible | Frequency | Method | |
|---|---|---|---|---|
| caldet | data | N/A | N/A | N/A |
| MC | N/A | N/A | N/A | |
| neardet | data | Dave Boehnlein, Mark Dierckxsens | irregular | manually, gui |
| MC | N/A | N/A | N/A | |
| fardet | data | Bill Miller, Mark Dierckxsens | irregular | manually, gui |
| MC | N/A | N/A | N/A | |