File indexing completed on 2024-04-06 12:26:34
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));
