LumiDB/doc/tagtables.sql

0001 /*=========================TAGRUNS=======================*/
0002 CREATE TABLE "TAGRUNS"
0003 (
0004 "TAGID" NUMBER(20,0),
0005 "RUNNUM" NUMBER(10),
0006 "LUMIDATAID" NUMBER(20,0),
0007 "TRGDATAID" NUMBER(20,0),
0008 "HLTDATAID" NUMBER(20,0),
0009 "CREATIONTIME" TIMESTAMP (6),
0010 "COMMENT" VARCHAR2(256),
0011 CONSTRAINT "TAGRUNS_PK" PRIMARY KEY ("TAGID","RUNNUM")
0012 )
0013 PARTITION BY RANGE(RUNNUM)
0014 (
0015 PARTITION YEAR2010 VALUES LESS THAN(153368),
0016 PARTITION YEAR2011 VALUES LESS THAN(183338),
0017 PARTITION THEREST VALUES LESS THAN(MAXVALUE)
0018 );
0019 GRANT SELECT ON "TAGRUNS" TO PUBLIC;
0020 GRANT SELECT,INSERT,DELETE,UPDATE ON "TAGRUNS" TO CMS_LUMI_WRITER;
0021
0022 CREATE INDEX TAGRUNS_RUNNUM_LOCAL_IDX ON TAGRUNS(RUNNUM) LOCAL;
0023
0024 /*=========================TAGS=======================*/
0025 CREATE TABLE "TAGS"
0026 (
0027 "TAGNAME" VARCHAR2(128) NOT NULL,
0028 "TAGID" NUMBER(20,0),
0029  "CREATIONTIME" TIMESTAMP (6),
0030 CONSTRAINT "TAGS_PK" PRIMARY KEY ("TAGID"),
0031 CONSTRAINT "NAME_UNIQUE" UNIQUE ("TAGNAME")
0032 );
0033 GRANT SELECT ON "TAGS" TO PUBLIC;
0034 GRANT SELECT,INSERT,DELETE,UPDATE ON "TAGS" TO CMS_LUMI_WRITER;
0035
0036 /*=========================TAGS_ID=======================*/
0037 CREATE TABLE "TAGS_ID"
0038 (
0039 "NEXTID"  NUMBER(20,0),
0040 CONSTRAINT "TAGS_ID_PK" PRIMARY KEY ("NEXTID")
0041 );
0042 INSERT INTO "TAGS_ID"("NEXTID") VALUES(0);
0043 GRANT SELECT ON "TAGS_ID" TO PUBLIC;
0044 GRANT SELECT,INSERT,DELETE,UPDATE ON "TAGS_ID" TO CMS_LUMI_WRITER;
0045
0046 /*=========================PIXELTAGRUNS=======================*/
0047 CREATE TABLE "PIXELTAGRUNS"
0048 (
0049 "TAGID" NUMBER(20,0),
0050 "RUNNUM" NUMBER(10),
0051 "LUMIDATAID" NUMBER(20,0),
0052 "TRGDATAID" NUMBER(20,0),
0053 "HLTDATAID" NUMBER(20,0),
0054 "CREATIONTIME" TIMESTAMP (6),
0055 "COMMENT" VARCHAR2(256),
0056 CONSTRAINT "PIXELTAGRUNS_PK" PRIMARY KEY ("TAGID","RUNNUM")
0057 )
0058 PARTITION BY RANGE(RUNNUM)
0059 (
0060 PARTITION YEAR2010 VALUES LESS THAN(153368),
0061 PARTITION YEAR2011 VALUES LESS THAN(183338),
0062 PARTITION THEREST VALUES LESS THAN(MAXVALUE)
0063 );
0064 GRANT SELECT ON "PIXELTAGRUNS" TO PUBLIC;
0065 GRANT SELECT,INSERT,DELETE,UPDATE ON "PIXELTAGRUNS" TO CMS_LUMI_WRITER;
0066
0067 CREATE INDEX PIXELTAGRUNS_RUNNUM_LOCAL_IDX ON PIXELTAGRUNS(RUNNUM) LOCAL;
0068
0069 /*=========================PIXELTAGS=======================*/
0070 CREATE TABLE "PIXELTAGS"
0071 (
0072 "TAGNAME" VARCHAR2(128) NOT NULL,
0073 "TAGID" NUMBER(20,0),
0074  "CREATIONTIME" TIMESTAMP (6),
0075 CONSTRAINT "PIXELTAGS_PK" PRIMARY KEY ("TAGID"),
0076 CONSTRAINT "PIXELTAG_NAME_UNIQUE" UNIQUE ("TAGNAME")
0077 );
0078 GRANT SELECT ON "PIXELTAGS" TO PUBLIC;
0079 GRANT SELECT,INSERT,DELETE,UPDATE ON "PIXELTAGS" TO CMS_LUMI_WRITER;
0080
0081 /*=========================PIXELTAGS_ID=======================*/
0082 CREATE TABLE "PIXELTAGS_ID"
0083 (
0084 "NEXTID"  NUMBER(20,0),
0085 CONSTRAINT "PIXELTAGS_ID_PK" PRIMARY KEY ("NEXTID")
0086 );
0087 INSERT INTO "PIXELTAGS_ID"("NEXTID") VALUES(0);
0088 GRANT SELECT ON "PIXELTAGS_ID" TO PUBLIC;
0089 GRANT SELECT,INSERT,DELETE,UPDATE ON "PIXELTAGS_ID" TO CMS_LUMI_WRITER;