File indexing completed on 2024-04-06 12:03:14
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);
