CREATE TABLE "SYSTEM"."FIRLEVELROAD" ("GEOMETRY" "MDSYS"."SDO_GEOMETRY",
"ENTITYID" NUMBER NOT NULL, "VERSIONNUMBER" NUMBER, "LOCKID"
NUMBER, "ADMPBLOCKNAME" VARCHAR2(255 byte), "ADMPBLOCKSCALE" "MDSYS"."SDO_GEOMETRY",
"ADMPCLOSED" CHAR(1 byte), "ADMPCOLOR" VARCHAR2(255 byte), "ADMPENTITYTYPE"
VARCHAR2(30 byte), "ADMPHYPERLINK" VARCHAR2(255 byte), "ADMPJUSTIFICATION"
NUMBER, "ADMPLAYER" VARCHAR2(255 byte), "ADMPLINETYPE"
VARCHAR2(255 byte), "ADMPLINETYPESCALE" NUMBER, "ADMPLINEWEIGHT"
NUMBER, "ADMPNORMAL" "MDSYS"."SDO_GEOMETRY", "ADMPOLYPATCOLOR"
VARCHAR2(255 byte), "ADMPOLYPATTYPE" VARCHAR2(255 byte), "ADMPPLOTSTYLE"
VARCHAR2(255 byte), "ADMPROTATION" NUMBER, "ADMPTEXTCONTENT"
VARCHAR2(512 byte), "ADMPTEXTHEIGHT" NUMBER, "ADMPTEXTSTYLE"
VARCHAR2(255 byte), "ADMPTHICKNESS" NUMBER, "ADMPWIDTH"
NUMBER, "ROADLEVEL" NUMBER(10), "ROADNAME" VARCHAR2(255
byte), "ROADWIDTH" NUMBER(10), "TYPE" NUMBER(10),
CONSTRAINT "SYS_C002913" PRIMARY KEY("ENTITYID")
USING INDEX
TABLESPACE "SYSTEM"
STORAGE ( INITIAL 12K NEXT 12K MINEXTENTS 1 MAXEXTENTS 249
PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1) PCTFREE 10
INITRANS 2 MAXTRANS 255)
TABLESPACE "SYSTEM" PCTFREE 10 PCTUSED 40 INITRANS 1
MAXTRANS 255
STORAGE ( INITIAL 12K NEXT 108K MINEXTENTS 1 MAXEXTENTS 249
PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1)
LOGGING
"ENTITYID" NUMBER NOT NULL, "VERSIONNUMBER" NUMBER, "LOCKID"
NUMBER, "ADMPBLOCKNAME" VARCHAR2(255 byte), "ADMPBLOCKSCALE" "MDSYS"."SDO_GEOMETRY",
"ADMPCLOSED" CHAR(1 byte), "ADMPCOLOR" VARCHAR2(255 byte), "ADMPENTITYTYPE"
VARCHAR2(30 byte), "ADMPHYPERLINK" VARCHAR2(255 byte), "ADMPJUSTIFICATION"
NUMBER, "ADMPLAYER" VARCHAR2(255 byte), "ADMPLINETYPE"
VARCHAR2(255 byte), "ADMPLINETYPESCALE" NUMBER, "ADMPLINEWEIGHT"
NUMBER, "ADMPNORMAL" "MDSYS"."SDO_GEOMETRY", "ADMPOLYPATCOLOR"
VARCHAR2(255 byte), "ADMPOLYPATTYPE" VARCHAR2(255 byte), "ADMPPLOTSTYLE"
VARCHAR2(255 byte), "ADMPROTATION" NUMBER, "ADMPTEXTCONTENT"
VARCHAR2(512 byte), "ADMPTEXTHEIGHT" NUMBER, "ADMPTEXTSTYLE"
VARCHAR2(255 byte), "ADMPTHICKNESS" NUMBER, "ADMPWIDTH"
NUMBER, "ROADLEVEL" NUMBER(10), "ROADNAME" VARCHAR2(255
byte), "ROADWIDTH" NUMBER(10), "TYPE" NUMBER(10),
CONSTRAINT "SYS_C002913" PRIMARY KEY("ENTITYID")
USING INDEX
TABLESPACE "SYSTEM"
STORAGE ( INITIAL 12K NEXT 12K MINEXTENTS 1 MAXEXTENTS 249
PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1) PCTFREE 10
INITRANS 2 MAXTRANS 255)
TABLESPACE "SYSTEM" PCTFREE 10 PCTUSED 40 INITRANS 1
MAXTRANS 255
STORAGE ( INITIAL 12K NEXT 108K MINEXTENTS 1 MAXEXTENTS 249
PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1)
LOGGING
GEOMETRY SDO_GEOMETRY 1 0 是
ENTITYID NUMBER 0 0 否
VERSIONNUMBER NUMBER 0 0 是
LOCKID NUMBER 0 0 是
ADMPBLOCKNAME VARCHAR2 255 0 是
ADMPBLOCKSCALE SDO_GEOMETRY 1 0 是
ADMPCLOSED CHAR 1 0 是
ADMPCOLOR VARCHAR2 255 0 是
ADMPENTITYTYPE VARCHAR2 30 0 是
ADMPHYPERLINK VARCHAR2 255 0 是
ADMPJUSTIFICATION NUMBER 0 0 是
ADMPLAYER VARCHAR2 255 0 是
ADMPLINETYPE VARCHAR2 255 0 是
ADMPLINETYPESCALE NUMBER 0 0 是
ADMPLINEWEIGHT NUMBER 0 0 是
ADMPNORMAL SDO_GEOMETRY 1 0 是
ADMPOLYPATCOLOR VARCHAR2 255 0 是
ADMPOLYPATTYPE VARCHAR2 255 0 是
ADMPPLOTSTYLE VARCHAR2 255 0 是
ADMPROTATION NUMBER 0 0 是
ADMPTEXTCONTENT VARCHAR2 512 0 是
ADMPTEXTHEIGHT NUMBER 0 0 是
ADMPTEXTSTYLE VARCHAR2 255 0 是
ADMPTHICKNESS NUMBER 0 0 是
ADMPWIDTH NUMBER 0 0 是
ROADLEVEL NUMBER 10 0 是
ROADNAME VARCHAR2 255 0 是
ROADWIDTH NUMBER 10 0 是
TYPE NUMBER 10 0 是