Back to home page

Project CMSSW displayed by LXR

 
 

    


File indexing completed on 2021-02-14 12:52:19

0001 CREATE TABLE st_ecalpedestals (
0002   iov_value_id NUMBER(10) NOT NULL,
0003   time NUMBER(38)
0004 );
0005 
0006 alter table st_ecalpedestals add constraint st_ecalpedestals_pk primary key (iov_value_id);
0007 
0008 
0009 CREATE TABLE st_ecalpedestals_item (
0010   pos NUMBER(10) NOT NULL,
0011   iov_value_id NUMBER(10) NOT NULL,
0012   det_id NUMBER(10) NOT NULL,
0013   mean_x1 BINARY_FLOAT NOT NULL,
0014   mean_x12 BINARY_FLOAT NOT NULL,
0015   mean_x6 BINARY_FLOAT NOT NULL,
0016   rms_x1 BINARY_FLOAT NOT NULL,
0017   rms_x12 BINARY_FLOAT NOT NULL,
0018   rms_x6 BINARY_FLOAT NOT NULL
0019 );
0020 
0021 alter table st_ecalpedestals_item add constraint st_ecalpedestals_item_pk primary key (iov_value_id, pos);
0022 alter table st_ecalpedestals_item add constraint st_ecalpedestals_item_fk foreign key (iov_value_id) references st_ecalpedestals (iov_value_id);