Project

General

Profile

Schema

These are the current table definitions as deployed on the configuration database January 2011.

alarm


    Column    |            Type             | Modifiers 
--------------+-----------------------------+-----------
 creationtime | timestamp without time zone | not null
 tag          | character varying(40)       | not null
 name         | character varying(40)       | not null
 hihi         | double precision            | 
 hi           | double precision            | 
 lo           | double precision            | 
 lolo         | double precision            | 

alarmhistory


      Column       |            Type             | Modifiers 
-------------------+-----------------------------+-----------
 starttime         | timestamp without time zone | not null
 alarmcreationtime | timestamp without time zone | 
 alarmtag          | character varying(40)       | 

Cabling


  Column  |            Type             |                       Modifiers                        
----------+-----------------------------+--------------------------------------------------------
 id       | integer                     | not null default nextval('"Cabling_id_seq"'::regclass)
 v1       | timestamp without time zone | 
 name     | character varying(64)       | 
 type     | character varying(64)       | 
 detector | character varying(16)       | 
 file     | bytea                       | 

Calibration


     Column      |            Type             |                            Modifiers                            
-----------------+-----------------------------+-----------------------------------------------------------------
 name            | character varying(64)       | 
 creator         | character varying(28)       | 
 note            | character varying(256)      | 
 detector        | character varying(16)       | 
 v1              | timestamp without time zone | 
 v2              | timestamp without time zone | 
 calibrationtype | character varying(32)       | 
 calibID         | integer                     | not null default nextval('"Calibration_calibID_seq"'::regclass)
 tt              | timestamp without time zone | 

Cooling Channel


     Table "public.coolingchannelcoiltagged" 
   Column    |         Type          | Modifiers 
-------------+-----------------------+-----------
 tagid       | integer               | 
 magnetname  | character varying(50) | 
 name        | character varying(50) | 
 calibration | double precision      | 
 ilim        | double precision      | 
 iset        | double precision      | 
 rate        | double precision      | 
 stability   | double precision      | 
 vlim        | double precision      | 

geometry - GDML


    Column     |            Type             |                       Modifiers                       
---------------+-----------------------------+-------------------------------------------------------
 id            | integer                     | not null default nextval('geometry_id_seq'::regclass)
 validfromtime | timestamp without time zone | 
 gdml          | bytea                       | 
 creationtime  | timestamp without time zone | 

Parameter

   Column   |         Type          |                           Modifiers                           
------------+-----------------------+---------------------------------------------------------------
 partype    | character varying(24) | 
 parvalue   | double precision      | 
 parname    | character varying(64) | 
 paramID    | integer               | not null default nextval('"Parameter_paramID_seq"'::regclass)
 calibID    | bigint                | 
 paramSetID | bigint                | 

ParameterSet

   Column   |  Type   |                              Modifiers                              
------------+---------+---------------------------------------------------------------------
 element    | bigint  | 
 calibID    | bigint  | 
 paramSetID | integer | not null default nextval('"ParameterSet_paramSetID_seq"'::regclass)

beamlinepvs

    Column    |          Type          | Modifiers 
--------------+------------------------+-----------
 pvdata       | integer                | not null
 magnetname   | character varying(10)  | 
 pvname       | character varying(50)  | 
 description  | character varying(150) | 
 pvtype       | character varying(20)  | 
 datatype     | character varying(20)  | 
 egu          | character varying(10)  | 
 alarmhandler | boolean                | 
 archiver     | boolean                | 
 control      | boolean                | 
 display      | boolean                | 

taggedmagnets

   Column   |         Type          |                            Modifiers                             
------------+-----------------------+------------------------------------------------------------------
 setcurrent | double precision      | 
 magnetname | character varying(24) | not null
 tag        | character varying(56) | not null
 magnetid   | integer               | not null default nextval('taggedmagnets_magnetid_seq'::regclass)

taggedrun

   Column    |         Type          | Modifiers 
-------------+-----------------------+-----------
 notes       | text                  | 
 momentum_d1 | double precision      | 
 momentum_d2 | double precision      | 
 species     | character varying(12) | 
 step        | double precision      | 
 tag         | character varying(56) | not null