001
002
003
004
005
006
007
008
009
010 CREATE TABLE &1.."MDT_TUBE"
011 ( "SEQID" NUMBER NOT NULL,
012 "TUBE_ID" NUMBER(10) NOT NULL ,
013 "HEAD_ID" NUMBER NOT NULL ,
014 "CHAMBER" varchar2(10) NOT NULL,
015 "SITE_NAME" VARCHAR2(2) DEFAULT UPPER('&2') ,
016 "INSERT_TIME" VARCHAR2(29),
017 "LOWRUN" NUMBER(8) NOT NULL ,
018 "UPRUN" NUMBER(8) NOT NULL ,
019 "RUNFLAG" NUMBER(3) DEFAULT 0 NOT NULL ,
020 "CALIBFLAG" NUMBER(3) DEFAULT 0 NOT NULL ,
021 "VALIDFLAG" NUMBER(3) DEFAULT 0 NOT NULL ,
022 "ENTRIES" BINARY_FLOAT DEFAULT 0 NOT NULL ,
023 "CHISQUARE_1" BINARY_FLOAT DEFAULT -1 NOT NULL ,
024 "CHISQUARE_2" BINARY_FLOAT DEFAULT -1 NOT NULL ,
025 "P0" BINARY_FLOAT DEFAULT 0 NOT NULL ,
026 "P1" BINARY_FLOAT DEFAULT 0 NOT NULL ,
027 "P2" BINARY_FLOAT DEFAULT 0 NOT NULL ,
028 "P3" BINARY_FLOAT DEFAULT 0 NOT NULL ,
029 "P4" BINARY_FLOAT DEFAULT 0 NOT NULL ,
030 "P5" BINARY_FLOAT DEFAULT 0 NOT NULL ,
031 "P6" BINARY_FLOAT DEFAULT 0 NOT NULL ,
032 "P7" BINARY_FLOAT DEFAULT 0 NOT NULL ,
033 "P8" BINARY_FLOAT DEFAULT 0 NOT NULL ,
034 "P9" BINARY_FLOAT DEFAULT 0 NOT NULL ,
035 "P0_ERR" BINARY_FLOAT DEFAULT 0 NOT NULL ,
036 "P1_ERR" BINARY_FLOAT DEFAULT 0 NOT NULL ,
037 "P2_ERR" BINARY_FLOAT DEFAULT 0 NOT NULL ,
038 "P3_ERR" BINARY_FLOAT DEFAULT 0 NOT NULL ,
039 "P4_ERR" BINARY_FLOAT DEFAULT 0 NOT NULL ,
040 "P5_ERR" BINARY_FLOAT DEFAULT 0 NOT NULL ,
041 "P6_ERR" BINARY_FLOAT DEFAULT 0 NOT NULL ,
042 "P7_ERR" BINARY_FLOAT DEFAULT 0 NOT NULL ,
043 "P8_ERR" BINARY_FLOAT DEFAULT 0 NOT NULL ,
044 "P9_ERR" BINARY_FLOAT DEFAULT 0 NOT NULL ,
045 "COV_1" BINARY_FLOAT DEFAULT 0 NOT NULL ,
046 "COV_2" BINARY_FLOAT DEFAULT 0 NOT NULL ,
047 "COV_3" BINARY_FLOAT DEFAULT 0 NOT NULL ,
048 "COV_4" BINARY_FLOAT DEFAULT 0 NOT NULL ,
049 "ADC_0" BINARY_FLOAT DEFAULT 0 NOT NULL ,
050 "ADC_1" BINARY_FLOAT DEFAULT 0 NOT NULL ,
051 "ADC_2" BINARY_FLOAT DEFAULT 0 NOT NULL ,
052 "ADC_3" BINARY_FLOAT DEFAULT 0 NOT NULL ,
053 "ADC_0_ERR" BINARY_FLOAT DEFAULT 0 NOT NULL ,
054 "ADC_1_ERR" BINARY_FLOAT DEFAULT 0 NOT NULL ,
055 "ADC_2_ERR" BINARY_FLOAT DEFAULT 0 NOT NULL ,
056 "ADC_3_ERR" BINARY_FLOAT DEFAULT 0 NOT NULL ,
057 "ADC_CHISQUARE" BINARY_FLOAT DEFAULT 0 NOT NULL ,
058 "ADC_PEDESTAL" BINARY_FLOAT DEFAULT 0 NOT NULL ,
059 "ADC_PEDESTAL_WIDTH" BINARY_FLOAT DEFAULT 0 NOT NULL ,
060 "NHITS" NUMBER(6) DEFAULT 0 NOT NULL ,
061 "NHITS_ABOVE_ADC_CUT" NUMBER(6)DEFAULT 0 NOT NULL ,
062 "ALGO_FLAG" varchar2(12) DEFAULT 0 NOT NULL ,
063 "TUBE_GROUPING" varchar2(12) DEFAULT 0 NOT NULL ,
064 CONSTRAINT "HEAD_ID_SITE_REF" FOREIGN KEY ("HEAD_ID", "SITE_NAME") REFERENCES &1.."MDT_HEAD" ("HEAD_ID", "SITE_NAME") VALIDATE ,
065 CONSTRAINT "SEQID_SITE_PR" PRIMARY KEY ("SEQID", "SITE_NAME") VALIDATE ,
066 CHECK (uprun>=lowrun) VALIDATE )
067 TABLESPACE &4 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;
Due to the LXR bug, the updates fail sometimes to remove references to deleted files. The Saturday's full rebuilds fix these problems |
This page was automatically generated by the
LXR engine.
|
|