Back to home page

Project CMSSW displayed by LXR

 
 

    


File indexing completed on 2021-02-14 13:31:55

0001 /*
0002  *  Creates all the data tables referencing calibration_iov
0003  *  Requires:  create_calibration_core.sql
0004  */
0005 
0006 
0007 
0008 CREATE TABLE cali_general_dat (
0009   iov_id                NUMBER(10),
0010   logic_id              NUMBER(10), -- (SM)
0011   NUM_EVENTS            NUMBER(10), 
0012   comments              VARCHAR(100)  
0013 );
0014  
0015 ALTER TABLE cali_general_dat ADD CONSTRAINT cali_general_pk PRIMARY KEY (iov_id, logic_id);
0016 ALTER TABLE cali_general_dat ADD CONSTRAINT cali_general_fk FOREIGN KEY (iov_id) REFERENCES cali_iov (iov_id);
0017 
0018 
0019 
0020 CREATE TABLE cali_crystal_intercal_dat (
0021   iov_id                NUMBER(10),
0022   logic_id              NUMBER(10), -- (crystal)
0023   cali                  BINARY_FLOAT,
0024   cali_rms              BINARY_FLOAT,
0025   NUM_EVENTS            NUMBER(10), 
0026   task_status           char(1)         
0027 );
0028  
0029 ALTER TABLE cali_crystal_intercal_dat ADD CONSTRAINT cali_crystal_intercal_pk PRIMARY KEY (iov_id, logic_id);
0030 ALTER TABLE cali_crystal_intercal_dat ADD CONSTRAINT cali_crystal_intercal_fk FOREIGN KEY (iov_id) REFERENCES cali_iov (iov_id);
0031 
0032 CREATE TABLE cali_hv_scan_ratio_dat (
0033   iov_id                NUMBER(10),
0034   logic_id              NUMBER(10), -- (crystal)
0035   hvratio               BINARY_FLOAT,
0036   hvratio_rms           BINARY_FLOAT,
0037   task_status           char(1)         
0038 );
0039  
0040 ALTER TABLE cali_hv_scan_ratio_dat ADD CONSTRAINT cali_hv_scan_ratio_pk PRIMARY KEY (iov_id, logic_id);
0041 ALTER TABLE cali_hv_scan_ratio_dat ADD CONSTRAINT cali_hv_scan_ratio_fk FOREIGN KEY (iov_id) REFERENCES cali_iov (iov_id);
0042 
0043 CREATE TABLE CALI_GAIN_RATIO_DAT (
0044   iov_id                NUMBER(10),
0045   logic_id              NUMBER(10), -- (crystal)
0046   g1_g12                BINARY_FLOAT,
0047   g6_g12                BINARY_FLOAT,
0048   task_status           char(1)
0049 );
0050 
0051 ALTER TABLE CALI_GAIN_RATIO_DAT ADD CONSTRAINT CALI_GAIN_RATIO_pk PRIMARY KEY (iov_id, logic_id);
0052 ALTER TABLE CALI_GaIN_RATIO_DAT ADD CONSTRAINT CALI_GAIN_RATIO_fk FOREIGN KEY (iov_id) REFERENCES cali_iov (iov_id);
0053 
0054 CREATE TABLE CALI_TEMP_DAT (
0055   iov_id                NUMBER(10),
0056   logic_id              NUMBER(10), -- (crystal)
0057   beta                  BINARY_FLOAT,
0058   r25                   BINARY_FLOAT,
0059   offset                BINARY_FLOAT,
0060   task_status           char(1)
0061 );
0062 
0063 ALTER TABLE CALI_TEMP_DAT ADD CONSTRAINT CALI_TEMP_pk PRIMARY KEY (iov_id, logic_id);
0064 ALTER TABLE CALI_TEMP_DAT ADD CONSTRAINT CALI_TEMP_fk FOREIGN KEY (iov_id) REFERENCES cali_iov (iov_id);