Project

General

Profile

Actions

Bealine Schema

These are the tables associated with the beam line. They contain the 'set values'.

Table - run


                                                                                                           |   Data Source   |
 Column                  | Type             | Unit |  Description                                          | Now    | Future | Part of Tagged Run
-------------------------+------------------+------+-------------------------------------------------------+--------+--------+--------------------
 runnumber [key]         | bigint           | –    | A unique id, no leading 0                             | daq    | daq    |
 starttime               | timestamp        | –    | The time stamp for when the run started               | daq    | daq    |
 endtime                 | timestamp        | –    | The timestamp for when the run ended                  | daq    | daq    |
 notes                   | text             | –    |                                                       | user   | user   |
 optics                  | varchar          | –    | Beamline optics, formally species                     | user   | epics  | yes
 pulsestart              | bigint           | –    | Total number of pulses at start of run                | ?      | daq    |
 pulseend                | bigint           | –    | Total number of pulses at end of run                  | ?      | daq    |
 step                    | double precision | –    | MICE phase                                            | user   | user   | yes
 protonabsorberthickness | int              | mm   | The thickness of the proton absorber                  | epics  | epics  | yes
 runtype                 | bit(32)          | –    | Each bit is a flag for a run type                     | user   | user   |
 status                  | boolean          | –    | True indicates data are analysable, set after the run | epics? | epics  |

pulseend MUST be greater than pulsestart


Table - daq


                                                                                                           |   Data Source   |
 Column                  | Type             | Unit |  Description                                          | Now    | Future | Part of Tagged Run
-------------------------+------------------+------+-------------------------------------------------------+--------+--------+--------------------
 runnumber [key]         | bigint           | –    | A unique id, provides relationship to the run table   | daq    | daq    |
 trigger                 | text             | –    |                                                       | daq?   | daq    | yes
 gatewidth               | double precision | ms   |                                                       | user?  | daq    | yes
 version                 | varchar          | –    |                                                       | daq    | daq    |

version MUST contain at least one integer > 0. i.e. cannot be 0.0.0 or 0.0 but can be x.0.0 or x.0 where x > 0.


Table - isis


                                                                                                           |   Data Source   |
 Column                  | Type             | Unit |  Description                                          | Now    | Future | Part of Tagged Run
-------------------------+------------------+------+-------------------------------------------------------+--------+--------+--------------------
 runnumber [key]         | bigint           | –    | A unique id, provides relationship to the run table   | daq    | daq    |
 targetfrequency         | bigint           | –    | This is a value from a register                       | daq?   | daq    | yes
 reprate                 | double precision | Hz   |                                                       | user   | epics  |
 nominalbeamcurrent      | double precision | uA   |                                                       | user   | epics  |
 nominalbeamloss         | double precision | mV   |                                                       | user   | epics  |
 beampositionx           | double precision | –    | The x co-ordinate of the beam                         | user   | epics  |
 beampositiony           | double precision | –    | The y co-ordinate of the beam                         | user   | epics  |

nominalbeamloss MUST be => 0


Table - target


                                                                                                           |   Data Source   |
 Column                  | Type             | Unit |  Description                                          | Now    | Future | Part of Tagged Run
-------------------------+------------------+------+-------------------------------------------------------+--------+--------+--------------------
 runnumber [key]         | bigint           | –    | A unique id, provides relationship to the run table   | daq    | daq    |
 drivevoltage            | double precision | V    |                                                       | user   | epics  | yes
 delay                   | double precision | –    | The value is binary                                   | user   | epics  | yes
 depth                   | double precision | mm   |                                                       | user   | epics  | yes

NB In the future the units for Depth are going to be changed from mm to microns, this will require the conversion of existing values in the database from mm to microns.


Table - magnet


                                                                                                           |   Data Source   |
 Column                  | Type             | Unit |  Description                                          | Now    | Future | Part of Tagged Run
-------------------------+------------------+------+-------------------------------------------------------+--------+--------+--------------------
 runnumber [key]         | bigint           | –    | A unique id, provides relationship to the run table   | daq    | daq    |
 name [key]              | varchar          | –    |                                                       | epics  | epics  | yes
 setcurrent              | double precision | A    |                                                       | epics  | epics  | yes
 polarity                | ?                | –    |                                                       | ?      | epics  |

Updated by Wilson, Antony about 13 years ago · 16 revisions