LumiDB/doc/pixellumitables.sql

0001 /*=========================PIXELLUMIDATA=======================*/
0002 CREATE TABLE "PIXELLUMIDATA"
0003 (       "DATA_ID" NUMBER(20,0),
0004         "ENTRY_ID" NUMBER(20,0),
0005         "ENTRY_NAME" VARCHAR2(56),
0006         "SOURCE" VARCHAR2(128),
0007         "RUNNUM" NUMBER(10,0),
0008         "NOMINALEGEV" BINARY_FLOAT,
0009          CONSTRAINT "PIXELLUMIDATA_PK" PRIMARY KEY ("DATA_ID")
0010 )
0011 PARTITION BY RANGE(RUNNUM)
0012 (
0013 PARTITION YEAR2011 VALUES LESS THAN(183338),
0014 PARTITION THEREST VALUES LESS THAN(MAXVALUE)
0015 );
0016 GRANT SELECT ON "PIXELLUMIDATA" TO PUBLIC;
0017 GRANT SELECT,INSERT,DELETE,UPDATE ON "PIXELLUMIDATA" TO CMS_LUMI_WRITER;
0018 CREATE INDEX PIXELLUMIDATA_RUNNUM_IDX ON PIXELLUMIDATA(RUNNUM) LOCAL;
0019 /*=========================PIXELLUMIDATA_ID=======================*/
0020 CREATE TABLE "PIXELLUMIDATA_ID"
0021 (       "NEXTID" NUMBER(20,0),
0022          CONSTRAINT "PIXELLUMIDATA_ID_PK" PRIMARY KEY ("NEXTID")
0023 );
0024 INSERT INTO "PIXELLUMIDATA_ID"("NEXTID") VALUES(0);
0025 GRANT SELECT ON "PIXELLUMIDATA_ID" TO PUBLIC;
0026 GRANT SELECT,INSERT,DELETE,UPDATE ON "PIXELLUMIDATA_ID" TO CMS_LUMI_WRITER;
0027 /*=========================PIXELLUMIDATA_ENTRIES=======================*/
0028 CREATE TABLE "PIXELLUMIDATA_ENTRIES"
0029 (       "ENTRY_ID" NUMBER(20,0),
0030         "REVISION_ID" NUMBER(20,0),
0031         "NAME" VARCHAR2(56),
0032          CONSTRAINT "PIXELLUMIDATA_ENTRIES_PK" PRIMARY KEY ("ENTRY_ID")
0033 );
0034 GRANT SELECT ON "PIXELLUMIDATA_ENTRIES" TO PUBLIC;
0035 GRANT SELECT,INSERT,DELETE,UPDATE ON "PIXELLUMIDATA_ENTRIES" TO CMS_LUMI_WRITER;
0036 /*=========================PIXELLUMIDATA_ENTRIES_ID=======================*/
0037 CREATE TABLE "PIXELLUMIDATA_ENTRIES_ID"
0038 (       "NEXTID" NUMBER(20,0),
0039          CONSTRAINT "PIXELLUMIDATA_ENTRIES_ID_PK" PRIMARY KEY ("NEXTID")
0040 );
0041 INSERT INTO "PIXELLUMIDATA_ENTRIES_ID"("NEXTID") VALUES(0);
0042 GRANT SELECT ON "PIXELLUMIDATA_ENTRIES_ID" TO PUBLIC;
0043 GRANT SELECT,INSERT,DELETE,UPDATE ON "PIXELLUMIDATA_ENTRIES_ID" TO CMS_LUMI_WRITER;
0044 /*=========================PIXELLUMIDATA_REV=======================*/
0045 CREATE TABLE "PIXELLUMIDATA_REV"
0046 (       "DATA_ID" NUMBER(20,0),
0047         "REVISION_ID" NUMBER(20,0),
0048          CONSTRAINT "PIXELLUMIDATA_REV_PK" PRIMARY KEY("DATA_ID","REVISION_ID")
0049 );
0050 GRANT SELECT ON "PIXELLUMIDATA_REV" TO PUBLIC;
0051 GRANT SELECT,INSERT,DELETE,UPDATE ON "PIXELLUMIDATA_REV" TO CMS_LUMI_WRITER;
0052 /*=========================PIXELLUMISUMMARYV2=======================*/
0053 CREATE TABLE "PIXELLUMISUMMARYV2"
0054 (       "DATA_ID" NUMBER(20,0),
0055         "RUNNUM" NUMBER(10,0),
0056         "LUMILSNUM" NUMBER(10,0),
0057         "CMSLSNUM" NUMBER(10,0),
0058         "INSTLUMI" BINARY_FLOAT,
0059         "INSTLUMIERROR" BINARY_FLOAT,
0060         "INSTLUMIQUALITY" NUMBER(5,0),
0061         "BEAMSTATUS" VARCHAR2(28),
0062         "BEAMENERGY" BINARY_FLOAT,
0063         "NUMORBIT" NUMBER(10,0),
0064         "STARTORBIT" NUMBER(10,0),
0065          CONSTRAINT "PIXELLUMISUMMARYV2_PK" PRIMARY KEY ("DATA_ID", "LUMILSNUM"))
0066 PARTITION BY RANGE(RUNNUM)(
0067 PARTITION PIXELLUMISUMMARYV2_2011 VALUES LESS THAN(183338),
0068 PARTITION PIXELLUMISUMMARYV2_THEREST VALUES LESS THAN(MAXVALUE)
0069 );
0070 CREATE INDEX PIXELLUMISUMMARYV2_DATA_ID_IDX ON PIXELLUMISUMMARYV2(DATA_ID) LOCAL;
0071 GRANT SELECT ON "PIXELLUMISUMMARYV2" TO PUBLIC;
0072 GRANT SELECT,INSERT,DELETE,UPDATE ON "PIXELLUMISUMMARYV2" TO CMS_LUMI_WRITER;