Back to home page

Project CMSSW displayed by LXR

 
 

    


File indexing completed on 2021-02-14 14:25:19

0001 select dbms_metadata.get_ddl('TABLE','MYTABLE_NAME') from dual;
0002 
0003 1.          
0004 CREATE TABLE "CMS_LUMI_PROD"."REVISIONS"
0005    (    "REVISION_ID" NUMBER(20,0),
0006         "BRANCH_ID" NUMBER(20,0),
0007         "NAME" VARCHAR2(56),
0008         "BRANCH_NAME" VARCHAR2(4000),
0009         "COMMENT" VARCHAR2(1024),
0010         "CTIME" TIMESTAMP (6),
0011          CONSTRAINT "REVISIONS_PK" PRIMARY KEY ("REVISION_ID")
0012 
0013 CREATE TABLE "CMS_LUMI_PROD"."REVISIONS_ID"
0014    (    "NEXTID" NUMBER(20,0),
0015          CONSTRAINT "REVISIONS_ID_PK" PRIMARY KEY ("NEXTID")
0016  
0017 create index revisions_branch_id on revision(branchid)
0018 
0019 2.
0020 CREATE TABLE "CMS_LUMI_PROD"."LUMINORMS"
0021    (    "DATA_ID" NUMBER(20,0),
0022         "ENTRY_ID" NUMBER(20,0),
0023         "ENTRY_NAME" VARCHAR2(56),
0024         "AMODETAG" VARCHAR2(28),
0025         "NORM_1" BINARY_FLOAT,
0026         "EGEV_1" NUMBER(10,0),
0027         "NORM_2" BINARY_FLOAT,
0028         "EGEV_2" NUMBER(10,0),
0029          CONSTRAINT "LUMINORMS_PK" PRIMARY KEY ("DATA_ID")
0030     )
0031 
0032 CREATE TABLE "CMS_LUMI_PROD"."LUMINORMS_ENTRIES"
0033    (    "ENTRY_ID" NUMBER(20,0),
0034         "REVISION_ID" NUMBER(20,0),
0035         "NAME" VARCHAR2(56),
0036          CONSTRAINT "LUMINORMS_ENTRIES_PK" PRIMARY KEY ("ENTRY_ID")
0037    )
0038 
0039 CREATE TABLE "CMS_LUMI_PROD"."LUMINORMS_ID"
0040    (    "NEXTID" NUMBER(20,0),
0041          CONSTRAINT "LUMINORMS_ID_PK" PRIMARY KEY ("NEXTID")
0042    )
0043 
0044 CREATE TABLE "CMS_LUMI_PROD"."LUMINORMS_ENTRIES_ID"
0045   (     "NEXTID" NUMBER(20,0),
0046          CONSTRAINT "LUMINORMS_ENTRIES_ID_PK" PRIMARY KEY ("NEXTID")
0047   )
0048 
0049 CREATE TABLE "CMS_LUMI_PROD"."LUMINORMS_REV"
0050    (    "DATA_ID" NUMBER(20,0),
0051         "REVISION_ID" NUMBER(20,0),
0052          CONSTRAINT "LUMINORMS_REV_PK" PRIMARY KEY ("DATA_ID", "REVISION_ID")
0053    )
0054 
0055 3.
0056 CREATE TABLE "CMS_LUMI_PROD"."LUMIDATA"
0057    (    "DATA_ID" NUMBER(20,0),
0058         "ENTRY_ID" NUMBER(20,0),
0059         "ENTRY_NAME" VARCHAR2(56),
0060         "SOURCE" VARCHAR2(128),
0061         "RUNNUM" NUMBER(10,0),
0062         "NOMINALEGEV" BINARY_FLOAT,
0063          CONSTRAINT "LUMIDATA_PK" PRIMARY KEY ("DATA_ID")
0064    )
0065 create index lumidata_entry_id on lumidata(entry_id);
0066 
0067 CREATE TABLE "CMS_LUMI_PROD"."LUMIDATA_ID"
0068    (    "NEXTID" NUMBER(20,0),
0069          CONSTRAINT "LUMIDATA_ID_PK" PRIMARY KEY ("NEXTID")
0070 )
0071 CREATE TABLE "CMS_LUMI_PROD"."LUMIDATA_ENTRIES"
0072    (    "ENTRY_ID" NUMBER(20,0),
0073         "REVISION_ID" NUMBER(20,0),
0074         "NAME" VARCHAR2(56),
0075          CONSTRAINT "LUMIDATA_ENTRIES_PK" PRIMARY KEY ("ENTRY_ID")
0076    )
0077 CREATE TABLE "CMS_LUMI_PROD"."LUMIDATA_REV"
0078    (    "DATA_ID" NUMBER(20,0),
0079         "REVISION_ID" NUMBER(20,0),
0080          CONSTRAINT "LUMIDATA_REV_PK" PRIMARY KEY ("DATA_ID", "REVISION_ID")
0081   )
0082 
0083 CREATE TABLE "CMS_LUMI_PROD"."LUMIDATA_ENTRIES_ID"
0084    (    "NEXTID" NUMBER(20,0),
0085          CONSTRAINT "LUMIDATA_ENTRIES_ID_PK" PRIMARY KEY ("NEXTID")
0086    )
0087 
0088 4.
0089 CREATE TABLE "CMS_LUMI_PROD"."CMSRUNSUMMARY"
0090    (    "RUNNUM" NUMBER(10,0),
0091         "HLTKEY" VARCHAR2(128) NOT NULL ENABLE,
0092         "FILLNUM" NUMBER(10,0),
0093         "SEQUENCE" VARCHAR2(56) NOT NULL ENABLE,
0094         "STARTTIME" TIMESTAMP (6),
0095         "STOPTIME" TIMESTAMP (6),
0096         "L1KEY" VARCHAR2(128),
0097         "AMODETAG" VARCHAR2(28),
0098         "EGEV" NUMBER(10,0),
0099         "FILLSCHEME" VARCHAR2(128),
0100         "NCOLLIDINGBUNCHES" NUMBER(10,0),
0101          CONSTRAINT "CMSRUNSUMMARY_PK" PRIMARY KEY ("RUNNUM")
0102 )
0103 5. 
0104 CREATE TABLE "CMS_LUMI_PROD"."LUMISUMMARYV2"
0105    (    "DATA_ID" NUMBER(20,0),
0106         "RUNNUM" NUMBER(10,0),
0107         "LUMILSNUM" NUMBER(10,0),
0108         "CMSLSNUM" NUMBER(10,0),
0109         "INSTLUMI" BINARY_FLOAT,
0110         "INSTLUMIERROR" BINARY_FLOAT,
0111         "INSTLUMIQUALITY" NUMBER(5,0),
0112         "BEAMSTATUS" VARCHAR2(28),
0113         "BEAMENERGY" BINARY_FLOAT,
0114         "NUMORBIT" NUMBER(10,0),
0115         "STARTORBIT" NUMBER(10,0),
0116         "CMSBXINDEXBLOB" BLOB,
0117         "BEAMINTENSITYBLOB_1" BLOB,
0118         "BEAMINTENSITYBLOB_2" BLOB,
0119         "BXLUMIVALUE_OCC1" BLOB,
0120         "BXLUMIVALUE_OCC2" BLOB,
0121         "BXLUMIVALUE_ET" BLOB,
0122         "BXLUMIERROR_OCC1" BLOB,
0123         "BXLUMIERROR_OCC2" BLOB,
0124         "BXLUMIERROR_ET" BLOB,
0125         "BXLUMIQUALITY_OCC1" BLOB,
0126         "BXLUMIQUALITY_OCC2" BLOB,
0127         "BXLUMIQUALITY_ET" BLOB,
0128         "NCOLLIDINGBUNCHES" NUMBER(10,0),
0129          CONSTRAINT "LUMISUMMARYV2_PK" PRIMARY KEY ("DATA_ID", "LUMILSNUM")
0130 )
0131 
0132 6.
0133 CREATE TABLE "CMS_LUMI_PROD"."TRGDATA"
0134    (    "DATA_ID" NUMBER(20,0),
0135         "ENTRY_ID" NUMBER(20,0),
0136         "ENTRY_NAME" VARCHAR2(56),
0137         "SOURCE" VARCHAR2(128),
0138         "RUNNUM" NUMBER(10,0),
0139         "BITZERONAME" VARCHAR2(56),
0140         "BITNAMECLOB" CLOB,
0141          CONSTRAINT "TRGDATA_PK" PRIMARY KEY ("DATA_ID")
0142 )
0143 CREATE TABLE "CMS_LUMI_PROD"."TRGDATA_REV"
0144    (    "DATA_ID" NUMBER(20,0),
0145         "REVISION_ID" NUMBER(20,0),
0146          CONSTRAINT "TRGDATA_REV_PK" PRIMARY KEY ("DATA_ID", "REVISION_ID")
0147 )
0148 create table trgdata_entries(       
0149      entry_id    uint64 not null             ,
0150      revision_id uint64 not null references revisions(revision_id),
0151      name    string  (56)        
0152 )
0153 create table trgdata_id(             #id helper table
0154      nextid uint64 PK
0155 )
0156 create table trgdata_entries_id(       #id helper table
0157      nextid uint64 PK
0158 )
0159 7.
0160 CREATE TABLE "CMS_LUMI_PROD"."LSTRG"
0161    (    "DATA_ID" NUMBER(20,0),
0162         "RUNNUM" NUMBER(10,0),
0163         "CMSLSNUM" NUMBER(10,0),
0164         "DEADTIMECOUNT" NUMBER(20,0),
0165         "BITZEROCOUNT" NUMBER(10,0),
0166         "BITZEROPRESCALE" NUMBER(10,0),
0167         "DEADFRAC" BINARY_FLOAT,
0168         "PRESCALEBLOB" BLOB,
0169         "TRGCOUNTBLOB" BLOB,
0170          CONSTRAINT "LSTRG_PK" PRIMARY KEY ("DATA_ID", "CMSLSNUM")
0171  )
0172 
0173 8.
0174 CREATE TABLE "CMS_LUMI_PROD"."HLTDATA"
0175    (    "DATA_ID" NUMBER(20,0),
0176         "ENTRY_ID" NUMBER(20,0),
0177         "ENTRY_NAME" VARCHAR2(56),
0178         "RUNNUM" NUMBER(10,0),
0179         "SOURCE" VARCHAR2(128),
0180         "NPATH" NUMBER(10,0),
0181         "PATHNAMECLOB" CLOB,
0182          CONSTRAINT "HLTDATA_PK" PRIMARY KEY ("DATA_ID")
0183 )
0184 
0185 CREATE TABLE "CMS_LUMI_PROD"."HLTDATA_ENTRIES"
0186    (    "ENTRY_ID" NUMBER(20,0),
0187         "REVISION_ID" NUMBER(20,0),
0188         "NAME" VARCHAR2(56),
0189          CONSTRAINT "HLTDATA_ENTRIES_PK" PRIMARY KEY ("ENTRY_ID")
0190 )
0191 
0192 create table hltdata_id(         
0193      nextid uint64 PK
0194 )
0195 create table hltdata_entries_id(     
0196      nextid uint64 PK
0197 )
0198 create table hltdata_rev(   
0199     data_id uint64 not null references hltdata(data_id),
0200     revision_id uint64 not null references revisions(revision_id) 
0201     (data_id,revision_id) PK 
0202 )
0203 9.
0204 create table lshlt(         
0205    data_id uint64 not null references hltdata(data_id),
0206    runnum   uint32 not null,
0207    cmslsnum uint32 not null,
0208    prescaleblob blob,
0209    hltcountblob    blob,
0210    hltacceptblob     blob
0211    (data_id,cmslsnum) PK
0212 )
0213 10.
0214 create table trghltmap(           
0215    hltkey string(128) not null,
0216    hltpathname string(256) not null,
0217    l1seed      string(1024) not null
0218    (hltkey,hltpathname,l1seed) PK
0219 )
0220 11.
0221 create table lumivalidation(      
0222    runnum uint32 not null,
0223    cmslsnum uint32 not null,
0224    flag string, (28)
0225    comment string (1024)
0226 )
0227 12
0228 create table FILLSCHEME (
0229    fillscheme_id(uint64),        PK
0230    fillschemepattern(string),    NOT NULL (128)
0231    correctionfactor(float),      NOT NULL
0232 )
0233 
0234 create table INTGLUMI(
0235   intglumi_id uint64 PK,    
0236   runnum uint32 not null,
0237   startrun uint32,
0238   intglumi float
0239 )
0240 create table INTGLUMI(RUNNUM NUMBER(10),STARTRUN NUMBER(10), INTGLUMI BINARY_FLOAT , constraint PK_INTGLUMI primary key(RUNNUM,STARTRUN));