--------------------------------------------------------
--  Datei erstellt -Freitag-Juli-08-2016   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table HYDRANTEN
--------------------------------------------------------

  CREATE TABLE "HYDRANTEN_BAAR"."HYDRANTEN" 
   (	"LIZENZ" VARCHAR2(200 BYTE), 
	"HYDRANTEN_NR" NUMBER(*,0), 
	"STANDORT" VARCHAR2(255 BYTE), 
	"AIRVALVEDESCRIPTION" VARCHAR2(200 BYTE), 
	"AIRVALVEID" NUMBER(*,0), 
	"ALTITUDE" NUMBER(10,2), 
	"BUILDINGCONNECTIONDESCRIPTION" VARCHAR2(200 BYTE), 
	"BUILDINGCONNECTIONID" NUMBER(*,0), 
	"CHANGEDATE" DATE, 
	"COLORR" VARCHAR2(100 BYTE), 
	"COLORSTATEAR" NUMBER(*,0), 
	"COLORSTATEFR" NUMBER(*,0), 
	"COLORSTATESDOT" NUMBER(*,0), 
	"COLORSTATESDUT" NUMBER(*,0), 
	"COSTACCUMMULATED" NUMBER(12,2), 
	"COSTINVESTMENT" NUMBER(12,2), 
	"COSTMAINTENANCE" NUMBER(12,2), 
	"CREATEDATE" DATE, 
	"DESIGNATION" VARCHAR2(500 BYTE), 
	"ENAMELR" VARCHAR2(10 BYTE), 
	"ENAMELSTLP" VARCHAR2(10 BYTE), 
	"ENAMELSTUP" VARCHAR2(10 BYTE), 
	"ENTITYGUID" VARCHAR2(100 BYTE), 
	"ENTITYTYPE" NUMBER(*,0), 
	"FOUNTAINMASTER" VARCHAR2(255 BYTE), 
	"FUNCTIONALSTATUSDESCRIPTION" VARCHAR2(255 BYTE), 
	"FUNCTIONALSTATUSID" NUMBER(*,0), 
	"GROUNDTYPEDESCRIPTION" VARCHAR2(255 BYTE), 
	"GROUNDTYPEID" NUMBER(*,0), 
	"HASCOLORINFO" VARCHAR2(10 BYTE), 
	"HASENAMELCOLOR" VARCHAR2(10 BYTE), 
	"HYDRANTTYPEDESCRIPTION" VARCHAR2(255 BYTE), 
	"HYDRANTTYPEID" NUMBER(*,0), 
	"HYDRANTVALVEDESCRIPTION" VARCHAR2(255 BYTE), 
	"HYDRANTVALVEID" NUMBER(*,0), 
	"INLETDIMENSION" NUMBER(*,0), 
	"INLETTYPEDESCRIPTION" VARCHAR2(255 BYTE), 
	"INLETTYPEID" NUMBER(*,0), 
	"LASTCONTROL" DATE, 
	"LASTREPAIR" DATE, 
	"LEAKCONTROLDESCRIPTION" VARCHAR2(255 BYTE), 
	"LEAKCONTROLID" NUMBER(*,0), 
	"LEVEL" NUMBER(*,0), 
	"LOWERMODELDESCRIPTION" VARCHAR2(255 BYTE), 
	"LOWERMODELID" NUMBER(*,0), 
	"LOWERMODELINSTALLDATE" DATE, 
	"LOWERMODELSHORTDESCRIPTION" VARCHAR2(2000 BYTE), 
	"MV_DIMENSION" NUMBER(*,0), 
	"MV_SEALTYPEDESCRIPTION" VARCHAR2(255 BYTE), 
	"MV_SEALTYPEID" NUMBER(*,0), 
	"MV_SHUTOFFTYPEDESCRIPTION" VARCHAR2(255 BYTE), 
	"MV_SHUTOFFTYPEID" NUMBER(*,0), 
	"OUTLET" VARCHAR2(255 BYTE), 
	"OWNER" VARCHAR2(255 BYTE), 
	"PRIORITY" VARCHAR2(50 BYTE), 
	"REMARK" VARCHAR2(2000 BYTE), 
	"REPAIRUNDERPRESSUREDESCRIPTION" VARCHAR2(255 BYTE), 
	"REPAIRUNDERPRESSUREID" NUMBER(*,0), 
	"REPAIRUNDERPRESSUERSHORTDESCRI" VARCHAR2(255 BYTE), 
	"SUBVENTIONDONOR" VARCHAR2(255 BYTE), 
	"UPPERMODELDESCRIPTION" VARCHAR2(255 BYTE), 
	"UPPERMODELID" NUMBER(*,0), 
	"UPPERMODELINSTALLDATE" DATE, 
	"UPPERMODELISREVISED" VARCHAR2(10 BYTE), 
	"UPPERMODELSHORTDESCRIPTION" VARCHAR2(255 BYTE), 
	"USERNAME" VARCHAR2(255 BYTE), 
	"XCOORDINATE" NUMBER(12,3), 
	"YCOORDINATE" NUMBER(12,3), 
	"GEOM" "MDSYS"."SDO_GEOMETRY" 
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "PROD" 
 VARRAY "GEOM"."SDO_ELEM_INFO" STORE AS SECUREFILE LOB 
  (ENABLE STORAGE IN ROW CHUNK 8192
  CACHE  NOCOMPRESS  KEEP_DUPLICATES 
  STORAGE(INITIAL 106496 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) 
 VARRAY "GEOM"."SDO_ORDINATES" STORE AS SECUREFILE LOB 
  (ENABLE STORAGE IN ROW CHUNK 8192
  CACHE  NOCOMPRESS  KEEP_DUPLICATES 
  STORAGE(INITIAL 106496 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
--------------------------------------------------------
--  DDL for Index HYDRANTEN_SG25
--------------------------------------------------------

  CREATE INDEX "HYDRANTEN_BAAR"."HYDRANTEN_SG25" ON "HYDRANTEN_BAAR"."HYDRANTEN" ("GEOM") 
   INDEXTYPE IS "MDSYS"."SPATIAL_INDEX" ;
--------------------------------------------------------
--  DDL for Index PK_HYDRANTEN_BAAR_ENTITYGUID
--------------------------------------------------------

  CREATE UNIQUE INDEX "HYDRANTEN_BAAR"."PK_HYDRANTEN_BAAR_ENTITYGUID" ON "HYDRANTEN_BAAR"."HYDRANTEN" ("ENTITYGUID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "PROD" ;
--------------------------------------------------------
--  Constraints for Table HYDRANTEN
--------------------------------------------------------

  ALTER TABLE "HYDRANTEN_BAAR"."HYDRANTEN" ADD CONSTRAINT "PK_HYDRANTEN_BAAR_ENTITYGUID" PRIMARY KEY ("ENTITYGUID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "PROD"  ENABLE;
