EcalCondDB/sql/create_calibration_data.sql

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);