Back to home page

Project CMSSW displayed by LXR

 
 

    


File indexing completed on 2021-02-14 13:31:55

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 /