EcalCondDB/sql/create_laser_new.sql

0001 /*

0002  *

0003  * GO 20091112: indexes added

0004  *

0005  */
0006
0007 CREATE SEQUENCE lmf_run_tag_sq INCREMENT BY 1 START WITH 1 NOCACHE;
0008
0009 CREATE SEQUENCE lmf_run_iov_sq INCREMENT BY 1 START WITH 1 NOCACHE;
0010
0011 /*  LMF_RUN_TAG  */
0012 CREATE TABLE LMF_RUN_TAG
0013 (
0014   GEN_TAG VARCHAR2(100),
0015   VERSION NUMBER(4),
0016   TAG_ID  NUMBER NOT NULL
0017 )
0018 /
0019
0020 ALTER TABLE LMF_RUN_TAG
0021   ADD CONSTRAINT LMF_RUN_TAG_PK PRIMARY KEY (TAG_ID)
0022 /
0023
0024
0025 CREATE TABLE LMF_LASER_COLORS_DEF
0026 (
0027 LMF_COLOR_ID NUMBER(3) NOT NULL,
0028 LASER_COLOR  VARCHAR2(10) NOT NULL
0029 )
0030 /
0031
0032 ALTER TABLE LMF_LASER_COLORS_DEF
0033   ADD CONSTRAINT LMF_LASER_COLORS_DEF_PK PRIMARY KEY (LMF_COLOR_ID)
0034 /
0035
0036 INSERT INTO LMF_LASER_COLORS_DEF VALUES (1, 'BLUE')
0037 /
0038 INSERT INTO LMF_LASER_COLORS_DEF VALUES (2, 'IRED')
0039 /
0040
0041 /*  LMF_RUN_IOV  */
0042 CREATE TABLE LMF_RUN_IOV
0043 (
0044   LMF_IOV_ID     NUMBER NOT NULL,
0045   TAG_ID         NUMBER NOT NULL,
0046   RUN_IOV_ID     NUMBER(10) NOT NULL,
0047   SUBRUN_NUM     NUMBER NOT NULL,
0048   SEQUENCE_NUM   NUMBER(4) NOT NULL,
0049   LMR            NUMBER(3) NOT NULL,
0050   LASER_COLOR    NUMBER(3) NOT NULL ,
0051   LASER_TYPE     NUMBER(4) NOT NULL,
0052   SUBRUN_START DATE NOT NULL,
0053   SUBRUN_END   DATE NOT NULL,
0054   SUBRUN_TYPE  VARCHAR2(20) NOT NULL,
0055   db_timestamp          TIMESTAMP DEFAULT sys_extract_utc(SYSTIMESTAMP) NOT NULL
0056 )
0057 /
0058
0059 ALTER TABLE LMF_RUN_IOV
0060   ADD CONSTRAINT LMF_RUN_IOV_PK PRIMARY KEY (LMF_IOV_ID)
0061 /
0062
0063 ALTER TABLE LMF_RUN_IOV
0064   ADD CONSTRAINT LMF_RUN_IOV_UK UNIQUE (RUN_IOV_ID,SUBRUN_NUM)
0065 /
0066
0067 ALTER TABLE LMF_RUN_IOV
0068   ADD CONSTRAINT LMF_RUN_IOV_FK1 FOREIGN KEY (RUN_IOV_ID)
0069   REFERENCES RUN_IOV(IOV_ID)
0070 /
0071
0072 ALTER TABLE LMF_RUN_IOV
0073   ADD CONSTRAINT LMF_RUN_IOV_FK2 FOREIGN KEY (TAG_ID)
0074   REFERENCES LMF_RUN_TAG(TAG_ID)
0075 /
0076
0077 ALTER TABLE LMF_RUN_IOV
0078   ADD CONSTRAINT LMF_RUN_IOV_FK3 FOREIGN KEY (LASER_COLOR)
0079   REFERENCES LMF_LASER_COLORS_DEF(LMF_COLOR_ID)
0080 /
0081
0082 CREATE TABLE RUN_LMF_SEQUENCE_DAT
0083 (
0084   RUN_IOV_ID    NUMBER(10) NOT NULL,
0085   SEQUENCE_NUM  NUMBER(4) NOT NULL,
0086   USER_COMMENT  VARCHAR2(4000)
0087 )
0088 /
0089
0090 ALTER TABLE RUN_LMF_SEQUENCE_DAT
0091   ADD CONSTRAINT RUN_LMF_SEQUENCE_DAT_PK PRIMARY KEY (RUN_IOV_ID, SEQUENCE_NUM)
0092 /
0093
0094 ALTER TABLE RUN_LMF_SEQUENCE_DAT
0095   ADD CONSTRAINT RUN_LMF_SEQ_DAT_FK1 FOREIGN KEY (RUN_IOV_ID)
0096   REFERENCES RUN_IOV(IOV_ID)
0097 /
0098
0099 /*  LMF_RUN_IOV  */
0100 CREATE OR REPLACE VIEW  LMF_SEQUENCE_DAT AS
0101 SELECT DISTINCT
0102   RUN_IOV_ID  ,
0103   SEQUENCE_NUM ,
0104   MIN(SUBRUN_START) SEQ_START ,
0105   MAX(SUBRUN_END) SEQ_END
0106 FROM LMF_RUN_IOV
0107 GROUP BY RUN_IOV_ID, SEQUENCE_NUM ;
0108
0109 CREATE INDEX lmf_run_iov_startend_ix ON lmf_run_iov (subrun_start, subrun_end);
0110 CREATE INDEX lmf_run_iov_run_iov_id_ix ON lmf_run_iov (run_iov_id);
0111
0112 /*  LMF_LASER_CONFIG_DAT  */
0113 CREATE TABLE LMF_LASER_CONFIG_DAT
0114 (
0115   LMF_IOV_ID     NUMBER NOT NULL,
0116   LOGIC_ID       NUMBER NOT NULL,
0117   WAVELENGTH     NUMBER,
0118   VFE_GAIN       NUMBER,
0119   PN_GAIN        NUMBER,
0120   LSR_POWER      NUMBER,
0121   LSR_ATTENUATOR NUMBER,
0122   LSR_CURRENT    NUMBER,
0123   LSR_DELAY_1    NUMBER,
0124   LSR_DELAY_2    NUMBER
0125 )
0126 /
0127
0128 ALTER TABLE LMF_LASER_CONFIG_DAT
0129   ADD CONSTRAINT LMF_LASER_CONFIG_DAT_PK PRIMARY KEY (LMF_IOV_ID,LOGIC_ID)
0130 /
0131
0132 ALTER TABLE LMF_LASER_CONFIG_DAT
0133   ADD CONSTRAINT LMF_LASER_CONFIG_DAT_FK1 FOREIGN KEY (LMF_IOV_ID)
0134   REFERENCES LMF_RUN_IOV(LMF_IOV_ID)
0135 /
0136
0137
0138 /*  LMF_RUN_DAT  */
0139 CREATE TABLE LMF_RUN_DAT
0140 (
0141   LMF_IOV_ID   NUMBER NOT NULL,
0142   LOGIC_ID     NUMBER NOT NULL,
0143   NEVENTS      NUMBER,
0144   QUALITY_FLAG NUMBER
0145 )
0146 /
0147
0148 ALTER TABLE LMF_RUN_DAT
0149   ADD CONSTRAINT LMF_RUN_DAT_PK PRIMARY KEY (LMF_IOV_ID,LOGIC_ID)
0150 /
0151
0152 ALTER TABLE LMF_RUN_DAT
0153   ADD CONSTRAINT LMF_RUN_DAT_FK1 FOREIGN KEY (LMF_IOV_ID)
0154   REFERENCES LMF_RUN_IOV(LMF_IOV_ID)
0155 /
0156
0157
0158 /*  LMF_TEST_PULSE_CONFIG_DAT  */
0159 CREATE TABLE LMF_TEST_PULSE_CONFIG_DAT
0160 (
0161   LMF_IOV_ID NUMBER NOT NULL,
0162   LOGIC_ID   NUMBER NOT NULL,
0163   VFE_GAIN   NUMBER,
0164   DAC_MGPA   NUMBER,
0165   PN_GAIN    NUMBER,
0166   PN_VINJ    NUMBER
0167 )
0168 /
0169
0170 ALTER TABLE LMF_TEST_PULSE_CONFIG_DAT
0171   ADD CONSTRAINT LMF_TEST_PULSE_CONFIG_DAT_PK PRIMARY KEY (LMF_IOV_ID,LOGIC_ID)
0172 /
0173
0174 ALTER TABLE LMF_TEST_PULSE_CONFIG_DAT
0175   ADD CONSTRAINT LMF_TEST_PULSE_CONFIG_DAT_FK1 FOREIGN KEY (LMF_IOV_ID)
0176   REFERENCES LMF_RUN_IOV(LMF_IOV_ID)
0177 /
0178
0179
0180 /*  LMF_LASER_BLUE_PULSE_DAT  */
0181 CREATE TABLE LMF_LASER_BLUE_PULSE_DAT
0182 (
0183   LMF_IOV_ID  NUMBER NOT NULL,
0184   LOGIC_ID    NUMBER NOT NULL,
0185   FIT_METHOD  NUMBER,
0186   MTQ_AMPL    NUMBER,
0187   MTQ_TIME    NUMBER,
0188   MTQ_RISE    NUMBER,
0189   MTQ_FWHM    NUMBER,
0190   MTQ_FW20    NUMBER,
0191   MTQ_FW80    NUMBER,
0192   MTQ_SLIDING NUMBER
0193 )
0194 /
0195
0196 ALTER TABLE LMF_LASER_BLUE_PULSE_DAT
0197   ADD CONSTRAINT LMF_LASER_BLUE_PULSE_DAT_PK PRIMARY KEY (LMF_IOV_ID,LOGIC_ID)
0198 /
0199
0200 ALTER TABLE LMF_LASER_BLUE_PULSE_DAT
0201   ADD CONSTRAINT LMF_LASER_BLUE_PULSE_DAT_FK1 FOREIGN KEY (LMF_IOV_ID)
0202   REFERENCES LMF_RUN_IOV(LMF_IOV_ID)
0203 /
0204
0205
0206 /*  LMF_LASER_BLUE_PRIM_DAT  */
0207 CREATE TABLE LMF_LASER_BLUE_PRIM_DAT
0208 (
0209   LMF_IOV_ID        NUMBER NOT NULL,
0210   LOGIC_ID          NUMBER NOT NULL,
0211   FLAG              NUMBER,
0212   MEAN              NUMBER,
0213   RMS               NUMBER,
0214   PEAK              NUMBER,
0215   APD_OVER_PNA_MEAN NUMBER,
0216   APD_OVER_PNA_RMS  NUMBER,
0217   APD_OVER_PNA_PEAK NUMBER,
0218   APD_OVER_PNB_MEAN NUMBER,
0219   APD_OVER_PNB_RMS  NUMBER,
0220   APD_OVER_PNB_PEAK NUMBER,
0221   APD_OVER_PN_MEAN  NUMBER,
0222   APD_OVER_PN_RMS   NUMBER,
0223   APD_OVER_PN_PEAK  NUMBER,
0224   ALPHA             NUMBER,
0225   BETA              NUMBER,
0226   SHAPE_COR         NUMBER
0227 )
0228 /
0229
0230 ALTER TABLE LMF_LASER_BLUE_PRIM_DAT
0231   ADD CONSTRAINT LMF_LASER_BLUE_PRIM_DAT_PK PRIMARY KEY (LMF_IOV_ID,LOGIC_ID)
0232 /
0233
0234 ALTER TABLE LMF_LASER_BLUE_PRIM_DAT
0235   ADD CONSTRAINT LMF_LASER_BLUE_PRIM_DAT_FK1 FOREIGN KEY (LMF_IOV_ID)
0236   REFERENCES LMF_RUN_IOV(LMF_IOV_ID)
0237 /
0238
0239
0240 /*  LMF_CALIB_PRIM_DAT  */
0241 CREATE TABLE LMF_CALIB_PRIM_DAT
0242 (
0243   LMF_IOV_ID NUMBER NOT NULL,
0244   LOGIC_ID   NUMBER NOT NULL,
0245   FLAG       NUMBER,
0246   MEAN       NUMBER,
0247   RMS        NUMBER,
0248   PEAK       NUMBER
0249 )
0250 /
0251
0252 ALTER TABLE LMF_CALIB_PRIM_DAT
0253   ADD CONSTRAINT LMF_CALIB_PRIM_DAT_PK PRIMARY KEY (LMF_IOV_ID,LOGIC_ID)
0254 /
0255
0256 ALTER TABLE LMF_CALIB_PRIM_DAT
0257   ADD CONSTRAINT LMF_CALIB_PRIM_DAT_FK FOREIGN KEY (LMF_IOV_ID)
0258   REFERENCES LMF_RUN_IOV(LMF_IOV_ID)
0259 /
0260
0261 /* LMF_NLS_[LASR_COLOR]_DAT: will susbtitute LMF_CALIB_PRIM_DAT */
0262 CREATE TABLE LMF_VERSIONS
0263 (
0264   VERSION     INTEGER NOT NULL,
0265   DESCRIPTION VARCHAR(200)
0266 )
0267 /
0268
0269 ALTER TABLE LMF_VERSIONS
0270   ADD CONSTRAINT LMF_VERSIONS_PK PRIMARY KEY (VERSION)
0271 /
0272
0273 CREATE TABLE LMF_NLS_REF_BLUE_DAT
0274 (
0275   NLS_REF_ID NUMBER NOT NULL,
0276   LOGIC_ID   NUMBER NOT NULL,
0277   NORM       NUMBER,
0278   LMF_IOV_ID NUMBER NOT NULL,
0279   IOV_START  TIMESTAMP,
0280   IOV_END    TIMESTAMP,
0281   VMIN       INTEGER NOT NULL,
0282   VMAX       INTEGER NOT NULL
0283 )
0284 /
0285
0286 ALTER TABLE LMF_NLS_REF_BLUE_DAT
0287   ADD CONSTRAINT LMF_NLS_REF_BLUE_DAT_PK PRIMARY KEY (NLS_REF_ID, LOGIC_ID)
0288 /
0289
0290 ALTER TABLE LMF_NLS_REF_BLUE_DAT
0291   ADD CONSTRAINT LMF_NLS_REF_BLUE_DAT_FK FOREIGN KEY (LMF_IOV_ID)
0292   REFERENCES LMF_RUN_IOV(LMF_IOV_ID)
0293 /
0294 ALTER TABLE LMF_NLS_REF_BLUE_DAT
0295   ADD CONSTRAINT LMF_NLS_REF_BLUE_DAT_VMIN_FK FOREIGN KEY (VMIN)
0296   REFERENCES LMF_VERSIONS(VERSION)
0297 /
0298 ALTER TABLE LMF_NLS_REF_BLUE_DAT
0299   ADD CONSTRAINT LMF_NLS_REF_BLUE_DAT_VMAX_FK FOREIGN KEY (VMAX)
0300   REFERENCES LMF_VERSIONS(VERSION)
0301 /
0302
0303 CREATE TABLE LMF_NLS_BLUE_DAT
0304 (
0305   LMF_IOV_ID NUMBER NOT NULL,
0306   LOGIC_ID   NUMBER NOT NULL,
0307   FLAG       INTEGER,
0308   MEAN       NUMBER,
0309   NLS_REF_ID NUMBER NOT NULL
0310 )
0311 /
0312
0313 ALTER TABLE LMF_NLS_BLUE_DAT
0314   ADD CONSTRAINT LMF_NLS_BLUE_DAT_PK PRIMARY KEY (LMF_IOV_ID, LOGIC_ID)
0315 /
0316
0317 ALTER TABLE LMF_NLS_BLUE_DAT
0318   ADD CONSTRAINT LMF_NLS_BLUE_DAT_FK FOREIGN KEY (LMF_IOV_ID)
0319   REFERENCES LMF_RUN_IOV(LMF_IOV_ID)
0320 /
0321 ALTER TABLE LMF_NLS_BLUE_DAT
0322   ADD CONSTRAINT LMF_NLS_BLUE_DAT_REF_FK FOREIGN KEY (NLS_REF_ID, LOGIC_ID)
0323   REFERENCES LMF_NLS_REF_BLUE_DAT(NLS_REF_ID, LOGIC_ID)
0324 /
0325
0326 CREATE TABLE LMF_NLS_REF_IRED_DAT
0327 (
0328   NLS_REF_ID NUMBER NOT NULL,
0329   LOGIC_ID   NUMBER NOT NULL,
0330   NORM       NUMBER,
0331   LMF_IOV_ID NUMBER NOT NULL,
0332   IOV_START  TIMESTAMP,
0333   IOV_END    TIMESTAMP,
0334   VMIN       INTEGER NOT NULL,
0335   VMAX       INTEGER NOT NULL
0336 )
0337 /
0338
0339 ALTER TABLE LMF_NLS_REF_IRED_DAT
0340   ADD CONSTRAINT LMF_NLS_REF_IRED_DAT_PK PRIMARY KEY (NLS_REF_ID, LOGIC_ID)
0341 /
0342
0343 ALTER TABLE LMF_NLS_REF_IRED_DAT
0344   ADD CONSTRAINT LMF_NLS_REF_IRED_DAT_FK FOREIGN KEY (LMF_IOV_ID)
0345   REFERENCES LMF_RUN_IOV(LMF_IOV_ID)
0346 /
0347 ALTER TABLE LMF_NLS_REF_IRED_DAT
0348   ADD CONSTRAINT LMF_NLS_REF_IRED_DAT_VMIN_FK FOREIGN KEY (VMIN)
0349   REFERENCES LMF_VERSIONS(VERSION)
0350 /
0351 ALTER TABLE LMF_NLS_REF_IRED_DAT
0352   ADD CONSTRAINT LMF_NLS_REF_IRED_DAT_VMAX_FK FOREIGN KEY (VMAX)
0353   REFERENCES LMF_VERSIONS(VERSION)
0354 /
0355
0356 CREATE TABLE LMF_NLS_IRED_DAT
0357 (
0358   LMF_IOV_ID NUMBER NOT NULL,
0359   LOGIC_ID   NUMBER NOT NULL,
0360   FLAG       INTEGER,
0361   MEAN       NUMBER,
0362   NLS_REF_ID NUMBER NOT NULL
0363 )
0364 /
0365
0366 ALTER TABLE LMF_NLS_IRED_DAT
0367   ADD CONSTRAINT LMF_NLS_IRED_DAT_PK PRIMARY KEY (LMF_IOV_ID, LOGIC_ID)
0368 /
0369
0370 ALTER TABLE LMF_NLS_IRED_DAT
0371   ADD CONSTRAINT LMF_NLS_IRED_DAT_FK FOREIGN KEY (LMF_IOV_ID)
0372   REFERENCES LMF_RUN_IOV(LMF_IOV_ID)
0373 /
0374 ALTER TABLE LMF_NLS_IRED_DAT
0375   ADD CONSTRAINT LMF_NLS_IRED_DAT_REF_FK FOREIGN KEY (NLS_REF_ID, LOGIC_ID)
0376   REFERENCES LMF_NLS_REF_IRED_DAT(NLS_REF_ID, LOGIC_ID)
0377 /
0378
0379 CREATE TABLE LMF_CORR_PARAM_DAT
0380 (
0381   CORR_PARAM_ID NUMBER NOT NULL,
0382   LOGIC_ID      NUMBER NOT NULL,
0383   LMF_IOV_ID    NUMBER NOT NULL,
0384   P1            NUMBER,
0385   P2            NUMBER,
0386   P3            NUMBER,
0387   T1            NUMBER,
0388   T2            NUMBER,
0389   T3            NUMBER,
0390   P1_ERR        NUMBER,
0391   P2_ERR        NUMBER,
0392   P3_ERR        NUMBER,
0393   IOV_START     TIMESTAMP,
0394   IOV_END       TIMESTAMP,
0395   FLAG          INTEGER,
0396   VMIN          INTEGER NOT NULL,
0397   VMAX          INTEGER NOT NULL
0398 )
0399 /
0400
0401 ALTER TABLE LMF_CORR_PARAM_DAT
0402   ADD CONSTRAINT LMF_CORR_PARAM_DAT_PK PRIMARY KEY (CORR_PARAM_ID, LOGIC_ID)
0403 /
0404
0405 ALTER TABLE LMF_CORR_PARAM_DAT
0406   ADD CONSTRAINT LMF_CORR_PARAM_DAT_FK FOREIGN KEY (LMF_IOV_ID)
0407   REFERENCES LMF_RUN_IOV(LMF_IOV_ID)
0408 /
0409 ALTER TABLE LMF_CORR_PARAM_DAT
0410   ADD CONSTRAINT LMF_CORR_PARAM_DAT_VMIN_FK FOREIGN KEY (VMIN)
0411   REFERENCES LMF_VERSIONS(VERSION)
0412 /
0413 ALTER TABLE LMF_CORR_PARAM_DAT
0414   ADD CONSTRAINT LMF_CORR_PARAM_DAT_VMAX_FK FOREIGN KEY (VMAX)
0415   REFERENCES LMF_VERSIONS(VERSION)
0416 /
0417
0418 /*  RUN_LASERRUN_CONFIG_DAT  */
0419 CREATE TABLE RUN_LASERRUN_CONFIG_DAT
0420 (
0421   IOV_ID              NUMBER NOT NULL,
0422   LOGIC_ID            NUMBER NOT NULL,
0423   LASER_SEQUENCE_TYPE VARCHAR2(20),
0424   LASER_SEQUENCE_COND VARCHAR2(20)
0425 )
0426 /
0427
0428 ALTER TABLE RUN_LASERRUN_CONFIG_DAT
0429   ADD CONSTRAINT RUN_LASERRUN_CONFIG_DAT_PK UNIQUE (IOV_ID,LOGIC_ID)
0430 /
0431
0432 ALTER TABLE RUN_LASERRUN_CONFIG_DAT
0433   ADD CONSTRAINT RUN_LASERRUN_CONFIG_DAT_FK FOREIGN KEY (IOV_ID)
0434   REFERENCES RUN_IOV(IOV_ID)
0435 /
0436
0437
0438
0439 /*  LMF_LASER_BLUE_PN_PRIM_DAT  */
0440 CREATE TABLE LMF_LASER_BLUE_PN_PRIM_DAT
0441 (
0442   LMF_IOV_ID        NUMBER NOT NULL,
0443   LOGIC_ID          NUMBER NOT NULL,
0444   FLAG              NUMBER,
0445   MEAN              NUMBER,
0446   RMS               NUMBER,
0447   PEAK              NUMBER,
0448   PNA_OVER_PNB_MEAN NUMBER,
0449   PNA_OVER_PNB_RMS  NUMBER,
0450   PNA_OVER_PNB_PEAK NUMBER
0451 )
0452 /
0453
0454 ALTER TABLE LMF_LASER_BLUE_PN_PRIM_DAT
0455   ADD CONSTRAINT LMF_LASER_BLUE_PN_DAT_PK PRIMARY KEY (LMF_IOV_ID,LOGIC_ID)
0456 /
0457
0458 ALTER TABLE LMF_LASER_BLUE_PN_PRIM_DAT
0459   ADD CONSTRAINT LMF_LASER_BLUE_PN_PRIM_DAT_FK FOREIGN KEY (LMF_IOV_ID)
0460   REFERENCES LMF_RUN_IOV(LMF_IOV_ID)
0461 /
0462
0463
0464
0465
0466 /* Infra red laser runs */
0467
0468
0469 CREATE TABLE LMF_LASER_IRED_PN_PRIM_DAT
0470 (
0471   LMF_IOV_ID        NUMBER NOT NULL,
0472   LOGIC_ID          NUMBER NOT NULL,
0473   FLAG              NUMBER,
0474   MEAN              NUMBER,
0475   RMS               NUMBER,
0476   PEAK              NUMBER,
0477   PNA_OVER_PNB_MEAN NUMBER,
0478   PNA_OVER_PNB_RMS  NUMBER,
0479   PNA_OVER_PNB_PEAK NUMBER
0480 )
0481 /
0482
0483 ALTER TABLE LMF_LASER_IRED_PN_PRIM_DAT
0484   ADD CONSTRAINT LMF_LASER_IRED_PN_DAT_PK PRIMARY KEY (LMF_IOV_ID,LOGIC_ID)
0485 /
0486
0487 ALTER TABLE LMF_LASER_IRED_PN_PRIM_DAT
0488   ADD CONSTRAINT LMF_LASER_IRED_PN_PRIM_DAT_FK FOREIGN KEY (LMF_IOV_ID)
0489   REFERENCES LMF_RUN_IOV(LMF_IOV_ID)
0490 /
0491
0492
0493 /*  LMF_LASER_IRED_PULSE_DAT  */
0494 CREATE TABLE LMF_LASER_IRED_PULSE_DAT
0495 (
0496   LMF_IOV_ID  NUMBER NOT NULL,
0497   LOGIC_ID    NUMBER NOT NULL,
0498   FIT_METHOD  NUMBER,
0499   MTQ_AMPL    NUMBER,
0500   MTQ_TIME    NUMBER,
0501   MTQ_RISE    NUMBER,
0502   MTQ_FWHM    NUMBER,
0503   MTQ_FW20    NUMBER,
0504   MTQ_FW80    NUMBER,
0505   MTQ_SLIDING NUMBER
0506 )
0507 /
0508
0509 ALTER TABLE LMF_LASER_IRED_PULSE_DAT
0510   ADD CONSTRAINT LMF_LASER_IRED_PULSE_DAT_PK PRIMARY KEY (LMF_IOV_ID,LOGIC_ID)
0511 /
0512
0513 ALTER TABLE LMF_LASER_IRED_PULSE_DAT
0514   ADD CONSTRAINT LMF_LASER_IRED_PULSE_DAT_FK1 FOREIGN KEY (LMF_IOV_ID)
0515   REFERENCES LMF_RUN_IOV(LMF_IOV_ID)
0516 /
0517
0518
0519 /*  LMF_LASER_IRED_PRIM_DAT  */
0520 CREATE TABLE LMF_LASER_IRED_PRIM_DAT
0521 (
0522   LMF_IOV_ID        NUMBER NOT NULL,
0523   LOGIC_ID          NUMBER NOT NULL,
0524   FLAG              NUMBER,
0525   MEAN              NUMBER,
0526   RMS               NUMBER,
0527   PEAK              NUMBER,
0528   APD_OVER_PNA_MEAN NUMBER,
0529   APD_OVER_PNA_RMS  NUMBER,
0530   APD_OVER_PNA_PEAK NUMBER,
0531   APD_OVER_PNB_MEAN NUMBER,
0532   APD_OVER_PNB_RMS  NUMBER,
0533   APD_OVER_PNB_PEAK NUMBER,
0534   APD_OVER_PN_MEAN  NUMBER,
0535   APD_OVER_PN_RMS   NUMBER,
0536   APD_OVER_PN_PEAK  NUMBER,
0537   ALPHA             NUMBER,
0538   BETA              NUMBER,
0539   SHAPE_COR         NUMBER
0540 )
0541 /
0542
0543 ALTER TABLE LMF_LASER_IRED_PRIM_DAT
0544   ADD CONSTRAINT LMF_LASER_IRED_PRIM_DAT_PK PRIMARY KEY (LMF_IOV_ID,LOGIC_ID)
0545 /
0546
0547 ALTER TABLE LMF_LASER_IRED_PRIM_DAT
0548   ADD CONSTRAINT LMF_LASER_IRED_PRIM_DAT_FK1 FOREIGN KEY (LMF_IOV_ID)
0549   REFERENCES LMF_RUN_IOV(LMF_IOV_ID)
0550 /
0551
0552 CREATE INDEX LMF_LASER_CONFIG_DAT_IX ON LMF_LASER_CONFIG_DAT(LMF_IOV_ID)
0553 /
0554
0555 CREATE INDEX LMF_RUN_DAT_IX ON LMF_RUN_DAT(LMF_IOV_ID)
0556 /
0557
0558 CREATE INDEX LMF_TEST_PULSE_CONFIG_DAT_IX ON LMF_TEST_PULSE_CONFIG_DAT(LMF_IOV_ID)
0559 /
0560
0561 CREATE INDEX LMF_LASER_BLUE_PULSE_DAT_IX ON LMF_LASER_BLUE_PULSE_DAT(LMF_IOV_ID)
0562 /
0563
0564 CREATE INDEX LMF_LASER_BLUE_PRIM_DAT_IX ON LMF_LASER_BLUE_PRIM_DAT(LMF_IOV_ID)
0565 /
0566
0567 CREATE INDEX LMF_CALIB_PRIM_DAT_IX ON LMF_CALIB_PRIM_DAT(LMF_IOV_ID)
0568 /
0569
0570 CREATE INDEX LMF_NLS_BLUE_DAT_IX ON LMF_NLS_BLUE_DAT(LMF_IOV_ID)
0571 /
0572
0573 CREATE INDEX LMF_NLS_IRED_DAT_IX ON LMF_NLS_IRED_DAT(LMF_IOV_ID)
0574 /
0575
0576 CREATE INDEX LMF_NLS_REF_BLUE_DAT_IX ON LMF_NLS_REF_BLUE_DAT(LMF_IOV_ID)
0577 /
0578
0579 CREATE INDEX LMF_NLS_REF_IRED_DAT_IX ON LMF_NLS_REF_IRED_DAT(LMF_IOV_ID)
0580 /
0581
0582 CREATE INDEX LMF_CORR_PARAM_DAT_IX ON LMF_CORR_PARAM_DAT(LMF_IOV_ID)
0583 /
0584
0585 CREATE INDEX RUN_LASERRUN_CONFIG_DAT_IX ON RUN_LASERRUN_CONFIG_DAT(IOV_ID)
0586 /
0587
0588 CREATE INDEX LMF_LASER_BLUE_PN_PRIM_DAT_IX ON LMF_LASER_BLUE_PN_PRIM_DAT(LMF_IOV_ID)
0589 /
0590
0591 CREATE INDEX LMF_LASER_IRED_PN_PRIM_DAT_IX ON LMF_LASER_IRED_PN_PRIM_DAT(LMF_IOV_ID)
0592 /
0593
0594 CREATE INDEX LMF_LASER_IRED_PULSE_DAT_IX ON LMF_LASER_IRED_PULSE_DAT(LMF_IOV_ID)
0595 /
0596
0597 CREATE INDEX LMF_LASER_IRED_PRIM_DAT_IX ON LMF_LASER_IRED_PRIM_DAT(LMF_IOV_ID)
0598 /