CondTools/IntegrationTest/onlinedb/CSCGains_Online.sql - master - githubmirror/cmssw

CondTools/IntegrationTest/onlinedb/CSCGains_Online.sql

48 строк1 KB

Giulio Eulisse

Snapshot of CMSSW_6_2_0_pre8.

26 июн 2013, 18:12

26 июн 2013, 18:12214ab73

REM
REM Table GAINS
REM
create table GAINS (
record_id         number NOT NULL,
run_num           number UNIQUE NOT NULL,
data_taking_time  date DEFAULT sysdate NOT NULL,
insertion_time    date DEFAULT sysdate NOT NULL);
REM
REM Adding constraints for table GAINS
REM
alter table GAINS
  add constraint gain_run_pk primary key (record_id);

REM
REM Table GAINS_MAP
REM
create table GAINS_MAP (
map_id      number NOT NULL,
record_id   number NOT NULL,
map_index   number NOT NULL,
layer_id    number NOT NULL);
REM
REM Adding constraints for table GAINS_MAP
REM
alter table GAINS_MAP add (
   constraint gain_map_pk primary key (map_id),
   unique (record_id,map_index),
   unique (record_id,layer_id),
   constraint gain_map_fk foreign key (record_id)
                          references gains(record_id));

REM
REM Table GAINS_DATA
REM
create table GAINS_DATA (
map_id         number NOT NULL,
vec_index      number(5) NOT NULL,
gain_slope     binary_float NOT NULL,
gain_intercept binary_float NOT NULL,
gain_chi2      binary_float NOT NULL);
REM
REM Adding constraints for table GAINS_DATA
REM
alter table GAINS_DATA add (
   constraint gain_data_pk primary key (map_id,vec_index),
   constraint gain_data_fk foreign key (map_id)
                          references gains_map(map_id));