--------------------------------------------------------
--  Datei erstellt -Mittwoch-August-24-2022   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Sequence SEQ_AI_GWB_VALUEMARKERS
--------------------------------------------------------

   CREATE SEQUENCE  "SEQ_AI_GWB_VALUEMARKERS"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 201 CACHE 100 NOORDER  NOCYCLE  NOKEEP  NOSCALE  GLOBAL ;
--------------------------------------------------------
--  DDL for Table GPD_ABWEICHUNGEN
--------------------------------------------------------

  CREATE TABLE "GPD_ABWEICHUNGEN" 
   (	"MSID" NUMBER(10,0), 
	"RECID" NUMBER(10,0), 
	"AW_BIS" NUMBER(8,2), 
	"AW_NEIGUNG" NUMBER(8,2), 
	"AW_AZIMUT" NUMBER(8,2), 
	"AW_XW" NUMBER(8,2), 
	"AW_YW" NUMBER(8,2), 
	"AW_ZW" NUMBER(8,2), 
	"AW_DATUM" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_ASBBOHRLOCH
--------------------------------------------------------

  CREATE TABLE "GPD_ASBBOHRLOCH" 
   (	"MSID" NUMBER(10,0), 
	"RECID" NUMBER(10,0), 
	"ABL_OK" NUMBER(8,2), 
	"ABL_UK" NUMBER(8,2), 
	"ABL_DURCHMESSER" NUMBER(10,0), 
	"ABL_DURCHMZOLL" VARCHAR2(12), 
	"ABL_VERFAHREN" NUMBER(10,0), 
	"ABL_WERKZEUG" NUMBER(10,0), 
	"ABL_NOTIZ" VARCHAR2(254)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_ASBFILTER
--------------------------------------------------------

  CREATE TABLE "GPD_ASBFILTER" 
   (	"MSID" NUMBER(10,0), 
	"AFI_ROHRRECID" NUMBER(10,0), 
	"AFI_SCHLITZWEITE" NUMBER(3,2), 
	"AFI_POS" NUMBER(10,0), 
	"AFI_HYDGEOLEINHEIT" NUMBER(10,0), 
	"AFI_GWLTYP" NUMBER(10,0), 
	"AFI_HYDRAULIK" NUMBER(10,0), 
	"AFI_GWSTOCKWERK" NUMBER(10,0), 
	"AFI_BEMERKUNG" VARCHAR2(255)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_ASBSONDERBAU
--------------------------------------------------------

  CREATE TABLE "GPD_ASBSONDERBAU" 
   (	"MSID" NUMBER(10,0), 
	"RECID" NUMBER(10,0), 
	"ASE_OK" NUMBER(8,2), 
	"ASE_UK" NUMBER(8,2), 
	"ASE_TYP" NUMBER(10,0), 
	"ASE_DURCHMESSER" NUMBER(10,0), 
	"ASE_DURCHMZOLL" VARCHAR2(12), 
	"ASE_WANDSTAERKE" NUMBER(4,1), 
	"ASE_BEMERKUNG" VARCHAR2(80)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_ASBVERFUELLUNG
--------------------------------------------------------

  CREATE TABLE "GPD_ASBVERFUELLUNG" 
   (	"MSID" NUMBER(10,0), 
	"RECID" NUMBER(10,0), 
	"AVF_MATERIAL" NUMBER(10,0), 
	"AVF_OK" NUMBER(8,2), 
	"AVF_UK" NUMBER(8,2), 
	"AVF_DURCHMESSER" NUMBER(10,0), 
	"AVF_DURCHMZOLL" VARCHAR2(12), 
	"AVF_KORNGROESSEMIN" NUMBER(4,1), 
	"AVF_KORNGROESSEMAX" NUMBER(4,1), 
	"AVF_BEMERKUNG" VARCHAR2(80), 
	"AVF_TEILVERFUELLUNG" VARCHAR2(1)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_ASBVERROHRUNG
--------------------------------------------------------

  CREATE TABLE "GPD_ASBVERROHRUNG" 
   (	"MSID" NUMBER(10,0), 
	"RECID" NUMBER(10,0), 
	"ARO_TOURID" NUMBER(10,0), 
	"ARO_OK" NUMBER(8,2), 
	"ARO_UK" NUMBER(8,2), 
	"ARO_TYP" NUMBER(10,0), 
	"ARO_MATERIAL" NUMBER(10,0), 
	"ARO_DURCHMESSER" NUMBER(10,0), 
	"ARO_DURCHMZOLL" VARCHAR2(12), 
	"ARO_WANDSTAERKE" NUMBER(4,1), 
	"ARO_BEMERKUNG" VARCHAR2(80), 
	"ARO_DISPLAYPOS" NUMBER(10,0), 
	"ARO_IGNOREFILTER" VARCHAR2(1), 
	"ARO_FUERUEBERSICHT" VARCHAR2(1)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_HYDROPARAM
--------------------------------------------------------

  CREATE TABLE "GPD_HYDROPARAM" 
   (	"MSID" NUMBER(10,0), 
	"GWL" NUMBER(10,0), 
	"T_REP" NUMBER(10,2), 
	"T_SIM" NUMBER(10,2), 
	"KF_SIM" NUMBER(15,12), 
	"S_SIM" NUMBER(10,2), 
	"P_SIM" VARCHAR2(255), 
	"B_SIM" VARCHAR2(255), 
	"PV_LIT" VARCHAR2(50), 
	"T_LIT" NUMBER(10,2), 
	"KF_LIT" NUMBER(15,12), 
	"S_LIT" NUMBER(10,2), 
	"P_LIT" VARCHAR2(255), 
	"DQUELLE" VARCHAR2(255), 
	"WSP_FIS" NUMBER(10,2), 
	"DATUM_FIS" DATE, 
	"KF_FIS" NUMBER(15,12), 
	"T_FIS" NUMBER(10,2), 
	"B_FIS" VARCHAR2(255), 
	"S_FIS" NUMBER(10,2), 
	"E_FIS" NUMBER(10,2), 
	"T_LOGAN" NUMBER(10,2), 
	"E_LOGAN" NUMBER(10,2), 
	"Q_LOG" NUMBER(10,2), 
	"Q_LOG2" NUMBER(10,2), 
	"S_LOG" NUMBER(10,2), 
	"WSP_R_LOG" NUMBER(10,2), 
	"WSP_A_LOG" NUMBER(10,2), 
	"BEHARR_LOG" VARCHAR2(50), 
	"B_LOG" VARCHAR2(255)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_KLUEFTE
--------------------------------------------------------

  CREATE TABLE "GPD_KLUEFTE" 
   (	"MSID" NUMBER(10,0), 
	"RECID" NUMBER(10,0), 
	"KL_ANFANG" NUMBER(10,2), 
	"KL_ENDE" NUMBER(10,2), 
	"KL_NEIGUNG" NUMBER(10,0), 
	"KL_ART" NUMBER(10,0), 
	"KL_BEMERKUNG" VARCHAR2(255)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_LOG
--------------------------------------------------------

  CREATE TABLE "GPD_LOG" 
   (	"MSID" NUMBER(10,0), 
	"RECID" NUMBER(10,0), 
	"LG_NAME" VARCHAR2(40), 
	"LG_FIRMA" NUMBER(10,0), 
	"LG_DATUM" DATE, 
	"LG_ANFANG" NUMBER(8,2), 
	"LG_ENDE" NUMBER(8,2), 
	"LG_BEZUG" NUMBER(10,0), 
	"LG_NOTITZ" VARCHAR2(254), 
	"LG_ERGEBNIS" VARCHAR2(254), 
	"LG_METHODE" NUMBER(10,0), 
	"LG_UNIT" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_LOGDATA
--------------------------------------------------------

  CREATE TABLE "GPD_LOGDATA" 
   (	"MSID" NUMBER(10,0), 
	"LD_LOGRECID" NUMBER(10,0), 
	"LD_RECID" NUMBER(10,0), 
	"LD_DATUMZEIT" DATE, 
	"LD_DEPTH" NUMBER(8,2), 
	"LD_VALUE" NUMBER(8,2), 
	"LD_UNIT" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_MSPASSCONFIG
--------------------------------------------------------

  CREATE TABLE "GPD_MSPASSCONFIG" 
   (	"MSID" NUMBER(10,0), 
	"CONFIG" CLOB
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_MSSTAMM
--------------------------------------------------------

  CREATE TABLE "GPD_MSSTAMM" 
   (	"MSID" NUMBER(10,0), 
	"STM_LOCID" NUMBER(10,0), 
	"STM_STATUS" NUMBER(10,0), 
	"STM_VERTRAULICHKEIT" NUMBER(10,0), 
	"STM_BOHRART" NUMBER(10,0), 
	"STM_BOHRVERF" NUMBER(10,0), 
	"STM_BOHRZWECK" NUMBER(10,0), 
	"STM_KOORDFIND" NUMBER(10,0), 
	"STM_KOORDSYS" NUMBER(10,0), 
	"STM_ENDRECHTWERT" NUMBER(8,2), 
	"STM_ENDHOCHWERT" NUMBER(8,2), 
	"STM_BOHRANSATZHOEHE" NUMBER(8,2), 
	"STM_BOHRENDHOEHE" NUMBER(8,2), 
	"STM_HFIND" NUMBER(10,0), 
	"STM_HSYS" NUMBER(10,0), 
	"STM_AKTENZEICHEN" VARCHAR2(64), 
	"STM_ARCHIVFACH" NUMBER(10,0), 
	"STM_ARNUM" NUMBER(10,0), 
	"STM_TIEFBARCHIVNR" NUMBER(10,0), 
	"STM_TK5" NUMBER(10,0), 
	"STM_LAND" NUMBER(10,0), 
	"STM_BUNDESLAND" NUMBER(10,0), 
	"STM_LANDKREIS" NUMBER(10,0), 
	"STM_REGIERUNGSBEZIRK" NUMBER(10,0), 
	"STM_BEHOERDE" NUMBER(10,0), 
	"STM_AUFTRAGGEBER" NUMBER(10,0), 
	"STM_FRMBAUSTELLE" NUMBER(10,0), 
	"STM_FRMBOHRUNG" NUMBER(10,0), 
	"STM_FRMAUSBAU" NUMBER(10,0), 
	"STM_FRMKELLERAUSBAU" NUMBER(10,0), 
	"STM_BETREUENDESBUERO" NUMBER(10,0), 
	"STM_DTMBOHRBEGINN" DATE, 
	"STM_DTMBOHRENDE" DATE, 
	"STM_DTMBOHRPROT" DATE, 
	"STM_DTMDVERFASS" DATE, 
	"STM_DTMANTRAG" DATE, 
	"STM_DTMGENEHMIGUNG" DATE, 
	"STM_DTMBPLATZEINRICHTEN" DATE, 
	"STM_DTMBPLATZRAEUMEN" DATE, 
	"STM_DTMIMPORT" DATE, 
	"STM_BEARBEITERBOHR" NUMBER(10,0), 
	"STM_BEARBEITERGEOL" NUMBER(10,0), 
	"STM_BEARBEITERHYDRO" NUMBER(10,0), 
	"STM_BOHRMEISTER" NUMBER(10,0), 
	"STM_DVERFASSER" VARCHAR2(80), 
	"STM_BAULEITER" NUMBER(10,0), 
	"STM_DATHINW" VARCHAR2(48), 
	"STM_BEMERKUNGEN" VARCHAR2(254), 
	"STM_HYDAUFSCHLUSSNR" NUMBER(10,0), 
	"STM_MSART" NUMBER(10,0), 
	"STM_STRATIGRAFIELISTE" NUMBER(10,0), 
	"STM_PTFILEYN" VARCHAR2(1), 
	"STM_BOHRID" NUMBER(10,0), 
	"STM_OLDWELLID" NUMBER(10,0), 
	"STM_ISSEPIMPORT" VARCHAR2(1), 
	"STM_ISSEP" VARCHAR2(1), 
	"STM_SEPVALID" VARCHAR2(1)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_MSSYNONYME
--------------------------------------------------------

  CREATE TABLE "GPD_MSSYNONYME" 
   (	"MSID" NUMBER(10,0), 
	"MSSYN_ID" NUMBER(10,0), 
	"MSSYN_SYNID" NUMBER(10,0), 
	"MSSYN_BEZEICHNUNG" VARCHAR2(128)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_PACKERTEST
--------------------------------------------------------

  CREATE TABLE "GPD_PACKERTEST" 
   (	"MSID" NUMBER(10,0), 
	"RECID" NUMBER(10,0), 
	"PT_TESTNR" VARCHAR2(50), 
	"PT_DATUMZEIT" DATE, 
	"PT_ANALYSENANSATZ" VARCHAR2(50), 
	"PT_INTERVALLENDE" NUMBER(8,2), 
	"PT_INTERVALLANFANG" NUMBER(8,2), 
	"PT_STRECKENLAENGE" NUMBER(8,2), 
	"PT_ZONE" NUMBER(10,0), 
	"PT_BEMERKUNG" VARCHAR2(255), 
	"PT_ART_T_KF" NUMBER(10,0), 
	"PT_T" NUMBER(8,2), 
	"PT_T_ZFGOLDER" NUMBER(8,2), 
	"PT_KF" NUMBER(8,2), 
	"PT_S" NUMBER(8,2), 
	"PT_SS" NUMBER(8,2), 
	"PT_ELF" NUMBER(8,2), 
	"PT_PH" NUMBER(8,2), 
	"PT_INTERVALLMITTEGOK" NUMBER(8,2), 
	"PT_ANSATZHOEHE" NUMBER(8,2), 
	"PT_INTERVALLMITTENN" NUMBER(8,2), 
	"PT_STATISCHERGWSPIEGELGOK" NUMBER(8,2), 
	"PT_STATISCHERGWSPIEGELNN" NUMBER(8,2), 
	"PT_PRODUZIERTESVOLUMEN" NUMBER(8,2), 
	"PT_GEOLEINHVON" NUMBER(10,0), 
	"PT_GEOLEINHBIS" NUMBER(10,0), 
	"PT_GEOLEINHIMPORTERR" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_PLFIRMA
--------------------------------------------------------

  CREATE TABLE "GPD_PLFIRMA" 
   (	"PLF_ID" NUMBER(10,0), 
	"PLF_LISTID" NUMBER(10,0), 
	"PLF_NAME1" VARCHAR2(64), 
	"PLF_NAME2" VARCHAR2(64), 
	"PLF_PLZ" VARCHAR2(10), 
	"PLF_ORT" VARCHAR2(64), 
	"PLF_STRASSE" VARCHAR2(64), 
	"PLF_LAND" NUMBER(10,0), 
	"PLF_TELEFON1" VARCHAR2(64), 
	"PLF_TELEFON2" VARCHAR2(64), 
	"PLF_FAX1" VARCHAR2(64), 
	"PLF_FAX2" VARCHAR2(64), 
	"PLF_EMAIL1" VARCHAR2(64), 
	"PLF_EMAIL2" VARCHAR2(64), 
	"PLF_WWW" VARCHAR2(255), 
	"PLF_BEMERKUNG" VARCHAR2(255), 
	"PLF_TYP" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_PLPERSON
--------------------------------------------------------

  CREATE TABLE "GPD_PLPERSON" 
   (	"PLP_ID" NUMBER(10,0), 
	"PLP_LISTID" NUMBER(10,0), 
	"PLP_VORNAME" VARCHAR2(64), 
	"PLP_NACHNAME" VARCHAR2(64), 
	"PLP_NAME" VARCHAR2(132)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_PLSTANDARD
--------------------------------------------------------

  CREATE TABLE "GPD_PLSTANDARD" 
   (	"PLS_ID" NUMBER(10,0), 
	"PLS_LISTID" NUMBER(10,0), 
	"PLS_KEYSEP" VARCHAR2(12), 
	"PLS_KEY" VARCHAR2(12), 
	"PLS_NAME" VARCHAR2(255), 
	"PLS_PTTYPEINDEX" NUMBER(10,0), 
	"PLS_FLAG1" NUMBER(10,0), 
	"PLS_LAS" VARCHAR2(12), 
	"PLS_ISSEP" VARCHAR2(1)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_PLSTANDARD_TEMP
--------------------------------------------------------

  CREATE TABLE "GPD_PLSTANDARD_TEMP" 
   (	"PLS_ID" NUMBER(10,0), 
	"PLS_LISTID" NUMBER(10,0), 
	"PLS_KEYSEP" VARCHAR2(12), 
	"PLS_KEY" VARCHAR2(12), 
	"PLS_NAME" VARCHAR2(255), 
	"PLS_PTTYPEINDEX" NUMBER(10,0), 
	"PLS_FLAG1" NUMBER(10,0), 
	"PLS_LAS" VARCHAR2(12), 
	"PLS_ISSEP" VARCHAR2(1)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_SCHICHTEN
--------------------------------------------------------

  CREATE TABLE "GPD_SCHICHTEN" 
   (	"MSID" NUMBER(10,0), 
	"SD_LAYERID" NUMBER(10,0), 
	"SD_INTVERSION" NUMBER(10,0), 
	"SD_LAYERCNTR" NUMBER(10,0), 
	"SD_LAYERNO" NUMBER(10,0), 
	"SD_SUBLAYERNO" NUMBER(10,0), 
	"SD_OK" NUMBER(20,4), 
	"SD_UK" NUMBER(20,4), 
	"SD_ART" VARCHAR2(128), 
	"SD_ARTKLAR" CLOB, 
	"SD_STRATIGRAFIE" VARCHAR2(254), 
	"SD_STRATIGRAFIEKRZ" VARCHAR2(64), 
	"SD_STRATIGRAFIEID" NUMBER(10,0), 
	"SD_PETROGRAFIE" VARCHAR2(254), 
	"SD_PETROKLAR" VARCHAR2(255), 
	"SD_GENESE" VARCHAR2(254), 
	"SD_GENESEKLAR" CLOB, 
	"SD_FARBE" VARCHAR2(254), 
	"SD_FARBEKLAR" CLOB, 
	"SD_ZUSATZ" VARCHAR2(254), 
	"SD_ZUSATZKLAR" CLOB, 
	"SD_BEMERKUNG" VARCHAR2(128), 
	"SD_BESCHAFFENHEITBOHRGUT" VARCHAR2(128), 
	"SD_BESCHBGKLAR" CLOB, 
	"SD_BOHRVORGANG" VARCHAR2(128), 
	"SD_BOHRVORGANGKLAR" CLOB, 
	"SD_BODENGRUPPE" VARCHAR2(128), 
	"SD_BODENGRUPPEKLAR" CLOB, 
	"SD_KALKGEHALT" VARCHAR2(128), 
	"SD_KALKGEHALTKLAR" CLOB, 
	"SD_INTGRUPPE" VARCHAR2(12), 
	"SD_INTKLASSE" VARCHAR2(12), 
	"SD_INTNOTITZ" CLOB, 
	"SD_TEXTUR" NUMBER(10,0), 
	"SD_KRISTALLINITAET" NUMBER(10,0), 
	"SD_TRENNFLAECHENFUELLUNG" NUMBER(10,0), 
	"SD_STREICHENFALLEN" VARCHAR2(64), 
	"SD_ERGBEMERKUNG" VARCHAR2(255), 
	"SD_UEBLICHEBEZ" VARCHAR2(64), 
	"SD_GEOLBEZ" VARCHAR2(64), 
	"SD_BODENKLASSE" NUMBER(10,0), 
	"SD_VERWITTERUNG" NUMBER(10,0), 
	"SD_WETZONES" VARCHAR2(64), 
	"SD_FRACTURES" VARCHAR2(64), 
	"SD_SEPERROR" NUMBER(10,0), 
	"SD_SEPPETRO" VARCHAR2(254), 
	"SD_SEPFARBE" VARCHAR2(254), 
	"SD_SEPBESCHBG" VARCHAR2(128), 
	"SD_SEPBESCHBV" VARCHAR2(128), 
	"SD_SEPKALKGEH" VARCHAR2(128)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_SCHICHTTITEL
--------------------------------------------------------

  CREATE TABLE "GPD_SCHICHTTITEL" 
   (	"MSID" NUMBER(10,0), 
	"RECID" NUMBER(10,0), 
	"ST_INTVERSION" NUMBER(10,0), 
	"ST_INTPROJLEITER" NUMBER(10,0), 
	"ST_INTBEARBEITER" NUMBER(10,0), 
	"ST_DTMINTBEARBEITUNG" DATE, 
	"ST_DTMINTAENDERUNG" DATE, 
	"ST_UEBERNAHMEKENNUNG" VARCHAR2(50), 
	"ST_OPFELDBEARBEITER" VARCHAR2(64), 
	"ST_AUSW" VARCHAR2(24), 
	"ST_INTGRUPPE" VARCHAR2(12), 
	"ST_INTBASISVERSION" NUMBER(10,0), 
	"ST_INTNEU" NUMBER(10,0), 
	"ST_INTBEMERKUNG" VARCHAR2(254)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_SPUELUNG
--------------------------------------------------------

  CREATE TABLE "GPD_SPUELUNG" 
   (	"MSID" NUMBER(10,0), 
	"RECID" NUMBER(10,0), 
	"SP_ANFANG" NUMBER(8,2), 
	"SP_ENDE" NUMBER(8,2), 
	"SP_ART" NUMBER(10,0), 
	"SP_ZUSATZ" NUMBER(10,0), 
	"SP_DICHTE" NUMBER(8,2), 
	"SP_DICHTEEINH" NUMBER(10,0), 
	"SP_VERHALTEN" VARCHAR2(255), 
	"SP_MENGE" NUMBER(8,2)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_STRATIGRAPHIE
--------------------------------------------------------

  CREATE TABLE "GPD_STRATIGRAPHIE" 
   (	"STRT_ID" NUMBER(10,0), 
	"STRT_PARENTID" NUMBER(10,0), 
	"STRT_HIERARCHIESTUFE" NUMBER(10,0), 
	"STRT_LISTID" NUMBER(10,0), 
	"STRT_ORDER" NUMBER(10,0), 
	"STRT_KUERZEL" VARCHAR2(24), 
	"STRT_KUERZELOFFIZIELL" VARCHAR2(24), 
	"STRT_BEZEICHNUNG" VARCHAR2(128), 
	"STRT_BEMERKUNG" VARCHAR2(255), 
	"STRT_LITHOLOGIEID" NUMBER(10,0), 
	"STRT_FARBE" NUMBER(10,0), 
	"STRT_IMPORTSYNONYME" VARCHAR2(255), 
	"STRT_BEREICHDEFJN" VARCHAR2(1), 
	"STRT_BEREICHVON" NUMBER(10,0), 
	"STRT_BEREICHBIS" NUMBER(10,0), 
	"STRT_SEPZS" VARCHAR2(32), 
	"STRT_ISSEP" VARCHAR2(1)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_STRATLISTS
--------------------------------------------------------

  CREATE TABLE "GPD_STRATLISTS" 
   (	"SLST_ID" NUMBER(10,0), 
	"SLST_HIERARCHIEBASIS" NUMBER(10,0), 
	"SLST_BEZEICHNUNG" VARCHAR2(255), 
	"SLST_PROFILTECFILE" VARCHAR2(255), 
	"SLST_BEMERKUNG" VARCHAR2(255)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_SYNONYMKAT
--------------------------------------------------------

  CREATE TABLE "GPD_SYNONYMKAT" 
   (	"ID" NUMBER(10,0), 
	"SYN_SORTIERUNG" NUMBER(10,0), 
	"SYN_NAME" VARCHAR2(50), 
	"GWW" NCHAR(1) DEFAULT '-', 
	"GWWTRANSFERDATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_TEMPAUSBAU
--------------------------------------------------------

  CREATE TABLE "GPD_TEMPAUSBAU" 
   (	"MSID" NUMBER(10,0), 
	"RECID" NUMBER(10,0), 
	"TARO_OK" NUMBER(8,2), 
	"TARO_UK" NUMBER(8,2), 
	"TARO_TYP" NUMBER(10,0), 
	"TARO_MATERIAL" NUMBER(10,0), 
	"TARO_DURCHMESSER" NUMBER(4,2), 
	"TARO_WANDSTAERKE" NUMBER(4,1), 
	"TARO_BEMERKUNG" VARCHAR2(254)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_TEMPSCHICHTEN
--------------------------------------------------------

  CREATE TABLE "GPD_TEMPSCHICHTEN" 
   (	"MSID" NUMBER(10,0), 
	"RECID" NUMBER(10,0), 
	"TSD_UK" NUMBER(20,4), 
	"TSD_ART" VARCHAR2(128), 
	"TSD_STRATIGRAFIE" VARCHAR2(254), 
	"TSD_PETROGRAFIE" VARCHAR2(254), 
	"TSD_BEMERKUNG" VARCHAR2(254)
   ) ;
--------------------------------------------------------
--  DDL for Table GPD_WASSERRECHT
--------------------------------------------------------

  CREATE TABLE "GPD_WASSERRECHT" 
   (	"MSID" NUMBER(10,0), 
	"TYP" VARCHAR2(50), 
	"NR" NUMBER(10,0), 
	"NAME" VARCHAR2(50), 
	"WR1" VARCHAR2(255), 
	"WR2" VARCHAR2(255), 
	"WR3" VARCHAR2(255), 
	"NUTZER" VARCHAR2(50), 
	"QMAX_A" NUMBER(10,2), 
	"QMAX" NUMBER(10,2), 
	"QMAX_H" NUMBER(10,2), 
	"QMAX_S" NUMBER(10,2), 
	"QMIT" NUMBER(10,2), 
	"QMIT_H" NUMBER(10,2), 
	"BEMERKUNG" CLOB, 
	"DATENQUELLE" VARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_ANALYMETHODS
--------------------------------------------------------

  CREATE TABLE "GWB_ANALYMETHODS" 
   (	"ID" NUMBER(10,0), 
	"METHODNAME" NVARCHAR2(100), 
	"ISOLD" NVARCHAR2(1)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_ANALYSEN
--------------------------------------------------------

  CREATE TABLE "GWB_ANALYSEN" 
   (	"DATUMID" NUMBER(10,0), 
	"PARAMETERID" NUMBER(10,0), 
	"MESSWERT" NUMBER(12,5), 
	"EINHEIT" VARCHAR2(10), 
	"ZUSATZ" CHAR(1) DEFAULT '0', 
	"LOCKED" CHAR(1), 
	"METHOD_ID" NUMBER(10,0), 
	"VALUESTDUNIT" NUMBER(12,5), 
	"STDUNIT" VARCHAR2(10), 
	"ISCALCULATED" NVARCHAR2(1) DEFAULT 'N', 
	"DATATYPE" NUMBER(10,0) DEFAULT 0
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_BERICHTE
--------------------------------------------------------

  CREATE TABLE "GWB_BERICHTE" 
   (	"BERICHTSNR" NUMBER(10,0), 
	"TITEL1" VARCHAR2(50), 
	"TITEL2" VARCHAR2(50), 
	"TITEL3" VARCHAR2(50), 
	"TITEL4" VARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_BETREIB
--------------------------------------------------------

  CREATE TABLE "GWB_BETREIB" 
   (	"BETREIBER" VARCHAR2(50), 
	"KEYNR" VARCHAR2(10)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_BOHRFIRM
--------------------------------------------------------

  CREATE TABLE "GWB_BOHRFIRM" 
   (	"BOHRFIRMA" VARCHAR2(50), 
	"ADRESSE1" VARCHAR2(50), 
	"ADRESSE2" VARCHAR2(50), 
	"BEMERKUNGEN" VARCHAR2(250), 
	"KEYNR" VARCHAR2(10)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_BOHRVERF
--------------------------------------------------------

  CREATE TABLE "GWB_BOHRVERF" 
   (	"BOHRVERFAHREN" VARCHAR2(50), 
	"BEMERKUNGEN" VARCHAR2(250), 
	"KEYNR" VARCHAR2(10)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_BUILDINGMATERIALCAT
--------------------------------------------------------

  CREATE TABLE "GWB_BUILDINGMATERIALCAT" 
   (	"ID" NUMBER(10,0), 
	"ITEMNAME" NVARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_CATCHMENTAREAS
--------------------------------------------------------

  CREATE TABLE "GWB_CATCHMENTAREAS" 
   (	"ID" NUMBER(10,0), 
	"AREANAME" NVARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_CHANGELOGGER
--------------------------------------------------------

  CREATE TABLE "GWB_CHANGELOGGER" 
   (	"ID" NUMBER(10,0), 
	"MODIFIEDBY" NVARCHAR2(20), 
	"MODIFIEDDATE" DATE, 
	"MODIFIEDFIELDS" NCLOB, 
	"COMMANDTYPE" NVARCHAR2(1), 
	"TABLENAME" NVARCHAR2(50), 
	"TABLEDISPLAYNAME" NVARCHAR2(50), 
	"IDENTIFIERTEXT" NVARCHAR2(50), 
	"IDENTIFIERID" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_CHECKRULES
--------------------------------------------------------

  CREATE TABLE "GWB_CHECKRULES" 
   (	"CR_WELLID" NUMBER(10,0), 
	"CR_PARAMID" NUMBER(10,0), 
	"CR_RULETYPE" NUMBER(4,0), 
	"CR_CHECKVALUE" NUMBER(10,3), 
	"CR_VALIDFROM" DATE, 
	"CR_VALIDUNTIL" DATE, 
	"CR_VALUETYPE" CHAR(1) DEFAULT 'A', 
	"CR_VALUEDESCR" VARCHAR2(50), 
	"CR_ACTIVE" CHAR(1) DEFAULT 'Y', 
	"ID" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_CHECKRULES_TEMPLATES
--------------------------------------------------------

  CREATE TABLE "GWB_CHECKRULES_TEMPLATES" 
   (	"CR_TEMPLATENAME" VARCHAR2(100), 
	"CR_PARAMID" NUMBER(10,0), 
	"CR_RULETYPE" NUMBER(4,0), 
	"CR_CHECKVALUE" NUMBER(10,3), 
	"CR_VALIDFROM" DATE, 
	"CR_VALIDUNTIL" DATE, 
	"CR_VALUETYPE" CHAR(1) DEFAULT 'A', 
	"CR_VALUEDESCR" VARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_CHECKRULES2
--------------------------------------------------------

  CREATE TABLE "GWB_CHECKRULES2" 
   (	"CR_ID" NUMBER(10,0), 
	"CR_WELLID" NUMBER(10,0), 
	"CR_PARAMID" NUMBER(10,0), 
	"CR_RULETYPE" NUMBER(4,0), 
	"CR_CHECKVALUE" NUMBER(10,3), 
	"CR_VALUEDESCR" VARCHAR2(255), 
	"CR_ACTIVE" CHAR(1) DEFAULT 'Y', 
	"CR_SAMPLES" NUMBER(4,0), 
	"CR_CRITICALSAMPLES" NUMBER(4,0), 
	"CR_LOOKAHEADRANGE" NUMBER(4,0), 
	"CR_LOOKAHEADUNIT" CHAR(1), 
	"CR_LOOKBEHINDRANGE" NUMBER(4,0), 
	"CR_LOOKBEHINDUNIT" CHAR(1)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_CLASS_PARAM
--------------------------------------------------------

  CREATE TABLE "GWB_CLASS_PARAM" 
   (	"PARAM_ID" NUMBER(10,0), 
	"CLASS_ID" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_DISCHARGESTATISTIC
--------------------------------------------------------

  CREATE TABLE "GWB_DISCHARGESTATISTIC" 
   (	"WELL_ID" NUMBER(10,0), 
	"STATYEAR" NUMBER(10,0), 
	"QSUM_1" NUMBER(12,3), 
	"QSUM_2" NUMBER(12,3), 
	"QSUM_3" NUMBER(12,3), 
	"QSUM_4" NUMBER(12,3), 
	"QSUM_5" NUMBER(12,3), 
	"QSUM_6" NUMBER(12,3), 
	"QSUM_7" NUMBER(12,3), 
	"QSUM_8" NUMBER(12,3), 
	"QSUM_9" NUMBER(12,3), 
	"QSUM_10" NUMBER(12,3), 
	"QSUM_11" NUMBER(12,3), 
	"QSUM_12" NUMBER(12,3), 
	"QSUM_TOTAL" NUMBER(14,3), 
	"QDAILYMAX_1" NUMBER(12,3), 
	"QDATEDAILYMAX_1" DATE, 
	"QDAILYMAX_2" NUMBER(12,3), 
	"QDATEDAILYMAX_2" DATE, 
	"QDAILYMAX_3" NUMBER(12,3), 
	"QDATEDAILYMAX_3" DATE, 
	"QDAILYMAX_4" NUMBER(12,3), 
	"QDATEDAILYMAX_4" DATE, 
	"QDAILYMAX_5" NUMBER(12,3), 
	"QDATEDAILYMAX_5" DATE, 
	"QDAILYMAX_6" NUMBER(12,3), 
	"QDATEDAILYMAX_6" DATE, 
	"QDAILYMAX_7" NUMBER(12,3), 
	"QDATEDAILYMAX_7" DATE, 
	"QDAILYMAX_8" NUMBER(12,3), 
	"QDATEDAILYMAX_8" DATE, 
	"QDAILYMAX_9" NUMBER(12,3), 
	"QDATEDAILYMAX_9" DATE, 
	"QDAILYMAX_10" NUMBER(12,3), 
	"QDATEDAILYMAX_10" DATE, 
	"QDAILYMAX_11" NUMBER(12,3), 
	"QDATEDAILYMAX_11" DATE, 
	"QDAILYMAX_12" NUMBER(12,3), 
	"QDATEDAILYMAX_12" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_DOCCATEGORIES
--------------------------------------------------------

  CREATE TABLE "GWB_DOCCATEGORIES" 
   (	"ID" NUMBER(10,0), 
	"CATEGORY" NVARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_DOCTYPES
--------------------------------------------------------

  CREATE TABLE "GWB_DOCTYPES" 
   (	"ID" NUMBER(10,0), 
	"DOCTYPE" NVARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_EINHEIT
--------------------------------------------------------

  CREATE TABLE "GWB_EINHEIT" 
   (	"EINHEIT" VARCHAR2(10), 
	"KEYNR" VARCHAR2(10), 
	"UNIT_TYPE" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_ELEVATIONQUALITY
--------------------------------------------------------

  CREATE TABLE "GWB_ELEVATIONQUALITY" 
   (	"ID" NUMBER(10,0), 
	"QUALITYTEXT" NVARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_FIELDCHECKS
--------------------------------------------------------

  CREATE TABLE "GWB_FIELDCHECKS" 
   (	"TNAME" NVARCHAR2(100), 
	"FNAME" NVARCHAR2(100), 
	"FNAMEDISPLAY" NVARCHAR2(100), 
	"OPTIONS" NUMBER(10,0), 
	"VALUEMIN" NUMBER(12,4), 
	"VALUEMAX" NUMBER(12,4), 
	"FCONDITION" NVARCHAR2(100)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_FLOWMEASUREMENTCAT
--------------------------------------------------------

  CREATE TABLE "GWB_FLOWMEASUREMENTCAT" 
   (	"ID" NUMBER(10,0), 
	"ITEMNAME" NVARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_GEOLOGIE
--------------------------------------------------------

  CREATE TABLE "GWB_GEOLOGIE" 
   (	"ID" NUMBER(10,0), 
	"GEOLOGISCHEEINHEIT" VARCHAR2(50), 
	"SEQNR" NUMBER(10,0), 
	"KEYNR" VARCHAR2(10)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_GERAETE
--------------------------------------------------------

  CREATE TABLE "GWB_GERAETE" 
   (	"PROBENNAHMEGERAET" VARCHAR2(50), 
	"KEYNR" VARCHAR2(10)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_GRAPHICS
--------------------------------------------------------

  CREATE TABLE "GWB_GRAPHICS" 
   (	"ID" NUMBER(10,0), 
	"WELL_ID" NUMBER(10,0), 
	"GRAPHICFILE" VARCHAR2(255), 
	"FILEDESCRIPTION" VARCHAR2(255), 
	"FILETYPE" VARCHAR2(10), 
	"SORTNO" NUMBER(10,0), 
	"CREATOR_ID" NUMBER(10,0), 
	"USER_ID" NUMBER(10,0), 
	"PROJECT_ID" NUMBER(10,0), 
	"DOCTYPE_ID" NUMBER(10,0), 
	"CATEGORY_ID" NUMBER(10,0), 
	"FILEORDIR" NVARCHAR2(1) DEFAULT 'F', 
	"GWW" NCHAR(1) DEFAULT '-', 
	"GWWFILEDATE" DATE, 
	"DISPLAYNAME" NVARCHAR2(64)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_GRENZEN
--------------------------------------------------------

  CREATE TABLE "GWB_GRENZEN" 
   (	"XMIN" NUMBER(12,4), 
	"XMAX" NUMBER(12,4), 
	"YMIN" NUMBER(12,4), 
	"YMAX" NUMBER(12,4)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_GWSTOCKW
--------------------------------------------------------

  CREATE TABLE "GWB_GWSTOCKW" 
   (	"ID" NUMBER(10,0), 
	"GRUNDWASSERSTOCKWERK" VARCHAR2(50), 
	"SEQNR" NUMBER(10,0), 
	"KEYNR" VARCHAR2(10)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_HCHANGE
--------------------------------------------------------

  CREATE TABLE "GWB_HCHANGE" 
   (	"MESSTELLENID" NUMBER(10,0), 
	"DATUMAENDERUNG" DATE, 
	"NEUEHOEHEMP" NUMBER(7,3), 
	"NEUEHOEHEOKG" NUMBER(7,3), 
	"QUALITY_ID" NUMBER(10,0), 
	"COMMENT" NVARCHAR2(100), 
	"FILTERBTM" NUMBER(8,2)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_IMPORTS
--------------------------------------------------------

  CREATE TABLE "GWB_IMPORTS" 
   (	"ID" NUMBER(10,0), 
	"IMPORTDATE" DATE, 
	"IMPORTEDBY" VARCHAR2(30), 
	"FILEORDIR" VARCHAR2(255), 
	"NOOFFILES" NUMBER(10,0), 
	"IMPORTFORMAT" VARCHAR2(100)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_INOUTLETSTRUCTURE
--------------------------------------------------------

  CREATE TABLE "GWB_INOUTLETSTRUCTURE" 
   (	"OBJECT_ID" NUMBER(10,0), 
	"LENGTH" NUMBER(10,2), 
	"WIDTH" NUMBER(10,2), 
	"HEIGHT" NUMBER(10,2), 
	"GAUGEWIDTH" NUMBER(10,2), 
	"FILTERAREASIZE" NUMBER(10,2), 
	"COMMENTTEXT" NCLOB
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_IONRATIOS
--------------------------------------------------------

  CREATE TABLE "GWB_IONRATIOS" 
   (	"DATE_ID" NUMBER(10,0), 
	"MG_CA" NUMBER(10,4), 
	"NA_MG" NUMBER(10,4), 
	"NAK_CL" NUMBER(10,4), 
	"CL_SO4" NUMBER(10,4), 
	"CL_NA" NUMBER(10,4), 
	"CAMG_NAK" NUMBER(10,4), 
	"NA_K" NUMBER(10,4), 
	"CL_BR" NUMBER(10,4), 
	"HCO3_CLSO4" NUMBER(10,4), 
	"K_CA" NUMBER(10,4), 
	"DONE" NVARCHAR2(1) DEFAULT 'N'
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_KEYWORD_OBJECTS
--------------------------------------------------------

  CREATE TABLE "GWB_KEYWORD_OBJECTS" 
   (	"KEYWORD_ID" NUMBER(10,0), 
	"OBJECT_ID" NUMBER(10,0), 
	"OBJECT_TYPE" NVARCHAR2(1)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_KEYWORDS
--------------------------------------------------------

  CREATE TABLE "GWB_KEYWORDS" 
   (	"ID" NUMBER(10,0), 
	"KEYWORD" NVARCHAR2(50), 
	"CATEGORY_ID" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_LABELS
--------------------------------------------------------

  CREATE TABLE "GWB_LABELS" 
   (	"LABEL_WELLNR1" VARCHAR2(50), 
	"LABEL_WELLNR2" VARCHAR2(50), 
	"LABEL_WELLNAME" VARCHAR2(50), 
	"LABEL_MAP" VARCHAR2(50), 
	"LABEL_WELLTYPE" VARCHAR2(50), 
	"LABEL_WELLUSAGE" VARCHAR2(50), 
	"LABEL_WELLCITY" VARCHAR2(50), 
	"LABEL_WELLDISTRICT" VARCHAR2(50), 
	"LABEL_WELLSUBDISTR" VARCHAR2(50), 
	"LABEL_WELLSUBDISTRNO" VARCHAR2(50), 
	"LABEL_POSITION" VARCHAR2(50), 
	"LABEL_OWNER" VARCHAR2(50), 
	"LABEL_OPERATEDBY" VARCHAR2(50), 
	"LABEL_XCOORD" VARCHAR2(50), 
	"LABEL_YCOORD" VARCHAR2(50), 
	"LABEL_USERFIELD1" VARCHAR2(50), 
	"LABEL_USERFIELD2" VARCHAR2(50), 
	"LABEL_USERFIELD3" VARCHAR2(50), 
	"LABEL_USERFIELD4" VARCHAR2(50), 
	"LABEL_USERFIELD5" VARCHAR2(50), 
	"LABEL_PROJREFNO1" NVARCHAR2(50), 
	"LABEL_PROJREFNO2" NVARCHAR2(50), 
	"LABEL_PROJREFNO3" NVARCHAR2(50), 
	"LABEL_PROJREFNO4" NVARCHAR2(50), 
	"LABEL_PROJREFNO5" NVARCHAR2(50), 
	"LABEL_PROJLOGIC1" NVARCHAR2(50), 
	"LABEL_PROJLOGIC2" NVARCHAR2(50), 
	"LABEL_PROJLOGIC3" NVARCHAR2(50), 
	"LABEL_PROJLOGIC4" NVARCHAR2(50), 
	"LABEL_PROJLOGIC5" NVARCHAR2(50), 
	"LABEL_PROJTEXT1" NVARCHAR2(50), 
	"LABEL_PROJTEXT2" NVARCHAR2(50), 
	"LABEL_PROJTEXT3" NVARCHAR2(50), 
	"LABEL_PROJTEXT4" NVARCHAR2(50), 
	"LABEL_PROJTEXT5" NVARCHAR2(50), 
	"LABEL_SURFACEWATER" NVARCHAR2(50), 
	"LABEL_SURFACEWATERPART" NVARCHAR2(50), 
	"LABEL_SURFACEWATERKM" NVARCHAR2(50), 
	"LABEL_SAP_KEY" NVARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_LABORS
--------------------------------------------------------

  CREATE TABLE "GWB_LABORS" 
   (	"ID" NUMBER(10,0), 
	"LABOR" NVARCHAR2(100), 
	"ADRESSE1" VARCHAR2(50), 
	"ADRESSE2" VARCHAR2(50), 
	"BEMERKUNGEN" VARCHAR2(250), 
	"KEYNR" VARCHAR2(10), 
	"RELATIONFILE" VARCHAR2(255)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_LEVEL_ATTRIBUTES
--------------------------------------------------------

  CREATE TABLE "GWB_LEVEL_ATTRIBUTES" 
   (	"LA_DATE_ID" NUMBER(10,0), 
	"LA_ATTRIBUTE_ID" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_LEVELCOMMENTS
--------------------------------------------------------

  CREATE TABLE "GWB_LEVELCOMMENTS" 
   (	"COMMENTID" NUMBER(10,0), 
	"COMMENTTEXT" VARCHAR2(50), 
	"KEYNR" VARCHAR2(10), 
	"QUALITY" CHAR(1) DEFAULT '+', 
	"TODOCATEGORY_ID" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_LEVELSTATISTIC
--------------------------------------------------------

  CREATE TABLE "GWB_LEVELSTATISTIC" 
   (	"WELL_ID" NUMBER(10,0), 
	"STATYEAR" NUMBER(10,0), 
	"MAXLEVEL_SL" NUMBER(8,2), 
	"MINLEVEL_SL" NUMBER(8,2), 
	"AVLEVEL_SL" NUMBER(8,2)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_LOGINS
--------------------------------------------------------

  CREATE TABLE "GWB_LOGINS" 
   (	"USER_ID" NUMBER(10,0), 
	"LOGINTIME" DATE, 
	"LOGOFFTIME" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_MANHOLE
--------------------------------------------------------

  CREATE TABLE "GWB_MANHOLE" 
   (	"OBJECT_ID" NUMBER(10,0), 
	"GEOMETRYTYPE" NVARCHAR2(1), 
	"LENGTH" NUMBER(10,2), 
	"WIDTH" NUMBER(10,2), 
	"HEIGHT" NUMBER(10,2), 
	"MATERIAL_ID" NUMBER(10,0), 
	"ACCESSGEOMETRYTYPE" NVARCHAR2(1), 
	"ACCESSLENGTH" NUMBER(10,2), 
	"ACCESSWIDTH" NUMBER(10,2), 
	"ELECTRIFICATION" NVARCHAR2(1), 
	"REMOTECONTROL" NVARCHAR2(1), 
	"COMMENTTEXT" NCLOB, 
	"TOTALHEIGHT" NUMBER(10,2)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_MAPS
--------------------------------------------------------

  CREATE TABLE "GWB_MAPS" 
   (	"ID" NUMBER(10,0), 
	"MAPFILE" VARCHAR2(255), 
	"MAPCOMMENT" VARCHAR2(50), 
	"XMINMAP" NUMBER(12,4), 
	"XMAXMAP" NUMBER(12,4), 
	"YMINMAP" NUMBER(12,4), 
	"YMAXMAP" NUMBER(12,4), 
	"CONTOURMAP" CHAR(1) DEFAULT 'N', 
	"SELECTMAP" CHAR(1) DEFAULT 'N', 
	"DIGITIZEMAP" CHAR(1) DEFAULT 'N', 
	"BLANKAREA" CHAR(1) DEFAULT 'N', 
	"BLITMODE" CHAR(1) DEFAULT 'D', 
	"PIXELSX" NUMBER(10,0), 
	"PIXELSY" NUMBER(10,0), 
	"RESOLUTION" NUMBER(10,0), 
	"PROJECT_ID" NUMBER(10,0), 
	"LINECOLOR" NUMBER(10,0), 
	"LINEWIDTH" NUMBER(10,0), 
	"ALLWAYSUSE" CHAR(1), 
	"UTM_EAST_MINMAP" NUMBER(12,4), 
	"UTM_NORTH_MINMAP" NUMBER(12,4), 
	"UTM_EAST_MAXMAP" NUMBER(12,4), 
	"UTM_NORTH_MAXMAP" NUMBER(12,4), 
	"LAYERINFO" CLOB, 
	"MAPUSEOPTION" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_MAPS_PROJECTS
--------------------------------------------------------

  CREATE TABLE "GWB_MAPS_PROJECTS" 
   (	"MAP_ID" NUMBER(10,0), 
	"PROJECT_ID" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_MEASDATE
--------------------------------------------------------

  CREATE TABLE "GWB_MEASDATE" 
   (	"ID" NUMBER(10,0), 
	"LOGGER" CHAR(1) DEFAULT '0', 
	"MESSTELLENID" NUMBER(10,0), 
	"MESSDATUM" DATE, 
	"PROGID" NUMBER(10,0), 
	"DEPTH" NUMBER(7,3), 
	"INFO" CHAR(2), 
	"IMPORT_ID" NUMBER(10,0), 
	"MARKER" NVARCHAR2(1) DEFAULT '+', 
	"DEPTHRANGE" NUMBER(10,0) DEFAULT 0
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_MEMOS
--------------------------------------------------------

  CREATE TABLE "GWB_MEMOS" 
   (	"WELL_ID" NUMBER(10,0), 
	"MEMOTYPE" NUMBER(10,0), 
	"DATE_ID" NUMBER(10,0), 
	"COMMENTTEXT" CLOB
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_MISCSTRUCTURE
--------------------------------------------------------

  CREATE TABLE "GWB_MISCSTRUCTURE" 
   (	"OBJECT_ID" NUMBER(10,0), 
	"COMMENTTEXT" NCLOB
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_MSART
--------------------------------------------------------

  CREATE TABLE "GWB_MSART" 
   (	"MSART" VARCHAR2(50), 
	"KEYNR" VARCHAR2(10)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_MSSTAMM
--------------------------------------------------------

  CREATE TABLE "GWB_MSSTAMM" 
   (	"ID" NUMBER(10,0), 
	"KENNNR" VARCHAR2(30), 
	"KENNNR2" VARCHAR2(30), 
	"BEZEICHNUNG" VARCHAR2(50), 
	"RECHTSWERT" NUMBER(12,4), 
	"HOCHWERT" NUMBER(12,4), 
	"XLABEL" NUMBER(12,4), 
	"YLABEL" NUMBER(12,4), 
	"HOEHEMP" NUMBER(7,3), 
	"HOEHEOKG" NUMBER(7,3), 
	"TK25" VARCHAR2(20), 
	"BETREIBER" VARCHAR2(50), 
	"ORT" VARCHAR2(50), 
	"GEMARKUNG" VARCHAR2(50), 
	"FLUR" VARCHAR2(20), 
	"FLURSTUECK" VARCHAR2(20), 
	"GRUNDEIGNER" VARCHAR2(50), 
	"LAGE" VARCHAR2(100), 
	"BAUJAHR" CHAR(4), 
	"BESEITIGT" CHAR(4), 
	"NACHFOLGER" VARCHAR2(20), 
	"VORGAENGER" VARCHAR2(20), 
	"ART" VARCHAR2(50), 
	"NUTZUNG" VARCHAR2(50), 
	"KAT1" CHAR(1) DEFAULT 'N', 
	"KAT2" CHAR(1) DEFAULT 'N', 
	"KAT3" CHAR(1) DEFAULT 'N', 
	"KAT4" CHAR(1) DEFAULT 'N', 
	"KAT5" CHAR(1) DEFAULT 'N', 
	"KAT6" CHAR(1) DEFAULT 'N', 
	"KAT7" CHAR(1) DEFAULT 'N', 
	"KAT8" CHAR(1) DEFAULT 'N', 
	"KAT9" CHAR(1) DEFAULT 'N', 
	"KAT10" CHAR(1) DEFAULT 'N', 
	"LAGEPLANDATEI" VARCHAR2(200), 
	"BILDDATEI" VARCHAR2(200), 
	"BOHRFIRMA" VARCHAR2(50), 
	"BOHRDURCHMESSER" VARCHAR2(50), 
	"BOHRVERFAHREN" VARCHAR2(50), 
	"BOHRTIEFE" VARCHAR2(10), 
	"AUSBAUMATERIAL" VARCHAR2(20), 
	"AUSBAUDURCHM" VARCHAR2(50), 
	"AUSBAUTIEFE" VARCHAR2(10), 
	"FILTERSTRECKEN" VARCHAR2(50), 
	"FILTERTOP" NUMBER(8,2), 
	"FILTERBOTTOM" NUMBER(8,2), 
	"SCHLITZWEITE" VARCHAR2(10), 
	"FILTERKIES" VARCHAR2(20), 
	"TONSPERREN" VARCHAR2(50), 
	"AUSBAUDATEI" VARCHAR2(200), 
	"GEOLOGY_ID" NUMBER(10,0), 
	"GESTEINSART" VARCHAR2(50), 
	"KWERT" VARCHAR2(10), 
	"AQUIFER_ID" NUMBER(10,0), 
	"AQUIFERTOP" NUMBER(7,1), 
	"AQUIFERBASE" NUMBER(7,1), 
	"GWGESPANNT" CHAR(1) DEFAULT 'N', 
	"SCHICHTENDATEI" VARCHAR2(200), 
	"MESSINTERVALLWS" NUMBER(10,0), 
	"LETZTEMESSUNG" DATE, 
	"BEPROBINTERVALL" NUMBER(10,0), 
	"LETZTEBEPROBUNG" DATE, 
	"WPLAN" CHAR(1) DEFAULT 'Y', 
	"APLAN" CHAR(1) DEFAULT 'Y', 
	"UPROGRAMMNR" NUMBER(10,0), 
	"STATISTIKANFANG" DATE, 
	"STATISTIKENDE" DATE, 
	"NNMITTEL" NUMBER(7,3), 
	"NNMAX" NUMBER(7,3), 
	"NNMIN" NUMBER(7,3), 
	"FLURABSTMITTEL" NUMBER(7,3), 
	"FLURABSTMAX" NUMBER(7,3), 
	"FLURABSTMIN" NUMBER(7,3), 
	"DATUMMIN" DATE, 
	"DATUMMAX" DATE, 
	"SYMBOL" NUMBER(10,0), 
	"QEINHEIT" CHAR(1), 
	"QART" CHAR(1), 
	"MESSPUNKT" VARCHAR2(25), 
	"TOLERANZ" NUMBER(7,3), 
	"EXTPROG1NAME" VARCHAR2(20), 
	"EXTPROG1FILEEXT" CHAR(3), 
	"EXTPROG1PATH" VARCHAR2(100), 
	"EXTPROG1FILE" VARCHAR2(200), 
	"EXTPROG2NAME" VARCHAR2(20), 
	"EXTPROG2FILEEXT" CHAR(3), 
	"EXTPROG2PATH" VARCHAR2(100), 
	"EXTPROG2FILE" VARCHAR2(200), 
	"MESSPUNKTBILDDATEI" VARCHAR2(200), 
	"BARCODE" VARCHAR2(20), 
	"P_REP_ID" NUMBER(10,0), 
	"NEGATELEVELS" CHAR(1) DEFAULT 'N', 
	"DEPTHREFERENCE" CHAR(1), 
	"CNT_LEVELS" NUMBER(10,0), 
	"CNT_SAMPLES" NUMBER(10,0), 
	"CNT_RATES" NUMBER(10,0), 
	"CNT_FILES" NUMBER(10,0), 
	"UTM_EAST" NUMBER(12,4), 
	"UTM_NORTH" NUMBER(12,4), 
	"VISIBLETABS" VARCHAR2(40), 
	"WEB_WELLCAT" VARCHAR2(2), 
	"WEB_LEVELCAT" VARCHAR2(2), 
	"WEB_ANALYCAT" VARCHAR2(2), 
	"WEB_RATECAT" VARCHAR2(2), 
	"WEB_LEVELSTATCAT" VARCHAR2(2), 
	"WEB_ANALYSTATCAT" VARCHAR2(2), 
	"WEB_RATESTATCAT" VARCHAR2(2), 
	"LEVELUPPERBOUND" NUMBER(8,2), 
	"LEVELLOWERBOUND" NUMBER(8,2), 
	"FILTERBOTTOM_SL" NUMBER(8,2), 
	"FILTERTOP_SL" NUMBER(8,2), 
	"ABSMAXLEVEL_SL" NUMBER(8,2), 
	"AVMAXLEVEL_SL" NUMBER(8,2), 
	"ABSMINLEVEL_SL" NUMBER(8,2), 
	"AVMINLEVEL_SL" NUMBER(8,2), 
	"AVMEANLEVEL_SL" NUMBER(8,2), 
	"SEQNO" NUMBER(10,0), 
	"DATEBUILD" DATE, 
	"DATEDESTROYED" DATE, 
	"DRILLELEVATION" NUMBER(10,2), 
	"SAMPLINGDEPTH" NUMBER(10,2), 
	"STATUS_ID" NUMBER(10,0), 
	"STATIONTYPE" NUMBER(10,0) DEFAULT 1, 
	"SAP_KEY" NVARCHAR2(50), 
	"STANDARDSAMPLINGTYPE" NVARCHAR2(50), 
	"SURFACEWATER_ID" NUMBER(10,0), 
	"SURFACEWATERPART_ID" NUMBER(10,0), 
	"KM" NUMBER(10,2), 
	"SURFACEWATERDISTANCE" NUMBER(12,4), 
	"CATCHMENTAREA_ID" NUMBER(10,0), 
	"AQUIFERTHICKNESS" NVARCHAR2(20), 
	"FILTERLENGTH" NUMBER(10,2), 
	"STREETKEY" NVARCHAR2(20), 
	"HOUSENO" NVARCHAR2(10), 
	"GWW" NCHAR(1) DEFAULT '-', 
	"GWWTRANSFERDATE" DATE, 
	"GWWLEVELS" NCHAR(1) DEFAULT '-', 
	"GWWRATES" NCHAR(1) DEFAULT '-', 
	"GWWANALYSES" NCHAR(1) DEFAULT '-', 
	"GWWLOGGER" NCHAR(1) DEFAULT '-', 
	"GWWRAIN" NCHAR(1) DEFAULT '-', 
	"GWWCLIMATE" NCHAR(1) DEFAULT '-', 
	"GWWFILEDATE" DATE, 
	"MODIFYDATE" DATE, 
	"GROUPNO" NVARCHAR2(50), 
	"DRILLEDDEPTH" NUMBER(8,2)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_MSSTAMM_TEMP
--------------------------------------------------------

  CREATE TABLE "GWB_MSSTAMM_TEMP" 
   (	"KENNNR" VARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_NUTZUNG
--------------------------------------------------------

  CREATE TABLE "GWB_NUTZUNG" 
   (	"NUTZUNG" VARCHAR2(50), 
	"KEYNR" VARCHAR2(10)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_OBJECT_PIPES
--------------------------------------------------------

  CREATE TABLE "GWB_OBJECT_PIPES" 
   (	"ID" NUMBER(10,0), 
	"OBJECT_ID" NUMBER(10,0), 
	"ITEMNAME" NVARCHAR2(50), 
	"WATERTYPE_ID" NUMBER(10,0), 
	"INPUTPIPE_ID" NUMBER(10,0), 
	"OUTPUTPIPE_ID" NUMBER(10,0), 
	"PIPETYPE_ID" NUMBER(10,0), 
	"ELEVATION" NUMBER(10,2), 
	"DIAMETER" NUMBER(10,0), 
	"MATERIAL_ID" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_OBJECT_TECHPARTS
--------------------------------------------------------

  CREATE TABLE "GWB_OBJECT_TECHPARTS" 
   (	"ID" NUMBER(10,0), 
	"OBJECT_ID" NUMBER(10,0), 
	"PART_ID" NUMBER(10,0), 
	"COMMENTTEXT" NVARCHAR2(255)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_OBJECTTYPES
--------------------------------------------------------

  CREATE TABLE "GWB_OBJECTTYPES" 
   (	"ID" NUMBER(10,0), 
	"DESCRIPTION" NVARCHAR2(100)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_PARAMET
--------------------------------------------------------

  CREATE TABLE "GWB_PARAMET" 
   (	"ID" NUMBER(10,0), 
	"PARAMETERKUERZEL" VARCHAR2(20), 
	"PARAMETERNAME" VARCHAR2(100), 
	"STANDARDEINHEIT" VARCHAR2(10), 
	"STANDARDUNITSOIL" VARCHAR2(10), 
	"STANDARDUNITELUAT" VARCHAR2(10), 
	"STANDARDUNITAIR" VARCHAR2(10), 
	"KEYNR" VARCHAR2(10), 
	"KEYNR2" VARCHAR2(10), 
	"PARAMTYPE" NUMBER(10,0), 
	"ISSUMPARAM" CHAR(1) DEFAULT 'N', 
	"ISONSITEPARAM" CHAR(1) DEFAULT 'N', 
	"MOLMASSE" NUMBER(10,2), 
	"COLOR" NUMBER(10,0), 
	"KAT1" CHAR(1) DEFAULT 'N', 
	"KAT2" CHAR(1) DEFAULT 'N', 
	"KAT3" CHAR(1) DEFAULT 'N', 
	"KAT4" CHAR(1) DEFAULT 'N', 
	"KAT5" CHAR(1) DEFAULT 'N', 
	"KAT6" CHAR(1) DEFAULT 'N', 
	"KAT7" CHAR(1) DEFAULT 'N', 
	"KAT8" CHAR(1) DEFAULT 'N', 
	"KAT9" CHAR(1) DEFAULT 'N', 
	"KAT10" CHAR(1) DEFAULT 'N', 
	"BEMERKUNGPARAMETER" VARCHAR2(250), 
	"ALLOWNEGATIVE" CHAR(1) DEFAULT 'N', 
	"GRENZWERT1" NUMBER(12,4), 
	"GRENZWERT1NAME" VARCHAR2(50), 
	"GRENZWERT2" NUMBER(12,4), 
	"GRENZWERT2NAME" VARCHAR2(50), 
	"GRENZWERT3" NUMBER(12,4), 
	"GRENZWERT3NAME" VARCHAR2(50), 
	"GRENZWERT4" NUMBER(12,4), 
	"GRENZWERT4NAME" VARCHAR2(50), 
	"GRENZWERT5" NUMBER(12,4), 
	"GRENZWERT5NAME" VARCHAR2(50), 
	"GRENZWERT6" NUMBER(12,4), 
	"GRENZWERT6NAME" VARCHAR2(50), 
	"GRENZWERT7" NUMBER(12,4), 
	"GRENZWERT7NAME" VARCHAR2(50), 
	"GRENZWERT8" NUMBER(12,4), 
	"GRENZWERT8NAME" VARCHAR2(50), 
	"STDGRENZWERT" CHAR(1), 
	"SEQNR" NUMBER(10,0), 
	"LOWERBOUND" NUMBER(12,4), 
	"UPPERBOUND" NUMBER(12,4), 
	"WEB_CAT" VARCHAR2(2), 
	"STDMETHOD_ID" NUMBER(10,0), 
	"DETECTLIMITWATER" NUMBER(12,5), 
	"DETECTLIMITSOIL" NUMBER(12,5), 
	"DETECTLIMITAQSOL" NUMBER(12,5), 
	"DETECTLIMITAIR" NUMBER(12,5), 
	"DECIMALPLACES" NUMBER(10,0), 
	"VALENCENO" NUMBER(10,0), 
	"PARAMGROUP" NVARCHAR2(1), 
	"SYMBOL" NUMBER(10,0), 
	"GWW" NCHAR(1) DEFAULT '-', 
	"GWWTRANSFERDATE" DATE, 
	"HASUPPERLIMIT" NCHAR(1) DEFAULT '+'
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_PARAMLISTS
--------------------------------------------------------

  CREATE TABLE "GWB_PARAMLISTS" 
   (	"ID" NUMBER(10,0), 
	"LISTNAME" VARCHAR2(100), 
	"PARAMIDS" CLOB
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_PARAM_VALUECLASSES
--------------------------------------------------------

  CREATE TABLE "GWB_PARAM_VALUECLASSES" 
   (	"ID" NUMBER(10,0), 
	"PARAM_ID" NUMBER(10,0), 
	"MEDIUM" NUMBER(10,0), 
	"CLASSVALUE" NUMBER(12,4), 
	"CLASSCOLOR" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_PIPEMATERIALCAT
--------------------------------------------------------

  CREATE TABLE "GWB_PIPEMATERIALCAT" 
   (	"ID" NUMBER(10,0), 
	"ITEMNAME" NVARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_PIPES
--------------------------------------------------------

  CREATE TABLE "GWB_PIPES" 
   (	"ID" NUMBER(10,0), 
	"PIPENAME" NVARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_PIPETYPECAT
--------------------------------------------------------

  CREATE TABLE "GWB_PIPETYPECAT" 
   (	"ID" NUMBER(10,0), 
	"ITEMNAME" NVARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_PROBEN
--------------------------------------------------------

  CREATE TABLE "GWB_PROBEN" 
   (	"DATUMID" NUMBER(10,0), 
	"PROBENNR" VARCHAR2(20), 
	"PROBENNEHMER" VARCHAR2(20), 
	"WETTER" NVARCHAR2(50), 
	"LABOR" NVARCHAR2(100), 
	"ENTNAHMETIEFE" NUMBER(7,3), 
	"ENTNAHMETIEFEBIS" NUMBER(7,3), 
	"FOERDERRATE" VARCHAR2(10), 
	"FOERDERDAUER" VARCHAR2(10), 
	"FOERDERGERAET" VARCHAR2(50), 
	"GERAETETYP" VARCHAR2(50), 
	"PROBENART" NVARCHAR2(50), 
	"TRUEBUNG" NVARCHAR2(50), 
	"FARBE" NVARCHAR2(50), 
	"GERUCH" NVARCHAR2(50), 
	"BODENSATZ" NVARCHAR2(50), 
	"UPROGRAMM" NUMBER(10,0), 
	"PROGRAMMEINGEGEBEN" CHAR(1) DEFAULT 'N', 
	"SAMPLEDESCRIPTION" VARCHAR2(100), 
	"LEVELBEFORE" NUMBER(7,3), 
	"LEVELAFTER" NUMBER(7,3), 
	"LEVELCONST" CHAR(1), 
	"LOCKED" CHAR(1), 
	"TASTE" NVARCHAR2(50), 
	"CREATEDBY" NUMBER(10,0), 
	"USERFIELD1" VARCHAR2(50), 
	"USERFIELD2" VARCHAR2(50), 
	"USERFIELD3" VARCHAR2(50), 
	"USERFIELD4" VARCHAR2(50), 
	"USERFIELD5" VARCHAR2(50), 
	"REASON_ID" NUMBER(10,0), 
	"MATERIAL_ID" NUMBER(10,0), 
	"HARDNESS" NVARCHAR2(50), 
	"SUMCATIONS" NUMBER(10,4), 
	"SUMANIONS" NUMBER(10,4), 
	"SUMCATIONSCEQ" NUMBER(10,4), 
	"SUMANIONSCEQ" NUMBER(10,4)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_PROGGROUPS
--------------------------------------------------------

  CREATE TABLE "GWB_PROGGROUPS" 
   (	"ID" NUMBER(10,0), 
	"GROUPNAME" VARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_PROGGROUPS_PROGS
--------------------------------------------------------

  CREATE TABLE "GWB_PROGGROUPS_PROGS" 
   (	"GROUP_ID" NUMBER(10,0), 
	"PROG_ID" NUMBER(10,0), 
	"SEQNR" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_PROG_PARAM
--------------------------------------------------------

  CREATE TABLE "GWB_PROG_PARAM" 
   (	"PROG_ID" NUMBER(10,0), 
	"SEQNR" NUMBER(10,0), 
	"PARAM_ID" NUMBER(10,0), 
	"DETECTLIMIT" NUMBER(12,4), 
	"PARAMUNIT" VARCHAR2(10)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_PROJECTS
--------------------------------------------------------

  CREATE TABLE "GWB_PROJECTS" 
   (	"ID" NUMBER(10,0), 
	"PROJECTDESCR" VARCHAR2(50), 
	"PROJECTCOMMENT" VARCHAR2(50), 
	"REFERENCENO_1" NVARCHAR2(50), 
	"REFERENCENO_2" NVARCHAR2(50), 
	"REFERENCENO_3" NVARCHAR2(50), 
	"REFERENCENO_4" NVARCHAR2(50), 
	"REFERENCENO_5" NVARCHAR2(50), 
	"TEXT_1" NVARCHAR2(100), 
	"LOGICAL_1" NVARCHAR2(1) DEFAULT 'N', 
	"TEXT_2" NVARCHAR2(100), 
	"LOGICAL_2" NVARCHAR2(1) DEFAULT 'N', 
	"TEXT_3" NVARCHAR2(100), 
	"LOGICAL_3" NVARCHAR2(1) DEFAULT 'N', 
	"TEXT_4" NVARCHAR2(100), 
	"LOGICAL_4" NVARCHAR2(1) DEFAULT 'N', 
	"TEXT_5" NVARCHAR2(100), 
	"LOGICAL_5" NVARCHAR2(1) DEFAULT 'N', 
	"OWNER_ID" NUMBER(10,0), 
	"EPSG_CODE" NVARCHAR2(20), 
	"NAD_GRID" NVARCHAR2(200), 
	"GROUP_ID" NUMBER(10,0), 
	"ISDEFAULTGROUP" NUMBER(10,0), 
	"GWW" NCHAR(1) DEFAULT '-', 
	"GWWTRANSFERDATE" DATE, 
	"STATIONSUNIQUE" NUMBER(10,0) DEFAULT 0
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_PROJECTSETTINGS
--------------------------------------------------------

  CREATE TABLE "GWB_PROJECTSETTINGS" 
   (	"ID" NUMBER(10,0), 
	"PROJECTSETTINGS" CLOB, 
	"LASTOPENDATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_PROJECTS_USERS
--------------------------------------------------------

  CREATE TABLE "GWB_PROJECTS_USERS" 
   (	"PU_PROJECTID" NUMBER(10,0), 
	"PU_LOGINNAME" VARCHAR2(20), 
	"PU_PRIV_WELLS" NUMBER(4,0), 
	"PU_PRIV_LEVEL" NUMBER(4,0), 
	"PU_PRIV_ANALYSIS" NUMBER(4,0), 
	"PU_PRIV_DISCHARGE" NUMBER(4,0), 
	"PU_PRIV_RAINFALL" NUMBER(4,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_PUMP_DATA
--------------------------------------------------------

  CREATE TABLE "GWB_PUMP_DATA" 
   (	"ID" NUMBER(10,0), 
	"WELL_ID" NUMBER(10,0), 
	"EQUIP_ID" NUMBER(10,0), 
	"DATEAV" DATE, 
	"HEAD_VOL" NUMBER(10,2), 
	"HEAD_CURR" NUMBER(10,2), 
	"VOL_CURR" NUMBER(10,2), 
	"DATACOUNT" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_PUMPEN
--------------------------------------------------------

  CREATE TABLE "GWB_PUMPEN" 
   (	"PUMPENTYP" VARCHAR2(50), 
	"KEYNR" VARCHAR2(10)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_RAINFALL
--------------------------------------------------------

  CREATE TABLE "GWB_RAINFALL" 
   (	"WELL_ID" NUMBER(10,0), 
	"DATE1" DATE, 
	"DATE2" DATE, 
	"RAINFALL" NUMBER(5,2), 
	"IMPORT_ID" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_RATES
--------------------------------------------------------

  CREATE TABLE "GWB_RATES" 
   (	"MESSTELLENID" NUMBER(10,0), 
	"DATUM1" DATE, 
	"DATUM2" DATE, 
	"QWERT" NUMBER(10,4), 
	"OPHOURS" NUMBER(6,2), 
	"IMPORT_ID" NUMBER(10,0), 
	"CURRENTREADING" NUMBER(10,0), 
	"COMMENTTEXT" VARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_REPORTGROUPS
--------------------------------------------------------

  CREATE TABLE "GWB_REPORTGROUPS" 
   (	"ID" NUMBER(10,0), 
	"GROUPNAME" NVARCHAR2(100), 
	"TITLE1" NVARCHAR2(50), 
	"TITLE2" NVARCHAR2(50), 
	"TITLE3" NVARCHAR2(50), 
	"TITLE4" NVARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_REPORTGROUPS_PARAMGROUPS
--------------------------------------------------------

  CREATE TABLE "GWB_REPORTGROUPS_PARAMGROUPS" 
   (	"GROUP_ID" NUMBER(10,0), 
	"PARAMGROUP_ID" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_REPORTGROUPS_PARAMS
--------------------------------------------------------

  CREATE TABLE "GWB_REPORTGROUPS_PARAMS" 
   (	"GROUP_ID" NUMBER(10,0), 
	"PARAM_ID" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_REPORTGROUPS_STATIONS
--------------------------------------------------------

  CREATE TABLE "GWB_REPORTGROUPS_STATIONS" 
   (	"GROUP_ID" NUMBER(10,0), 
	"STATION_ID" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_REPORTGROUPS_TEMPLATES
--------------------------------------------------------

  CREATE TABLE "GWB_REPORTGROUPS_TEMPLATES" 
   (	"ID" NUMBER(10,0), 
	"GROUP_ID" NUMBER(10,0), 
	"REPORTTEMPLATE" NVARCHAR2(255), 
	"SEQNO" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_SAMPLECALENDAR
--------------------------------------------------------

  CREATE TABLE "GWB_SAMPLECALENDAR" 
   (	"SAMPLEDATE" NUMBER(10,0), 
	"WELL_ID" NUMBER(10,0), 
	"PROGGROUP_ID" NUMBER(10,0), 
	"DONE" CHAR(1)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_SAMPLECOLOR
--------------------------------------------------------

  CREATE TABLE "GWB_SAMPLECOLOR" 
   (	"COLOR" VARCHAR2(20), 
	"KEYNR" VARCHAR2(10)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_SAMPLEMATERIAL
--------------------------------------------------------

  CREATE TABLE "GWB_SAMPLEMATERIAL" 
   (	"ID" NUMBER(10,0), 
	"SHORTNAME" VARCHAR2(24), 
	"LONGNAME" VARCHAR2(80)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_SAMPLESEDIMENT
--------------------------------------------------------

  CREATE TABLE "GWB_SAMPLESEDIMENT" 
   (	"SEDIMENT" NVARCHAR2(50), 
	"KEYNR" VARCHAR2(10)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_SAMPLESMELL
--------------------------------------------------------

  CREATE TABLE "GWB_SAMPLESMELL" 
   (	"SMELL" NVARCHAR2(50), 
	"KEYNR" VARCHAR2(10)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_SAMPLES_PROGS
--------------------------------------------------------

  CREATE TABLE "GWB_SAMPLES_PROGS" 
   (	"SAMPLE_ID" NUMBER(10,0), 
	"PROG_ID" NUMBER(10,0), 
	"SEQNR" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_SAMPLETURBIDITY
--------------------------------------------------------

  CREATE TABLE "GWB_SAMPLETURBIDITY" 
   (	"TURBIDITY" NVARCHAR2(50), 
	"KEYNR" VARCHAR2(10)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_SAMPLETYPE
--------------------------------------------------------

  CREATE TABLE "GWB_SAMPLETYPE" 
   (	"SAMPLETYPE" NVARCHAR2(50), 
	"KEYNR" VARCHAR2(10)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_SAMPLEWEATHER
--------------------------------------------------------

  CREATE TABLE "GWB_SAMPLEWEATHER" 
   (	"WEATHER" NVARCHAR2(50), 
	"KEYNR" VARCHAR2(10)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_SAMPLINGREASONS
--------------------------------------------------------

  CREATE TABLE "GWB_SAMPLINGREASONS" 
   (	"ID" NUMBER(10,0), 
	"REASON" VARCHAR2(50), 
	"KEYNR" VARCHAR2(10)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_SELECTIONS
--------------------------------------------------------

  CREATE TABLE "GWB_SELECTIONS" 
   (	"ID" NUMBER(10,0), 
	"OWNER" VARCHAR2(20), 
	"CONDNAME" VARCHAR2(255), 
	"PROJCOND" VARCHAR2(255), 
	"WELLCOND" CLOB, 
	"PROGCOND" VARCHAR2(255)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_SENSORDEPTH
--------------------------------------------------------

  CREATE TABLE "GWB_SENSORDEPTH" 
   (	"ID" NUMBER(10,0), 
	"WELL_ID" NUMBER(10,0), 
	"SENSORDEPTH" NUMBER(8,2), 
	"SENSORDATE" DATE, 
	"COMMENTTEXT" NVARCHAR2(100), 
	"MTYPE" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_SITEOWNERS
--------------------------------------------------------

  CREATE TABLE "GWB_SITEOWNERS" 
   (	"ID" NUMBER(10,0), 
	"NAME" VARCHAR2(50), 
	"ZIP" VARCHAR2(10), 
	"STREET" VARCHAR2(50), 
	"TOWN" VARCHAR2(50), 
	"TEL" VARCHAR2(20)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_SPEC_YIELD
--------------------------------------------------------

  CREATE TABLE "GWB_SPEC_YIELD" 
   (	"ID" NUMBER(10,0), 
	"WELL_ID" NUMBER(10,0), 
	"MDATE" DATE, 
	"DRAWDOWN" NUMBER(8,2), 
	"FLOW" NUMBER(8,2), 
	"COMMENTTEXT" VARCHAR2(50), 
	"MDATE_STATIC" DATE, 
	"STATIC_LEVEL" NUMBER(10,2), 
	"PRESSURE" NUMBER(10,2), 
	"POWER" NUMBER(10,2)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_SQLRECHERCHE
--------------------------------------------------------

  CREATE TABLE "GWB_SQLRECHERCHE" 
   (	"ID" NUMBER(10,0), 
	"ART" VARCHAR2(1), 
	"BEZEICHNUNG" VARCHAR2(64), 
	"BESCHREIBUNG" VARCHAR2(128), 
	"GRUPPE" NUMBER(10,0), 
	"KMSALLE" VARCHAR2(1), 
	"KMSTEILGEBIET" NUMBER(10,0), 
	"KMSROUTE" NUMBER(10,0), 
	"KMSHWSTOCKW" NUMBER(10,0), 
	"KMSGEOLEINHEIT" NUMBER(10,0), 
	"KWSWASSERSTANDJN" VARCHAR2(1), 
	"KWSPERSON" NUMBER(10,0), 
	"KWSKENNUNG" VARCHAR2(1), 
	"KWSATTRIBUT" NUMBER(10,0), 
	"KWSHINWEISJN" VARCHAR2(1), 
	"KWSMITOHNEWERT" VARCHAR2(1), 
	"KWSRELATION" VARCHAR2(1), 
	"KWSWERT" NUMBER(10,2), 
	"KWSBEZUG" VARCHAR2(1), 
	"KWSWSUNTERFILTERUK" VARCHAR2(1), 
	"KWSGELOTETETIEFE" VARCHAR2(1), 
	"KPBPROBEJN" VARCHAR2(1), 
	"KPBERLEDIGTJN" VARCHAR2(1), 
	"KPBPROBENNEHMER" VARCHAR2(64), 
	"KPBUPROGRAMM" NUMBER(10,0), 
	"KAYANALYSEJN" VARCHAR2(1), 
	"KAYMITPARAM" VARCHAR2(1), 
	"KAYPARAMANZAHL" VARCHAR2(1), 
	"KAYMITOHNEWERT" VARCHAR2(1), 
	"KAYPARAMETER" NUMBER(10,0), 
	"KAYRELATION" VARCHAR2(1), 
	"KAYWERT" NUMBER(10,2), 
	"KAYLABOR" NUMBER(10,0), 
	"KDTDATUMJN" VARCHAR2(1), 
	"VISCOLLAGE" VARCHAR2(1), 
	"VISCOLANALYMETHOD" VARCHAR2(1)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_STATIONREPORTS
--------------------------------------------------------

  CREATE TABLE "GWB_STATIONREPORTS" 
   (	"ID" NUMBER(10,0), 
	"DESCRIPTION" NVARCHAR2(50), 
	"SORTORDER" NUMBER(10,0), 
	"PARAMETER_ID" NUMBER(10,0), 
	"STN1_ID" NUMBER(10,0), 
	"STN2_ID" NUMBER(10,0), 
	"STN3_ID" NUMBER(10,0), 
	"STN4_ID" NUMBER(10,0), 
	"STN5_ID" NUMBER(10,0), 
	"STN6_ID" NUMBER(10,0), 
	"STN7_ID" NUMBER(10,0), 
	"STN8_ID" NUMBER(10,0), 
	"STN9_ID" NUMBER(10,0), 
	"STN10_ID" NUMBER(10,0), 
	"THRESHOLDTEXT" NVARCHAR2(50), 
	"THRESHOLDVALUE" NUMBER(10,2)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_STNFLOWDEVICEHISTORY
--------------------------------------------------------

  CREATE TABLE "GWB_STNFLOWDEVICEHISTORY" 
   (	"ID" NUMBER(10,0), 
	"STATION_ID" NUMBER(10,0), 
	"FLOWDEVICE_ID" NUMBER(10,0), 
	"FLOWDEVICEDATE" DATE, 
	"FLOWDEVICECOMMENTTEXT" NVARCHAR2(100)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_STOFFKL
--------------------------------------------------------

  CREATE TABLE "GWB_STOFFKL" 
   (	"CLASS_ID" NUMBER(10,0), 
	"NAME" VARCHAR2(50), 
	"CLASSTYPE" NUMBER(10,0), 
	"KAT1" CHAR(1) DEFAULT 'N', 
	"KAT2" CHAR(1) DEFAULT 'N', 
	"KAT3" CHAR(1) DEFAULT 'N', 
	"KAT4" CHAR(1) DEFAULT 'N', 
	"KAT5" CHAR(1) DEFAULT 'N', 
	"KAT6" CHAR(1) DEFAULT 'N', 
	"KAT7" CHAR(1) DEFAULT 'N', 
	"KAT8" CHAR(1) DEFAULT 'N', 
	"KAT9" CHAR(1) DEFAULT 'N', 
	"KAT10" CHAR(1) DEFAULT 'N', 
	"STANDARDEINHEIT" VARCHAR2(10), 
	"STANDARDUNITSOIL" VARCHAR2(10), 
	"STANDARDUNITELUAT" VARCHAR2(10), 
	"STANDARDUNITAIR" VARCHAR2(10), 
	"SUMPARAM_ID" NUMBER(10,0), 
	"COLOR" NUMBER(10,0), 
	"SUMCALCONCOMPLETE" CHAR(1) DEFAULT 'N'
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_STOREDRIVERNET_AQUIFERS
--------------------------------------------------------

  CREATE TABLE "GWB_STOREDRIVERNET_AQUIFERS" 
   (	"STOREDRIVERNET_ID" NUMBER(10,0), 
	"AQUIFER_ID" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_STOREDRIVERNET_POINTS
--------------------------------------------------------

  CREATE TABLE "GWB_STOREDRIVERNET_POINTS" 
   (	"STOREDRIVERNET_ID" NUMBER(10,0), 
	"SEQNR" NUMBER(10,0), 
	"X" NUMBER(12,4), 
	"Y" NUMBER(12,4), 
	"Z" NUMBER(7,3), 
	"CONNECTIONTYPE" NUMBER(4,0), 
	"CONNECTIONFACTOR" NUMBER(4,3)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_STOREDRIVERNETS
--------------------------------------------------------

  CREATE TABLE "GWB_STOREDRIVERNETS" 
   (	"ID" NUMBER(10,0), 
	"RIVERNETNAME" VARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_STREETCAT
--------------------------------------------------------

  CREATE TABLE "GWB_STREETCAT" 
   (	"STREETKEY" NVARCHAR2(20), 
	"STREETNAME" NVARCHAR2(100)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_STRUCTPARTS
--------------------------------------------------------

  CREATE TABLE "GWB_STRUCTPARTS" 
   (	"ID" NUMBER(10,0), 
	"STRUCT_ID" NUMBER(10,0), 
	"STRUCTPARTNAME" VARCHAR2(50), 
	"CONNECTIONTYPE" NUMBER(4,0), 
	"CONNECTIONFACTOR" NUMBER(4,3), 
	"ELEVATIONTOP" NUMBER(7,3), 
	"NEXTPART_ID" NUMBER(10,0), 
	"PREVPART_ID" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_STRUCTPARTS_AQUIFERS
--------------------------------------------------------

  CREATE TABLE "GWB_STRUCTPARTS_AQUIFERS" 
   (	"STRUCTPART_ID" NUMBER(10,0), 
	"AQUIFER_ID" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_STRUCTPARTS_POINTS
--------------------------------------------------------

  CREATE TABLE "GWB_STRUCTPARTS_POINTS" 
   (	"STRUCTPART_ID" NUMBER(10,0), 
	"POINT_ID" NUMBER(10,0), 
	"NEXTPOINT_ID" NUMBER(10,0), 
	"PREVPOINT_ID" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_STRUCTPOINTS
--------------------------------------------------------

  CREATE TABLE "GWB_STRUCTPOINTS" 
   (	"ID" NUMBER(10,0), 
	"X" NUMBER(12,4), 
	"Y" NUMBER(12,4), 
	"STATION_ID" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_STRUCTURES
--------------------------------------------------------

  CREATE TABLE "GWB_STRUCTURES" 
   (	"ID" NUMBER(10,0), 
	"STRUCTNAME" VARCHAR2(50), 
	"STRUCTTYPE" CHAR(1), 
	"PRIORITY" NUMBER(4,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_SURFACEWATER_PARTS
--------------------------------------------------------

  CREATE TABLE "GWB_SURFACEWATER_PARTS" 
   (	"ID" NUMBER(10,0), 
	"MAIN_ID" NUMBER(10,0), 
	"ITEMNAME" NVARCHAR2(100), 
	"SEQNR" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_SURFACEWATERS
--------------------------------------------------------

  CREATE TABLE "GWB_SURFACEWATERS" 
   (	"ID" NUMBER(10,0), 
	"ITEMNAME" NVARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_SYMBOLS
--------------------------------------------------------

  CREATE TABLE "GWB_SYMBOLS" 
   (	"SYMBOLID" NUMBER(10,0), 
	"SYMBOLCHAR" CHAR(1), 
	"SYMBOLTEXT" VARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_SYMBOLSCATEGORIES
--------------------------------------------------------

  CREATE TABLE "GWB_SYMBOLSCATEGORIES" 
   (	"ID" NUMBER(10,0), 
	"FIELD_NAME" NVARCHAR2(50), 
	"CATEGORY" NVARCHAR2(100), 
	"ICON" NVARCHAR2(100), 
	"ICONPOSITION" NVARCHAR2(1)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_TASTE
--------------------------------------------------------

  CREATE TABLE "GWB_TASTE" 
   (	"ID" NUMBER(10,0), 
	"TASTE" NVARCHAR2(50), 
	"KEYNE" VARCHAR2(10), 
	"KEYNR" CHAR(10)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_TECHEQUIP_HISTORY
--------------------------------------------------------

  CREATE TABLE "GWB_TECHEQUIP_HISTORY" 
   (	"ID" NUMBER(10,0), 
	"EQUIP_ID" NUMBER(10,0), 
	"WELL_ID" NUMBER(10,0), 
	"STARTDATE" DATE, 
	"ENDDATE" DATE, 
	"HISTORYTYPE" CHAR(1)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_TECHEQUIP_MANUFACTURERCAT
--------------------------------------------------------

  CREATE TABLE "GWB_TECHEQUIP_MANUFACTURERCAT" 
   (	"ID" NUMBER(10,0), 
	"MANUFACTURER" NVARCHAR2(70)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_TECHEQUIPMENT
--------------------------------------------------------

  CREATE TABLE "GWB_TECHEQUIPMENT" 
   (	"ID" NUMBER(10,0), 
	"CATEGORY" CHAR(1), 
	"TYPE" VARCHAR2(50), 
	"PERSON" VARCHAR2(30), 
	"INVENTORYNO" VARCHAR2(50), 
	"MATERIAL" VARCHAR2(20), 
	"PRICE" NUMBER(10,2), 
	"DATEAQUIRED" DATE, 
	"MANUFACTURER" VARCHAR2(50), 
	"YEARMADE" NUMBER(4,0), 
	"REMARKS" CLOB, 
	"DATAFILE" VARCHAR2(255), 
	"RATEDFLOW" NUMBER(12,4), 
	"RATEDFLOWUNIT" VARCHAR2(10), 
	"RATEDCURRENT" NUMBER(12,4), 
	"RATEDHEAD" NUMBER(12,4), 
	"RATEDHEADUNIT" VARCHAR2(5), 
	"DIAMETER" NUMBER(10,2), 
	"DIAMETERUNIT" VARCHAR2(5), 
	"LENGTH" NUMBER(10,2), 
	"LENGTHUNIT" VARCHAR2(5), 
	"SYSTEMLENGTH" NUMBER(10,2), 
	"SYSTEMLENGTHUNIT" NVARCHAR2(5), 
	"SIMCARDNO" NVARCHAR2(20), 
	"SERIALNO" NVARCHAR2(50), 
	"INACTIVE" NVARCHAR2(1) DEFAULT 'N'
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_TECHEQUIP_REPAIRS
--------------------------------------------------------

  CREATE TABLE "GWB_TECHEQUIP_REPAIRS" 
   (	"ID" NUMBER(10,0), 
	"EQUIP_ID" NUMBER(10,0), 
	"HISTORY_ID" NUMBER(10,0), 
	"ADDRESS" VARCHAR2(255), 
	"PERSON" VARCHAR2(30), 
	"REPAIRREASON" VARCHAR2(255), 
	"REPAIRCOSTS" NUMBER(10,2), 
	"REMARKS" CLOB
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_TECHEQUIP_STORES
--------------------------------------------------------

  CREATE TABLE "GWB_TECHEQUIP_STORES" 
   (	"ID" NUMBER(10,0), 
	"EQUIP_ID" NUMBER(10,0), 
	"HISTORY_ID" NUMBER(10,0), 
	"STOREADDRESS" VARCHAR2(255), 
	"REMARKS" CLOB
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_TECHEQUIP_TYPECAT
--------------------------------------------------------

  CREATE TABLE "GWB_TECHEQUIP_TYPECAT" 
   (	"ID" NUMBER(10,0), 
	"EQUIPTYPE" NVARCHAR2(70)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_TECHEQUIP_WELLS
--------------------------------------------------------

  CREATE TABLE "GWB_TECHEQUIP_WELLS" 
   (	"ID" NUMBER(10,0), 
	"EQUIP_ID" NUMBER(10,0), 
	"HISTORY_ID" NUMBER(10,0), 
	"DEPTH" NUMBER(8,2), 
	"DEPTHUNIT" VARCHAR2(5), 
	"REMARKS" CLOB
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_TECHPARTSCAT
--------------------------------------------------------

  CREATE TABLE "GWB_TECHPARTSCAT" 
   (	"ID" NUMBER(10,0), 
	"CLASS_ID" NUMBER(10,0), 
	"ITEMNAME" NVARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_TECHPARTSCLASSCAT
--------------------------------------------------------

  CREATE TABLE "GWB_TECHPARTSCLASSCAT" 
   (	"ID" NUMBER(10,0), 
	"ITEMNAME" NVARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_TODOCATEGORIES
--------------------------------------------------------

  CREATE TABLE "GWB_TODOCATEGORIES" 
   (	"ID" NUMBER(10,0), 
	"CATEGORYNAME" VARCHAR2(50), 
	"SAP_KEY" NVARCHAR2(50), 
	"REPEATMONTHS" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_TOPOGRAF
--------------------------------------------------------

  CREATE TABLE "GWB_TOPOGRAF" 
   (	"PROJECT_ID" NUMBER(10,0), 
	"RECHTSWERT" NUMBER(12,4), 
	"HOCHWERT" NUMBER(12,4), 
	"HOEHENN" NUMBER(6,2)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_UKAT
--------------------------------------------------------

  CREATE TABLE "GWB_UKAT" 
   (	"KATALOGNR" NUMBER(10,0), 
	"KATALOGBEZEICHNUNG" VARCHAR2(50), 
	"KATALOGTYPE" NUMBER(10,0), 
	"LAB_ID" NUMBER(10,0), 
	"SEQ_NR" NUMBER(10,0), 
	"DETECTLIMIT" NUMBER(12,4), 
	"SEQNR" NUMBER(10,0), 
	"ACTIVE" NVARCHAR2(1)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_UMRECH
--------------------------------------------------------

  CREATE TABLE "GWB_UMRECH" 
   (	"EINHEIT1" VARCHAR2(10), 
	"EINHEIT2" VARCHAR2(10), 
	"FAKTOR" NUMBER(16,8)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_USERS
--------------------------------------------------------

  CREATE TABLE "GWB_USERS" 
   (	"US_LOGINNAME" VARCHAR2(20), 
	"US_USERNAME" VARCHAR2(30), 
	"US_PASSWORD" VARCHAR2(10), 
	"US_ISADMIN" CHAR(1) DEFAULT 'N', 
	"US_ALLOWLOOKUPLISTS" CHAR(1) DEFAULT 'Y', 
	"US_ALLOWWARNLIST" CHAR(1) DEFAULT 'Y', 
	"US_PRIVATEMAPS" CHAR(1) DEFAULT 'Y', 
	"US_TABLELAYOUTCHANGE" CHAR(1) DEFAULT 'Y', 
	"US_LOGGERDATA" CHAR(1) DEFAULT 'Y', 
	"US_LASTUSER" CHAR(1), 
	"U_PRIV_WELLS" NUMBER(4,0), 
	"U_PRIV_LEVEL" NUMBER(4,0), 
	"U_PRIV_ANALYSIS" NUMBER(4,0), 
	"U_PRIV_DISCHARGE" NUMBER(4,0), 
	"U_PRIV_RAINFALL" NUMBER(4,0), 
	"ID" NUMBER(10,0), 
	"US_PRIVATESUBPROJECTS" NVARCHAR2(1), 
	"US_WINUSERNAME" NVARCHAR2(255), 
	"TEMPLATEDIRECTORY" NVARCHAR2(255), 
	"US_PASSWORDHASH" NVARCHAR2(255), 
	"US_ALLPROJECTS" NVARCHAR2(1)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_USERSELECTION
--------------------------------------------------------

  CREATE TABLE "GWB_USERSELECTION" 
   (	"USER_ID" NUMBER(10,0), 
	"WELL_ID" NUMBER(10,0), 
	"LIST_TYPE" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_VALUEMARKERS
--------------------------------------------------------

  CREATE TABLE "GWB_VALUEMARKERS" 
   (	"MARKER" VARCHAR2(1), 
	"MARKERTEXT" VARCHAR2(50), 
	"COLOR" NUMBER(10,0), 
	"ID" NUMBER(10,0), 
	"GWW" NCHAR(1) DEFAULT '-', 
	"GWWTRANSFERDATE" DATE, 
	"HASFLAG" NCHAR(1) DEFAULT '-', 
	"FLAGDEFINITION" CLOB, 
	"FLAGPREVIEW" BLOB
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_VALVEPOSITION
--------------------------------------------------------

  CREATE TABLE "GWB_VALVEPOSITION" 
   (	"ID" NUMBER(10,0), 
	"VALVE_ID" NUMBER(10,0), 
	"DATE_TIME" DATE, 
	"VALVEPOSITION" NUMBER(10,0), 
	"MAXVALVEPOSITION" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_VALVES
--------------------------------------------------------

  CREATE TABLE "GWB_VALVES" 
   (	"ID" NUMBER(10,0), 
	"OBJECT_ID" NUMBER(10,0), 
	"ELEVATION" NUMBER(10,2), 
	"DIAMETER" NUMBER(10,0), 
	"TYPE_ID" NUMBER(10,0), 
	"MAXPOSITION" NUMBER(10,0), 
	"DESCRIPTION" NVARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_VALVETYPECAT
--------------------------------------------------------

  CREATE TABLE "GWB_VALVETYPECAT" 
   (	"ID" NUMBER(10,0), 
	"ITEMNAME" NVARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_VERSION
--------------------------------------------------------

  CREATE TABLE "GWB_VERSION" 
   (	"VERSION" VARCHAR2(10), 
	"VERSION7" VARCHAR2(10), 
	"VERSION8" VARCHAR2(10), 
	"BACKUPDATE" DATE, 
	"VERSION9" NVARCHAR2(10)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_VIRTUALWELLS
--------------------------------------------------------

  CREATE TABLE "GWB_VIRTUALWELLS" 
   (	"ID" NUMBER(10,0), 
	"STATIONNAME" VARCHAR2(20), 
	"REFERENCESTATION_ID" NUMBER(10,0), 
	"X" NUMBER(12,4), 
	"Y" NUMBER(12,4), 
	"Z" NUMBER(7,3), 
	"TIMELAG" NUMBER(4,0), 
	"SHIFT" NUMBER(7,3), 
	"ISABSOLUTE" CHAR(1) DEFAULT 'N', 
	"ISACTIVE" CHAR(1) DEFAULT 'Y', 
	"CREATEDBY" VARCHAR2(20), 
	"COMMENTS" VARCHAR2(255), 
	"SYMBOL" NUMBER(10,0), 
	"UTM_EAST" NUMBER(12,4), 
	"UTM_NORTH" NUMBER(12,4)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_WATERTYPECAT
--------------------------------------------------------

  CREATE TABLE "GWB_WATERTYPECAT" 
   (	"ID" NUMBER(10,0), 
	"ITEMNAME" NVARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_WELLGEOLOGY
--------------------------------------------------------

  CREATE TABLE "GWB_WELLGEOLOGY" 
   (	"ID" NUMBER(10,0), 
	"WELL_ID" NUMBER(10,0), 
	"GEOLOGY_ID" NUMBER(10,0), 
	"DEPTHTOBASE" NUMBER(7,3), 
	"DEEPER" NVARCHAR2(1)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_WELLPROPERTIES
--------------------------------------------------------

  CREATE TABLE "GWB_WELLPROPERTIES" 
   (	"ID" NUMBER(10,0), 
	"PROPERTY_NAME" NVARCHAR2(50), 
	"PROPERTY_KEY" NVARCHAR2(20), 
	"USECATALOG" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_WELLPROPERTIES_VALUES
--------------------------------------------------------

  CREATE TABLE "GWB_WELLPROPERTIES_VALUES" 
   (	"ID" NUMBER(10,0), 
	"PROPERTY_ID" NUMBER(10,0), 
	"VALUETEXT" NVARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_WELLPROPERTIES_WELLS
--------------------------------------------------------

  CREATE TABLE "GWB_WELLPROPERTIES_WELLS" 
   (	"PROPERTY_ID" NUMBER(10,0), 
	"WELL_ID" NUMBER(10,0), 
	"PROPERTYTEXT" NVARCHAR2(255), 
	"PROPERTYDATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_WELLPUMPRATES
--------------------------------------------------------

  CREATE TABLE "GWB_WELLPUMPRATES" 
   (	"ID" NUMBER(10,0), 
	"WELL_ID" NUMBER(10,0), 
	"STARTDATE" DATE, 
	"ENDDATE" DATE, 
	"PUMPRATE" NUMBER(10,4), 
	"PUMPUNIT" NVARCHAR2(1)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_WELLS_PROJECTS
--------------------------------------------------------

  CREATE TABLE "GWB_WELLS_PROJECTS" 
   (	"WELL_ID" NUMBER(10,0), 
	"PROJECT_ID" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_WELLSTATUSCAT
--------------------------------------------------------

  CREATE TABLE "GWB_WELLSTATUSCAT" 
   (	"ID" NUMBER(10,0), 
	"STATUSNAME" NVARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_WELLSTATUSHISTORY
--------------------------------------------------------

  CREATE TABLE "GWB_WELLSTATUSHISTORY" 
   (	"ID" NUMBER(10,0), 
	"WELL_ID" NUMBER(10,0), 
	"STATUS_ID" NUMBER(10,0), 
	"STATUSDATE" DATE, 
	"STATUSCOMMENTTEXT" NVARCHAR2(100)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_WELLSTDTODOCATEGORIES
--------------------------------------------------------

  CREATE TABLE "GWB_WELLSTDTODOCATEGORIES" 
   (	"WELL_ID" NUMBER(10,0), 
	"CATEGORY_ID" NUMBER(10,0), 
	"REPEATMONTHS" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_WELLTODOLIST
--------------------------------------------------------

  CREATE TABLE "GWB_WELLTODOLIST" 
   (	"ID" NUMBER(10,0), 
	"WELL_ID" NUMBER(10,0), 
	"CATEGORY_ID" NUMBER(10,0), 
	"DESCRIPTION" VARCHAR2(255), 
	"CREATEDATE" DATE, 
	"TODOUNTIL" DATE, 
	"USER_ID" NUMBER(10,0), 
	"DONEDATE" DATE, 
	"DONECOMMENT" VARCHAR2(255), 
	"DONEUSER_ID" NUMBER(10,0), 
	"SAP_NOTIFYNUMBER" NVARCHAR2(10), 
	"SAP_ORDERNUMBER" NVARCHAR2(10), 
	"SAP_STATUS" NVARCHAR2(10), 
	"STATUS" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_WELLTODOLISTSAP_ERR
--------------------------------------------------------

  CREATE TABLE "GWB_WELLTODOLISTSAP_ERR" 
   (	"GWB_ID" NUMBER(10,0), 
	"TYPE" NVARCHAR2(1), 
	"ID" NVARCHAR2(20), 
	"NUMBER" NVARCHAR2(3), 
	"MESSAGE" NVARCHAR2(220), 
	"LOG_NO" NVARCHAR2(20), 
	"LOG_MSG_NO" NVARCHAR2(6), 
	"MESSAGE_V1" NVARCHAR2(50), 
	"MESSAGE_V2" NVARCHAR2(50), 
	"MESSAGE_V3" NVARCHAR2(50), 
	"MESSAGE_V4" NVARCHAR2(50), 
	"PARAMETER" NVARCHAR2(32), 
	"ROW" NUMBER(10,0), 
	"FIELD" NVARCHAR2(30), 
	"SYSTEM" NVARCHAR2(10), 
	"MESSAGE_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table GWB_WSTAND
--------------------------------------------------------

  CREATE TABLE "GWB_WSTAND" 
   (	"ID" NUMBER(10,0), 
	"MESSTELLENID" NUMBER(10,0), 
	"DATUMZEIT" DATE, 
	"WASSERSTAND" NUMBER(7,3), 
	"BEZUGMP" CHAR(1) DEFAULT 'Y', 
	"QUALITY" CHAR(1) DEFAULT '+', 
	"PERSON_ID" NUMBER(10,0), 
	"IMPORT_ID" NUMBER(10,0), 
	"LEVEL_SL" NUMBER(8,2), 
	"LOGGEDDEPTH" NUMBER(8,2), 
	"LOGGEDDEPTH_SL" NUMBER(8,2), 
	"DATATYPE" NUMBER(10,0) DEFAULT 0
   ) ;
--------------------------------------------------------
--  DDL for Table GWC_WELLCATEGORIES
--------------------------------------------------------

  CREATE TABLE "GWC_WELLCATEGORIES" 
   (	"TYPE_ID" NUMBER(10,0), 
	"CATEGORY_ID" NUMBER(10,0), 
	"NAME" NVARCHAR2(128), 
	"SEQNR" NUMBER(10,0) DEFAULT 32000, 
	"SYMBOLFILENAME" NVARCHAR2(32), 
	"SYMBOLDEFINITION" NVARCHAR2(128), 
	"SYMBOLWIDTH" NUMBER(10,0), 
	"SYMBOLHEIGHT" NUMBER(10,0), 
	"SYMBOLANCHORX" NUMBER(10,0) DEFAULT 0, 
	"SYMBOLANCHORY" NUMBER(10,0) DEFAULT 0, 
	"SYMBOLHOTSPOT" NCHAR(2) DEFAULT 'CC', 
	"GWW" NCHAR(1) DEFAULT '-', 
	"GWWFILEDATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table GWC_WELLCATEGORY_TYPES
--------------------------------------------------------

  CREATE TABLE "GWC_WELLCATEGORY_TYPES" 
   (	"ID" NUMBER(10,0), 
	"TABLENAME" NVARCHAR2(30), 
	"NAME" NVARCHAR2(50), 
	"GWW" NCHAR(1) DEFAULT '-', 
	"GWWTRANSFERDATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table GWM_DEPTHS
--------------------------------------------------------

  CREATE TABLE "GWM_DEPTHS" 
   (	"WELL_ID" NUMBER(10,0), 
	"DEPTH" NUMBER(8,2)
   ) ;
--------------------------------------------------------
--  DDL for Table GWM_PERSONS
--------------------------------------------------------

  CREATE TABLE "GWM_PERSONS" 
   (	"PERSON_ID" NUMBER(10,0), 
	"PERSON_NAME" VARCHAR2(50), 
	"PERSON_PIN" VARCHAR2(4), 
	"ALLOWSEELASTVALUE" CHAR(1) DEFAULT 'N', 
	"ALLOWMODIFYWELLDATA" CHAR(1) DEFAULT 'N', 
	"PERSONTYPE" NVARCHAR2(1), 
	"SAP_KEY" NVARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWM_PICTURECATEGORIESCAT
--------------------------------------------------------

  CREATE TABLE "GWM_PICTURECATEGORIESCAT" 
   (	"ID" NUMBER(10,0), 
	"PICTURECATEGORY" NVARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table GWM_ROUTES
--------------------------------------------------------

  CREATE TABLE "GWM_ROUTES" 
   (	"ROUTE_ID" NUMBER(10,0), 
	"ROUTE_NAME" VARCHAR2(50), 
	"ROUTE_TYPE" CHAR(1), 
	"PERSON1_ID" NUMBER(10,0), 
	"PERSON2_ID" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWM_ROUTES_WELLS
--------------------------------------------------------

  CREATE TABLE "GWM_ROUTES_WELLS" 
   (	"ROUTE_ID" NUMBER(10,0), 
	"WELL_ID" NUMBER(10,0), 
	"SEQNR" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table GWW_DATASTATUS
--------------------------------------------------------

  CREATE TABLE "GWW_DATASTATUS" 
   (	"MSID" NUMBER(10,0), 
	"DATATYPE" NUMBER(10,0), 
	"PARAMID" NUMBER(10,0), 
	"COUNT_" NUMBER(10,0), 
	"MINDATE" DATE, 
	"MAXDATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table GWW_LAYERS
--------------------------------------------------------

  CREATE TABLE "GWW_LAYERS" 
   (	"ID" NUMBER(10,0), 
	"FILENAME" NVARCHAR2(255), 
	"DIRECTORY" NVARCHAR2(255), 
	"LAYERCLASS" NUMBER(10,0), 
	"GEOTYPE" NVARCHAR2(20), 
	"DISPLAYNAME" NVARCHAR2(128), 
	"DESCRIPTION" CLOB, 
	"DEFINITION" CLOB, 
	"GWW" NCHAR(1) DEFAULT '-', 
	"GWWFILEDATE" DATE, 
	"SORTNO" NUMBER(10,0) DEFAULT 32000
   ) ;
--------------------------------------------------------
--  DDL for Table GWW_MAPS
--------------------------------------------------------

  CREATE TABLE "GWW_MAPS" 
   (	"ID" NUMBER(10,0), 
	"DISPLAYNAME" NVARCHAR2(128), 
	"NAME" NVARCHAR2(128), 
	"TITLE" NVARCHAR2(128), 
	"URL" CLOB, 
	"PROVIDERNAME" NVARCHAR2(128), 
	"PROVIDERURL" CLOB, 
	"SOURCENAME" NVARCHAR2(128), 
	"SOURCEURL" CLOB, 
	"CRS" NVARCHAR2(16), 
	"CRSNAME" NVARCHAR2(64), 
	"AVAILABLECRS" CLOB, 
	"ABSTRACT" CLOB, 
	"SERVICETYPE" NVARCHAR2(32), 
	"SERVICEVERSION" NVARCHAR2(16), 
	"JSLAYERDEF" CLOB, 
	"GWW" NCHAR(1) DEFAULT '-', 
	"GWWTRANSFERDATE" DATE, 
	"SORTNO" NUMBER(10,0) DEFAULT 32000, 
	"ISOVERLAY" NVARCHAR2(1) DEFAULT '-'
   ) ;
--------------------------------------------------------
--  DDL for Table GWW_MAPSERVICES
--------------------------------------------------------

  CREATE TABLE "GWW_MAPSERVICES" 
   (	"ID" NUMBER(10,0), 
	"NAME" NVARCHAR2(128), 
	"TITLE" NVARCHAR2(128), 
	"SERVICETYPE" NVARCHAR2(32), 
	"SERVICEVERSION" NVARCHAR2(16), 
	"DISPLAYTITLE" NVARCHAR2(128), 
	"ABSTRACT" CLOB, 
	"URL" CLOB, 
	"PROVIDERNAME" NVARCHAR2(128), 
	"PROVIDERURL" CLOB, 
	"SOURCENAME" NVARCHAR2(128), 
	"SOURCEURL" CLOB, 
	"FEES" CLOB, 
	"ACCESSCONSTRAINTS" CLOB, 
	"KEYWORDS" CLOB, 
	"CONTACT" CLOB, 
	"ATTRIBUTION" CLOB, 
	"AUTHORITYURLNAME" NVARCHAR2(64), 
	"AUTHORITYURLHREF" CLOB, 
	"IDENTIFIERAUTHORITY" NVARCHAR2(64), 
	"IDENTIFIERURL" CLOB, 
	"USERNAME" NVARCHAR2(64), 
	"USERPASSWORD" NVARCHAR2(64), 
	"SORTNO" NUMBER(10,0) DEFAULT 32000
   ) ;
--------------------------------------------------------
--  DDL for Table GWW_PROFILES
--------------------------------------------------------

  CREATE TABLE "GWW_PROFILES" 
   (	"ID" NUMBER(10,0), 
	"FILENAME" NVARCHAR2(255), 
	"DIRECTORY" NVARCHAR2(255), 
	"TYPE" NUMBER(10,0), 
	"DISPLAYNAME" NVARCHAR2(128), 
	"DESCRIPTION" CLOB, 
	"DEFINITION" CLOB, 
	"GWW" NCHAR(1) DEFAULT '-', 
	"GWWFILEDATE" DATE, 
	"SORTNO" NUMBER(10,0) DEFAULT 32000
   ) ;
--------------------------------------------------------
--  DDL for Table GWW_WEBCONFIG
--------------------------------------------------------

  CREATE TABLE "GWW_WEBCONFIG" 
   (	"ID" NUMBER(10,0), 
	"WEBAREA_ID" NUMBER(10,0), 
	"WEBORG_ID" NUMBER(10,0), 
	"WEBORG_KRZ" NVARCHAR2(20), 
	"USERNAME" NVARCHAR2(50), 
	"USERPASSWORD" NVARCHAR2(50), 
	"WEBDOMAIN" NVARCHAR2(50), 
	"PATH" NVARCHAR2(50), 
	"REQUESTSCRIPT" NVARCHAR2(50), 
	"PORT" NUMBER(10,0), 
	"SSL" NCHAR(1) DEFAULT '-', 
	"CONNECTTIMEOUT" NUMBER(10,0) DEFAULT 5, 
	"READTIMEOUT" NUMBER(10,0) DEFAULT 20, 
	"HTTP_PARAMSOK" NCHAR(1) DEFAULT '-', 
	"FTP_USER" NVARCHAR2(50), 
	"FTP_PASSWORD" NVARCHAR2(50), 
	"FTP_SERVER" NVARCHAR2(50), 
	"FTP_PATH" NVARCHAR2(50), 
	"FTP_PORT" NUMBER(10,0), 
	"FTP_SSL" NCHAR(1) DEFAULT '-', 
	"FTP_PASSIVEMODE" NCHAR(1) DEFAULT '+', 
	"FTP_CONNECTTIMEOUT" NUMBER(10,0) DEFAULT 6, 
	"FTP_READTIMEOUT" NUMBER(10,0) DEFAULT 60, 
	"FTP_PARAMSOK" NCHAR(1) DEFAULT '-', 
	"PROXY_USER" NVARCHAR2(50), 
	"PROXY_PASSWORD" NVARCHAR2(50), 
	"PROXY_SERVER" NVARCHAR2(50), 
	"PROXY_PORT" NUMBER(10,0), 
	"FTPPROXY_USER" NVARCHAR2(50), 
	"FTPPROXY_PASSWORD" NVARCHAR2(50), 
	"FTPPROXY_SERVER" NVARCHAR2(50), 
	"FTPPROXY_PORT" NUMBER(10,0), 
	"FTPPROXY_HTTP" NCHAR(1) DEFAULT '-', 
	"FTPPROXY_HTTPAUTHMETHOD" NVARCHAR2(20), 
	"USAGEFOTOS" NCHAR(1) DEFAULT '+', 
	"USAGEWELLDOCUMENTS" NCHAR(1) DEFAULT '+', 
	"USAGELEVELS" NUMBER(10,0) DEFAULT 2, 
	"USAGEANANLYSES" NUMBER(10,0) DEFAULT 2, 
	"USAGELOGGER" NUMBER(10,0) DEFAULT 2, 
	"USAGERATES" NUMBER(10,0) DEFAULT 2, 
	"USAGEPRECIPITATE" NUMBER(10,0) DEFAULT 2, 
	"USAGECLIMATE" NUMBER(10,0) DEFAULT 2, 
	"USAGEANAMEDIUMWATER" NCHAR(1) DEFAULT '+', 
	"USAGEANAMEDIUMSOLID" NCHAR(1) DEFAULT '-', 
	"USAGEANAMEDIUMELUAT" NCHAR(1) DEFAULT '-', 
	"USAGEANAMEDIUMAIR" NCHAR(1) DEFAULT '-', 
	"USAGECATEGORIES" NCHAR(1) DEFAULT '+', 
	"USAGESUBPROJECTS" NCHAR(1) DEFAULT '+', 
	"USAGESYNONYMES" NCHAR(1) DEFAULT '+', 
	"USAGEVALUEMARKERS" NCHAR(1) DEFAULT '-', 
	"USAGELEVELCOMMENTS" NCHAR(1) DEFAULT '-', 
	"USAGELAYERS" NCHAR(1) DEFAULT '+', 
	"USAGEPROFILES" NCHAR(1) DEFAULT '+', 
	"USAGEPROJECTDOCUMENT" NCHAR(1) DEFAULT '+', 
	"GWBEPSG" NVARCHAR2(16), 
	"GWBEPSGNAME" NVARCHAR2(128), 
	"GWBUTMEPSG" NVARCHAR2(16), 
	"GWBUTMEPSGNAME" NVARCHAR2(128), 
	"GWWPREFEREDEPSGTYP" NUMBER(10,0), 
	"GWWPREFEREDEPSG" NVARCHAR2(16), 
	"GWWPREFEREDEPSGNAME" NVARCHAR2(128), 
	"PREFEREDMAPID" NUMBER(10,0), 
	"PROVEVALUELISTNO" NUMBER(10,0), 
	"WARNINGVALUELISTNO" NUMBER(10,0), 
	"LOGOIMG" BLOB, 
	"LOGINLOGOIMG" BLOB, 
	"LOGOFILE" NVARCHAR2(255), 
	"LOGINLOGOFILE" NVARCHAR2(255), 
	"LOGOPOSITION" NVARCHAR2(32) DEFAULT 'legBottom', 
	"LEVELCOMMENTSHASFLAG" NCHAR(1) DEFAULT '-', 
	"LEVELBGLNEGATIVE" NCHAR(1) DEFAULT '-', 
	"LEVELCOMMENTSFLAGDEFINITION" CLOB, 
	"LEVELCOMMENTSFLAGPREVIEW" BLOB
   ) ;
--------------------------------------------------------
--  DDL for Table GWW_WELLDATACOUNTS
--------------------------------------------------------

  CREATE TABLE "GWW_WELLDATACOUNTS" 
   (	"MSID" NUMBER(10,0), 
	"COUNTLV" NUMBER(10,0), 
	"COUNTAN" NUMBER(10,0), 
	"COUNTLG" NUMBER(10,0), 
	"COUNTRT" NUMBER(10,0), 
	"COUNTRN" NUMBER(10,0), 
	"COUNTCL" NUMBER(10,0), 
	"COUNTDO" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table LOGDATA
--------------------------------------------------------

  CREATE TABLE "LOGDATA" 
   (	"MSKENNNR" VARCHAR2(20), 
	"MSID" NUMBER(10,0), 
	"LD_LOGRECID" NUMBER(10,0), 
	"LD_RECID" NUMBER(10,0), 
	"LD_DEPTH" NUMBER(10,2), 
	"LD_VALUE" NUMBER(10,2)
   ) ;
--------------------------------------------------------
--  DDL for Table LOGS
--------------------------------------------------------

  CREATE TABLE "LOGS" 
   (	"MSKENNNR" VARCHAR2(20), 
	"MSID" NUMBER(10,0), 
	"RECID" NUMBER(10,0), 
	"DATUM" DATE, 
	"ANFANG" NUMBER(10,2), 
	"ENDE" NUMBER(10,2), 
	"NOTIZ" VARCHAR2(250), 
	"METHODE_K" VARCHAR2(5), 
	"METHODE_N" VARCHAR2(100)
   ) ;
--------------------------------------------------------
--  DDL for Table REPITEMS
--------------------------------------------------------

  CREATE TABLE "REPITEMS" 
   (	"ID" NUMBER(10,0), 
	"REPORTTYPE" NUMBER(10,0), 
	"NAME" VARCHAR2(50), 
	"TEMPLATE" BLOB, 
	"PROJECT" VARCHAR2(50)
   ) ;
--------------------------------------------------------
--  DDL for Table RST_APPCONFIG
--------------------------------------------------------

  CREATE TABLE "RST_APPCONFIG" 
   (	"MANDANT_ID" NUMBER(10,0), 
	"MODULE_ID" NVARCHAR2(16), 
	"KEY_" NVARCHAR2(100), 
	"VALUE_I" NUMBER(10,0), 
	"VALUE_F" BINARY_DOUBLE, 
	"VALUE_S" CLOB, 
	"VALUE_DT" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table RST_DBVERSION
--------------------------------------------------------

  CREATE TABLE "RST_DBVERSION" 
   (	"MANDANT_ID" NUMBER(10,0), 
	"MODULE_ID" NVARCHAR2(32), 
	"VERSION" NUMBER(10,0)
   ) ;
--------------------------------------------------------
--  DDL for Table RST_SYNCHRONIZE
--------------------------------------------------------

  CREATE TABLE "RST_SYNCHRONIZE" 
   (	"MANDANT_ID" NUMBER(10,0), 
	"MODULE_ID" NVARCHAR2(16), 
	"ACTION_" NVARCHAR2(32), 
	"SESSIONGUID" NVARCHAR2(70), 
	"TIMESTAMP_" DATE, 
	"VALUE_I" NUMBER(10,0), 
	"VALUE_S" NVARCHAR2(255)
   ) ;
--------------------------------------------------------
--  DDL for Index GPD_ABWEICHUNGEN_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_ABWEICHUNGEN_PK" ON "GPD_ABWEICHUNGEN" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_ASBBOHRLOCH_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_ASBBOHRLOCH_PK" ON "GPD_ASBBOHRLOCH" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_ASBFILTER_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_ASBFILTER_PK" ON "GPD_ASBFILTER" ("MSID", "AFI_ROHRRECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_ASBSONDERBAU_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_ASBSONDERBAU_PK" ON "GPD_ASBSONDERBAU" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_ASBVERFUELLUNG_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_ASBVERFUELLUNG_PK" ON "GPD_ASBVERFUELLUNG" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_ASBVERROHRUNG_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_ASBVERROHRUNG_PK" ON "GPD_ASBVERROHRUNG" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_HYDROPARAM_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_HYDROPARAM_PK" ON "GPD_HYDROPARAM" ("MSID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_KLUEFTE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_KLUEFTE_PK" ON "GPD_KLUEFTE" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_LOGDATA_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_LOGDATA_PK" ON "GPD_LOGDATA" ("MSID", "LD_LOGRECID", "LD_RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_LOG_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_LOG_PK" ON "GPD_LOG" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_MSPASSCONFIG_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_MSPASSCONFIG_PK" ON "GPD_MSPASSCONFIG" ("MSID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_MSSTAMM_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_MSSTAMM_PK" ON "GPD_MSSTAMM" ("MSID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_MSSYNONYME_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_MSSYNONYME_PK" ON "GPD_MSSYNONYME" ("MSID", "MSSYN_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_PACKERTEST_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_PACKERTEST_PK" ON "GPD_PACKERTEST" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_PLFIRMA_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_PLFIRMA_PK" ON "GPD_PLFIRMA" ("PLF_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_PLPERSON_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_PLPERSON_PK" ON "GPD_PLPERSON" ("PLP_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_PLSTANDARD_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_PLSTANDARD_PK" ON "GPD_PLSTANDARD" ("PLS_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_SCHICHTEN_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_SCHICHTEN_PK" ON "GPD_SCHICHTEN" ("MSID", "SD_LAYERID", "SD_INTVERSION", "SD_LAYERCNTR") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_SCHICHTTITEL_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_SCHICHTTITEL_PK" ON "GPD_SCHICHTTITEL" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_SPUELUNG_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_SPUELUNG_PK" ON "GPD_SPUELUNG" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_STRATIGRAPHIE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_STRATIGRAPHIE_PK" ON "GPD_STRATIGRAPHIE" ("STRT_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_STRATLISTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_STRATLISTS_PK" ON "GPD_STRATLISTS" ("SLST_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_SYNONYMKAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_SYNONYMKAT_PK" ON "GPD_SYNONYMKAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_TEMPAUSBAU_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_TEMPAUSBAU_PK" ON "GPD_TEMPAUSBAU" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_TEMPSCHICHTEN_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_TEMPSCHICHTEN_PK" ON "GPD_TEMPSCHICHTEN" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_WASSERRECHT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_WASSERRECHT_PK" ON "GPD_WASSERRECHT" ("MSID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_ANALYMETHODS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_ANALYMETHODS_PK" ON "GWB_ANALYMETHODS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_ANALYSEN_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_ANALYSEN_PK" ON "GWB_ANALYSEN" ("DATUMID", "PARAMETERID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_BERICHTE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_BERICHTE_PK" ON "GWB_BERICHTE" ("BERICHTSNR") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_BETREIB_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_BETREIB_PK" ON "GWB_BETREIB" ("BETREIBER") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_BOHRFIRM_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_BOHRFIRM_PK" ON "GWB_BOHRFIRM" ("BOHRFIRMA") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_BOHRVERF_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_BOHRVERF_PK" ON "GWB_BOHRVERF" ("BOHRVERFAHREN") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_BUILDIGMATERIALCAT_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_BUILDIGMATERIALCAT_IDX1" ON "GWB_BUILDINGMATERIALCAT" ("ITEMNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_BUILDINGMATERIALCAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_BUILDINGMATERIALCAT_PK" ON "GWB_BUILDINGMATERIALCAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_CATCHMENTAREA_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_CATCHMENTAREA_IDX1" ON "GWB_CATCHMENTAREAS" ("AREANAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_CHANGELOGGER_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_CHANGELOGGER_PK" ON "GWB_CHANGELOGGER" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_CHECKRULES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_CHECKRULES_PK" ON "GWB_CHECKRULES" ("CR_WELLID", "CR_PARAMID", "CR_RULETYPE", "CR_CHECKVALUE", "CR_VALIDFROM", "CR_VALIDUNTIL") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_CHECKRULES2_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_CHECKRULES2_PK" ON "GWB_CHECKRULES2" ("CR_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_CLASS_PARAM_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_CLASS_PARAM_IDX1" ON "GWB_CLASS_PARAM" ("CLASS_ID", "PARAM_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_DEPTHS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_DEPTHS_PK" ON "GWM_DEPTHS" ("WELL_ID", "DEPTH") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_DISCHARGESTATISTIC_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_DISCHARGESTATISTIC_PK" ON "GWB_DISCHARGESTATISTIC" ("WELL_ID", "STATYEAR") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_DOCCATEGORIES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_DOCCATEGORIES_PK" ON "GWB_DOCCATEGORIES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_DOCTYPES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_DOCTYPES_PK" ON "GWB_DOCTYPES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_EINHEIT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_EINHEIT_PK" ON "GWB_EINHEIT" ("EINHEIT") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_ELEVATIONQUALITY_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_ELEVATIONQUALITY_PK" ON "GWB_ELEVATIONQUALITY" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_FIELDCHECKS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_FIELDCHECKS_PK" ON "GWB_FIELDCHECKS" ("TNAME", "FNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_FLOWMEASUREMENTCAT_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_FLOWMEASUREMENTCAT_IDX1" ON "GWB_FLOWMEASUREMENTCAT" ("ITEMNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_FLOWMEASUREMENTCAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_FLOWMEASUREMENTCAT_PK" ON "GWB_FLOWMEASUREMENTCAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_GEOLOGIE_IDX1
--------------------------------------------------------

  CREATE INDEX "GWB_GEOLOGIE_IDX1" ON "GWB_GEOLOGIE" ("GEOLOGISCHEEINHEIT") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_GEOLOGIE_IDX2
--------------------------------------------------------

  CREATE INDEX "GWB_GEOLOGIE_IDX2" ON "GWB_GEOLOGIE" ("SEQNR") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_GEOLOGIE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_GEOLOGIE_PK" ON "GWB_GEOLOGIE" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_GERAETE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_GERAETE_PK" ON "GWB_GERAETE" ("PROBENNAHMEGERAET") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_GRAPHICS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_GRAPHICS_PK" ON "GWB_GRAPHICS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_GWSTOCKW_IDX1
--------------------------------------------------------

  CREATE INDEX "GWB_GWSTOCKW_IDX1" ON "GWB_GWSTOCKW" ("GRUNDWASSERSTOCKWERK") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_GWSTOCKW_IDX2
--------------------------------------------------------

  CREATE INDEX "GWB_GWSTOCKW_IDX2" ON "GWB_GWSTOCKW" ("SEQNR") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_GWSTOCKW_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_GWSTOCKW_PK" ON "GWB_GWSTOCKW" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_HCHANGE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_HCHANGE_PK" ON "GWB_HCHANGE" ("MESSTELLENID", "DATUMAENDERUNG") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_IMPORT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_IMPORT_PK" ON "GWB_IMPORTS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_INOUTLETSTRUCTURE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_INOUTLETSTRUCTURE_PK" ON "GWB_INOUTLETSTRUCTURE" ("OBJECT_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_KEYWORD_OBJECTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_KEYWORD_OBJECTS_PK" ON "GWB_KEYWORD_OBJECTS" ("KEYWORD_ID", "OBJECT_ID", "OBJECT_TYPE") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_KEYWORDS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_KEYWORDS_PK" ON "GWB_KEYWORDS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_LABORS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_LABORS_PK" ON "GWB_LABORS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_LEVEL_ATTRIBUTES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_LEVEL_ATTRIBUTES_PK" ON "GWB_LEVEL_ATTRIBUTES" ("LA_DATE_ID", "LA_ATTRIBUTE_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_LEVELCOMMENTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_LEVELCOMMENTS_PK" ON "GWB_LEVELCOMMENTS" ("COMMENTID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_LOGINS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_LOGINS_PK" ON "GWB_LOGINS" ("USER_ID", "LOGINTIME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MANHOLE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_MANHOLE_PK" ON "GWB_MANHOLE" ("OBJECT_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MAPS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_MAPS_PK" ON "GWB_MAPS" ("MAPCOMMENT") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MAPS_PROJECTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_MAPS_PROJECTS_PK" ON "GWB_MAPS_PROJECTS" ("MAP_ID", "PROJECT_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MEASDATE_IDX1
--------------------------------------------------------

  CREATE INDEX "GWB_MEASDATE_IDX1" ON "GWB_MEASDATE" ("MESSTELLENID", "MESSDATUM") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MEASDATE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_MEASDATE_PK" ON "GWB_MEASDATE" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MEMOS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_MEMOS_PK" ON "GWB_MEMOS" ("WELL_ID", "MEMOTYPE", "DATE_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MISCSTRUCTURE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_MISCSTRUCTURE_PK" ON "GWB_MISCSTRUCTURE" ("OBJECT_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MSART_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_MSART_PK" ON "GWB_MSART" ("MSART") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MSSTAMM_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_MSSTAMM_IDX1" ON "GWB_MSSTAMM" ("KENNNR") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MSSTAMM_IDX2
--------------------------------------------------------

  CREATE INDEX "GWB_MSSTAMM_IDX2" ON "GWB_MSSTAMM" ("KENNNR2") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MSSTAMM_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_MSSTAMM_PK" ON "GWB_MSSTAMM" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_NUTZUNG_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_NUTZUNG_PK" ON "GWB_NUTZUNG" ("NUTZUNG") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_OBJECT_PIPES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_OBJECT_PIPES_PK" ON "GWB_OBJECT_PIPES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_OBJECT_TECHPARTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_OBJECT_TECHPARTS_PK" ON "GWB_OBJECT_TECHPARTS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PARAMET_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PARAMET_IDX1" ON "GWB_PARAMET" ("PARAMETERKUERZEL") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PARAMET_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PARAMET_PK" ON "GWB_PARAMET" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PARAMLISTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PARAMLISTS_PK" ON "GWB_PARAMLISTS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PARAM_VALUECLASSES_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PARAM_VALUECLASSES_IDX1" ON "GWB_PARAM_VALUECLASSES" ("PARAM_ID", "MEDIUM", "CLASSVALUE") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PARAM_VALUECLASSES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PARAM_VALUECLASSES_PK" ON "GWB_PARAM_VALUECLASSES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PERSONS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PERSONS_PK" ON "GWM_PERSONS" ("PERSON_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PIPEMATERIALCAT_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PIPEMATERIALCAT_IDX1" ON "GWB_PIPEMATERIALCAT" ("ITEMNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PIPEMATERIALCAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PIPEMATERIALCAT_PK" ON "GWB_PIPEMATERIALCAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PIPES_IX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PIPES_IX1" ON "GWB_PIPES" ("PIPENAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PIPES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PIPES_PK" ON "GWB_PIPES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PIPETYPECAT_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PIPETYPECAT_IDX1" ON "GWB_PIPETYPECAT" ("ITEMNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PIPETYPECAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PIPETYPECAT_PK" ON "GWB_PIPETYPECAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PROBEN_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PROBEN_PK" ON "GWB_PROBEN" ("DATUMID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PROGGROUPS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PROGGROUPS_PK" ON "GWB_PROGGROUPS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PROGGROUPS_PROGS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PROGGROUPS_PROGS_PK" ON "GWB_PROGGROUPS_PROGS" ("GROUP_ID", "PROG_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PROGPARAM_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PROGPARAM_PK" ON "GWB_PROG_PARAM" ("PROG_ID", "SEQNR", "PARAM_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PROJECTS_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PROJECTS_IDX1" ON "GWB_PROJECTS" ("PROJECTDESCR") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PROJECTS_IDX2
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PROJECTS_IDX2" ON "GWB_PROJECTS" ("PROJECTDESCR", "OWNER_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PROJECTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PROJECTS_PK" ON "GWB_PROJECTS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PROJECTSUSERS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PROJECTSUSERS_PK" ON "GWB_PROJECTS_USERS" ("PU_PROJECTID", "PU_LOGINNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PUMP_DATA_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PUMP_DATA_PK" ON "GWB_PUMP_DATA" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PUMPEN_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PUMPEN_PK" ON "GWB_PUMPEN" ("PUMPENTYP") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_RAINFALL_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_RAINFALL_PK" ON "GWB_RAINFALL" ("WELL_ID", "DATE1") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_RATES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_RATES_PK" ON "GWB_RATES" ("MESSTELLENID", "DATUM1") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_REPORTGROUPS_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_REPORTGROUPS_IDX1" ON "GWB_REPORTGROUPS" ("GROUPNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_REPORTGROUPS_PARAMGROUPS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_REPORTGROUPS_PARAMGROUPS_PK" ON "GWB_REPORTGROUPS_PARAMGROUPS" ("GROUP_ID", "PARAMGROUP_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_REPORTGROUPS_PARAMS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_REPORTGROUPS_PARAMS_PK" ON "GWB_REPORTGROUPS_PARAMS" ("GROUP_ID", "PARAM_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_REPORTGROUPS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_REPORTGROUPS_PK" ON "GWB_REPORTGROUPS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_REPORTGROUPS_STATIONS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_REPORTGROUPS_STATIONS_PK" ON "GWB_REPORTGROUPS_STATIONS" ("GROUP_ID", "STATION_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_REPORTGROUPS_TEMPLATES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_REPORTGROUPS_TEMPLATES_PK" ON "GWB_REPORTGROUPS_TEMPLATES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_ROUTES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_ROUTES_PK" ON "GWM_ROUTES" ("ROUTE_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_ROUTES_WELLS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_ROUTES_WELLS_PK" ON "GWM_ROUTES_WELLS" ("ROUTE_ID", "WELL_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SAMPLECALEDAR_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SAMPLECALEDAR_PK" ON "GWB_SAMPLECALENDAR" ("SAMPLEDATE", "WELL_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SAMPLECOLOR_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SAMPLECOLOR_PK" ON "GWB_SAMPLECOLOR" ("COLOR") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SAMPLEMATERIAL_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SAMPLEMATERIAL_PK" ON "GWB_SAMPLEMATERIAL" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SAMPLESEDIMENT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SAMPLESEDIMENT_PK" ON "GWB_SAMPLESEDIMENT" ("SEDIMENT") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SAMPLESMELL_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SAMPLESMELL_PK" ON "GWB_SAMPLESMELL" ("SMELL") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SAMPLESPROGS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SAMPLESPROGS_PK" ON "GWB_SAMPLES_PROGS" ("SAMPLE_ID", "PROG_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SAMPLETURBIDITY_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SAMPLETURBIDITY_PK" ON "GWB_SAMPLETURBIDITY" ("TURBIDITY") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SAMPLETYPE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SAMPLETYPE_PK" ON "GWB_SAMPLETYPE" ("SAMPLETYPE") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SAMPLEWEATHER_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SAMPLEWEATHER_PK" ON "GWB_SAMPLEWEATHER" ("WEATHER") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SAMPLINGREASONS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SAMPLINGREASONS_PK" ON "GWB_SAMPLINGREASONS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SELECTIONS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SELECTIONS_PK" ON "GWB_SELECTIONS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SENSORDEPTH_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SENSORDEPTH_PK" ON "GWB_SENSORDEPTH" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SITEOWNERS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SITEOWNERS_PK" ON "GWB_SITEOWNERS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SPEC_YIELD_IX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SPEC_YIELD_IX1" ON "GWB_SPEC_YIELD" ("WELL_ID", "MDATE") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SPEC_YIELD_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SPEC_YIELD_PK" ON "GWB_SPEC_YIELD" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SPPOINTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SPPOINTS_PK" ON "GWB_STRUCTPARTS_POINTS" ("STRUCTPART_ID", "POINT_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SQLRECHERCHE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SQLRECHERCHE_PK" ON "GWB_SQLRECHERCHE" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SRNETAQUI_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SRNETAQUI_PK" ON "GWB_STOREDRIVERNET_AQUIFERS" ("STOREDRIVERNET_ID", "AQUIFER_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SRNET_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SRNET_PK" ON "GWB_STOREDRIVERNETS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SRNETPNTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SRNETPNTS_PK" ON "GWB_STOREDRIVERNET_POINTS" ("STOREDRIVERNET_ID", "SEQNR") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_STATIONREPORTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_STATIONREPORTS_PK" ON "GWB_STATIONREPORTS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_STNFLOWDEVICEHISTORY_IX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_STNFLOWDEVICEHISTORY_IX1" ON "GWB_STNFLOWDEVICEHISTORY" ("FLOWDEVICE_ID", "FLOWDEVICEDATE") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_STNFLOWDEVICEHISTORY_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_STNFLOWDEVICEHISTORY_PK" ON "GWB_STNFLOWDEVICEHISTORY" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_STOFFKL_IDX1
--------------------------------------------------------

  CREATE INDEX "GWB_STOFFKL_IDX1" ON "GWB_STOFFKL" ("NAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_STOFFKL_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_STOFFKL_PK" ON "GWB_STOFFKL" ("CLASS_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_STREETCAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_STREETCAT_PK" ON "GWB_STREETCAT" ("STREETKEY") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_STRUCTPARTAQUI_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_STRUCTPARTAQUI_PK" ON "GWB_STRUCTPARTS_AQUIFERS" ("STRUCTPART_ID", "AQUIFER_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_STRUCTPARTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_STRUCTPARTS_PK" ON "GWB_STRUCTPARTS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_STRUCTPOINTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_STRUCTPOINTS_PK" ON "GWB_STRUCTPOINTS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_STRUCTURES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_STRUCTURES_PK" ON "GWB_STRUCTURES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SURFACEWATERPARTS_IDX2
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SURFACEWATERPARTS_IDX2" ON "GWB_SURFACEWATER_PARTS" ("MAIN_ID", "ITEMNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SURFACEWATER_PARTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SURFACEWATER_PARTS_PK" ON "GWB_SURFACEWATER_PARTS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SURFACEWATERS_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SURFACEWATERS_IDX1" ON "GWB_SURFACEWATERS" ("ITEMNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SURFACEWATERS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SURFACEWATERS_PK" ON "GWB_SURFACEWATERS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SYMBOLSCATEGORIES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SYMBOLSCATEGORIES_PK" ON "GWB_SYMBOLSCATEGORIES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SYMBOLS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SYMBOLS_PK" ON "GWB_SYMBOLS" ("SYMBOLID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TASTE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TASTE_PK" ON "GWB_TASTE" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHEQUIP_HISTORY_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHEQUIP_HISTORY_PK" ON "GWB_TECHEQUIP_HISTORY" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHEQUIP_MANUFACTURERCAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHEQUIP_MANUFACTURERCAT_PK" ON "GWB_TECHEQUIP_MANUFACTURERCAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHEQUIPMENT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHEQUIPMENT_PK" ON "GWB_TECHEQUIPMENT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHEQUIP_REPAIRS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHEQUIP_REPAIRS_PK" ON "GWB_TECHEQUIP_REPAIRS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHEQUIP_STORES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHEQUIP_STORES_PK" ON "GWB_TECHEQUIP_STORES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHEQUIP_TYPECAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHEQUIP_TYPECAT_PK" ON "GWB_TECHEQUIP_TYPECAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHEQUIP_WELLS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHEQUIP_WELLS_PK" ON "GWB_TECHEQUIP_WELLS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHPARTSCAT_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHPARTSCAT_IDX1" ON "GWB_TECHPARTSCAT" ("ITEMNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHPARTSCAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHPARTSCAT_PK" ON "GWB_TECHPARTSCAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHPARTSCLASSCAT_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHPARTSCLASSCAT_IDX1" ON "GWB_TECHPARTSCLASSCAT" ("ITEMNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHPARTSCLASSCAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHPARTSCLASSCAT_PK" ON "GWB_TECHPARTSCLASSCAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TODOCATEGORIES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TODOCATEGORIES_PK" ON "GWB_TODOCATEGORIES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TOPOGRAF_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TOPOGRAF_PK" ON "GWB_TOPOGRAF" ("PROJECT_ID", "RECHTSWERT", "HOCHWERT") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_UKAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_UKAT_PK" ON "GWB_UKAT" ("KATALOGNR") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_UMRECH_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_UMRECH_PK" ON "GWB_UMRECH" ("EINHEIT1", "EINHEIT2") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_USERS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_USERS_PK" ON "GWB_USERS" ("US_LOGINNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_VALUEMARKERS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_VALUEMARKERS_PK" ON "GWB_VALUEMARKERS" ("MARKER") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_VALVEPOSITION_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_VALVEPOSITION_PK" ON "GWB_VALVEPOSITION" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_VALVES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_VALVES_PK" ON "GWB_VALVES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_VALVETYPECAT_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_VALVETYPECAT_IDX1" ON "GWB_VALVETYPECAT" ("ITEMNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_VALVETYPECAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_VALVETYPECAT_PK" ON "GWB_VALVETYPECAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_VIRTUALWELLS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_VIRTUALWELLS_PK" ON "GWB_VIRTUALWELLS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WATERTYPECAT_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WATERTYPECAT_IDX1" ON "GWB_WATERTYPECAT" ("ITEMNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WATERTYPECAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WATERTYPECAT_PK" ON "GWB_WATERTYPECAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLGEOLOGY_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLGEOLOGY_PK" ON "GWB_WELLGEOLOGY" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLPROPERTIES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLPROPERTIES_PK" ON "GWB_WELLPROPERTIES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLPROPERTIES_VALUES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLPROPERTIES_VALUES_PK" ON "GWB_WELLPROPERTIES_VALUES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLPROPS__WELLS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLPROPS__WELLS_PK" ON "GWB_WELLPROPERTIES_WELLS" ("PROPERTY_ID", "WELL_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLPUMPRATES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLPUMPRATES_PK" ON "GWB_WELLPUMPRATES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLS_PROJECTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLS_PROJECTS_PK" ON "GWB_WELLS_PROJECTS" ("WELL_ID", "PROJECT_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLSTATUSCAT_IX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLSTATUSCAT_IX1" ON "GWB_WELLSTATUSCAT" ("STATUSNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLSTATUSCAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLSTATUSCAT_PK" ON "GWB_WELLSTATUSCAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLSTATUSHISTORY_IX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLSTATUSHISTORY_IX1" ON "GWB_WELLSTATUSHISTORY" ("WELL_ID", "STATUSDATE") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLSTATUSHISTORY_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLSTATUSHISTORY_PK" ON "GWB_WELLSTATUSHISTORY" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLSTDTODOCATEGORIES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLSTDTODOCATEGORIES_PK" ON "GWB_WELLSTDTODOCATEGORIES" ("WELL_ID", "CATEGORY_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLTODOLIST_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLTODOLIST_PK" ON "GWB_WELLTODOLIST" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WSTAND_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WSTAND_IDX1" ON "GWB_WSTAND" ("MESSTELLENID", "DATUMZEIT") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WSTAND_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WSTAND_PK" ON "GWB_WSTAND" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWM_PICTURECATEGORIESCAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWM_PICTURECATEGORIESCAT_PK" ON "GWM_PICTURECATEGORIESCAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index IX_MEASDATE_LOGGER
--------------------------------------------------------

  CREATE INDEX "IX_MEASDATE_LOGGER" ON "GWB_MEASDATE" ("LOGGER", "MESSTELLENID", "MESSDATUM") 
  ;
--------------------------------------------------------
--  DDL for Index PK_GWB_OBJECTTYPES
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_GWB_OBJECTTYPES" ON "GWB_OBJECTTYPES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_GWC_WELLCATEGORIES
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_GWC_WELLCATEGORIES" ON "GWC_WELLCATEGORIES" ("TYPE_ID", "CATEGORY_ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_GWC_WELLCATEGORY_TYPES
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_GWC_WELLCATEGORY_TYPES" ON "GWC_WELLCATEGORY_TYPES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_GWW_DATASTATUS
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_GWW_DATASTATUS" ON "GWW_DATASTATUS" ("MSID", "DATATYPE", "PARAMID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_GWW_LAYERS
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_GWW_LAYERS" ON "GWW_LAYERS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_GWW_MAPS
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_GWW_MAPS" ON "GWW_MAPS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_GWW_MAPSERVICES
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_GWW_MAPSERVICES" ON "GWW_MAPSERVICES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_GWW_PROFILES
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_GWW_PROFILES" ON "GWW_PROFILES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_GWW_WEBCONFIG
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_GWW_WEBCONFIG" ON "GWW_WEBCONFIG" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_GWW_WELLDATACOUNTS
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_GWW_WELLDATACOUNTS" ON "GWW_WELLDATACOUNTS" ("MSID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_RST_APPCONFIG
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_RST_APPCONFIG" ON "RST_APPCONFIG" ("MANDANT_ID", "MODULE_ID", "KEY_") 
  ;
--------------------------------------------------------
--  DDL for Index PK_RST_DBVERSION
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_RST_DBVERSION" ON "RST_DBVERSION" ("MANDANT_ID", "MODULE_ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_RST_SYNCHRONIZE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_RST_SYNCHRONIZE" ON "RST_SYNCHRONIZE" ("MANDANT_ID", "MODULE_ID", "ACTION_") 
  ;
--------------------------------------------------------
--  DDL for Index REPITEMS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "REPITEMS_PK" ON "REPITEMS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_ABWEICHUNGEN_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_ABWEICHUNGEN_PK" ON "GPD_ABWEICHUNGEN" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_ASBBOHRLOCH_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_ASBBOHRLOCH_PK" ON "GPD_ASBBOHRLOCH" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_ASBFILTER_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_ASBFILTER_PK" ON "GPD_ASBFILTER" ("MSID", "AFI_ROHRRECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_ASBSONDERBAU_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_ASBSONDERBAU_PK" ON "GPD_ASBSONDERBAU" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_ASBVERFUELLUNG_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_ASBVERFUELLUNG_PK" ON "GPD_ASBVERFUELLUNG" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_ASBVERROHRUNG_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_ASBVERROHRUNG_PK" ON "GPD_ASBVERROHRUNG" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_HYDROPARAM_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_HYDROPARAM_PK" ON "GPD_HYDROPARAM" ("MSID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_KLUEFTE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_KLUEFTE_PK" ON "GPD_KLUEFTE" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_LOG_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_LOG_PK" ON "GPD_LOG" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_LOGDATA_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_LOGDATA_PK" ON "GPD_LOGDATA" ("MSID", "LD_LOGRECID", "LD_RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_MSPASSCONFIG_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_MSPASSCONFIG_PK" ON "GPD_MSPASSCONFIG" ("MSID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_MSSTAMM_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_MSSTAMM_PK" ON "GPD_MSSTAMM" ("MSID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_MSSYNONYME_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_MSSYNONYME_PK" ON "GPD_MSSYNONYME" ("MSID", "MSSYN_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_PACKERTEST_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_PACKERTEST_PK" ON "GPD_PACKERTEST" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_PLFIRMA_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_PLFIRMA_PK" ON "GPD_PLFIRMA" ("PLF_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_PLPERSON_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_PLPERSON_PK" ON "GPD_PLPERSON" ("PLP_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_PLSTANDARD_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_PLSTANDARD_PK" ON "GPD_PLSTANDARD" ("PLS_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_SCHICHTEN_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_SCHICHTEN_PK" ON "GPD_SCHICHTEN" ("MSID", "SD_LAYERID", "SD_INTVERSION", "SD_LAYERCNTR") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_SCHICHTTITEL_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_SCHICHTTITEL_PK" ON "GPD_SCHICHTTITEL" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_SPUELUNG_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_SPUELUNG_PK" ON "GPD_SPUELUNG" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_STRATIGRAPHIE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_STRATIGRAPHIE_PK" ON "GPD_STRATIGRAPHIE" ("STRT_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_STRATLISTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_STRATLISTS_PK" ON "GPD_STRATLISTS" ("SLST_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_SYNONYMKAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_SYNONYMKAT_PK" ON "GPD_SYNONYMKAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_TEMPAUSBAU_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_TEMPAUSBAU_PK" ON "GPD_TEMPAUSBAU" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_TEMPSCHICHTEN_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_TEMPSCHICHTEN_PK" ON "GPD_TEMPSCHICHTEN" ("MSID", "RECID") 
  ;
--------------------------------------------------------
--  DDL for Index GPD_WASSERRECHT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GPD_WASSERRECHT_PK" ON "GPD_WASSERRECHT" ("MSID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_ANALYMETHODS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_ANALYMETHODS_PK" ON "GWB_ANALYMETHODS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_ANALYSEN_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_ANALYSEN_PK" ON "GWB_ANALYSEN" ("DATUMID", "PARAMETERID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_BERICHTE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_BERICHTE_PK" ON "GWB_BERICHTE" ("BERICHTSNR") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_BETREIB_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_BETREIB_PK" ON "GWB_BETREIB" ("BETREIBER") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_BOHRFIRM_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_BOHRFIRM_PK" ON "GWB_BOHRFIRM" ("BOHRFIRMA") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_BOHRVERF_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_BOHRVERF_PK" ON "GWB_BOHRVERF" ("BOHRVERFAHREN") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_BUILDIGMATERIALCAT_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_BUILDIGMATERIALCAT_IDX1" ON "GWB_BUILDINGMATERIALCAT" ("ITEMNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_BUILDINGMATERIALCAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_BUILDINGMATERIALCAT_PK" ON "GWB_BUILDINGMATERIALCAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_CATCHMENTAREA_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_CATCHMENTAREA_IDX1" ON "GWB_CATCHMENTAREAS" ("AREANAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_CHANGELOGGER_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_CHANGELOGGER_PK" ON "GWB_CHANGELOGGER" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_CHECKRULES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_CHECKRULES_PK" ON "GWB_CHECKRULES" ("CR_WELLID", "CR_PARAMID", "CR_RULETYPE", "CR_CHECKVALUE", "CR_VALIDFROM", "CR_VALIDUNTIL") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_CHECKRULES2_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_CHECKRULES2_PK" ON "GWB_CHECKRULES2" ("CR_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_CLASS_PARAM_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_CLASS_PARAM_IDX1" ON "GWB_CLASS_PARAM" ("CLASS_ID", "PARAM_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_DISCHARGESTATISTIC_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_DISCHARGESTATISTIC_PK" ON "GWB_DISCHARGESTATISTIC" ("WELL_ID", "STATYEAR") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_DOCCATEGORIES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_DOCCATEGORIES_PK" ON "GWB_DOCCATEGORIES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_DOCTYPES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_DOCTYPES_PK" ON "GWB_DOCTYPES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_EINHEIT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_EINHEIT_PK" ON "GWB_EINHEIT" ("EINHEIT") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_ELEVATIONQUALITY_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_ELEVATIONQUALITY_PK" ON "GWB_ELEVATIONQUALITY" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_FIELDCHECKS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_FIELDCHECKS_PK" ON "GWB_FIELDCHECKS" ("TNAME", "FNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_FLOWMEASUREMENTCAT_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_FLOWMEASUREMENTCAT_IDX1" ON "GWB_FLOWMEASUREMENTCAT" ("ITEMNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_FLOWMEASUREMENTCAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_FLOWMEASUREMENTCAT_PK" ON "GWB_FLOWMEASUREMENTCAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_GEOLOGIE_IDX1
--------------------------------------------------------

  CREATE INDEX "GWB_GEOLOGIE_IDX1" ON "GWB_GEOLOGIE" ("GEOLOGISCHEEINHEIT") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_GEOLOGIE_IDX2
--------------------------------------------------------

  CREATE INDEX "GWB_GEOLOGIE_IDX2" ON "GWB_GEOLOGIE" ("SEQNR") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_GEOLOGIE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_GEOLOGIE_PK" ON "GWB_GEOLOGIE" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_GERAETE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_GERAETE_PK" ON "GWB_GERAETE" ("PROBENNAHMEGERAET") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_GRAPHICS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_GRAPHICS_PK" ON "GWB_GRAPHICS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_GWSTOCKW_IDX1
--------------------------------------------------------

  CREATE INDEX "GWB_GWSTOCKW_IDX1" ON "GWB_GWSTOCKW" ("GRUNDWASSERSTOCKWERK") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_GWSTOCKW_IDX2
--------------------------------------------------------

  CREATE INDEX "GWB_GWSTOCKW_IDX2" ON "GWB_GWSTOCKW" ("SEQNR") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_GWSTOCKW_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_GWSTOCKW_PK" ON "GWB_GWSTOCKW" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_HCHANGE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_HCHANGE_PK" ON "GWB_HCHANGE" ("MESSTELLENID", "DATUMAENDERUNG") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_IMPORT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_IMPORT_PK" ON "GWB_IMPORTS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_INOUTLETSTRUCTURE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_INOUTLETSTRUCTURE_PK" ON "GWB_INOUTLETSTRUCTURE" ("OBJECT_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_KEYWORD_OBJECTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_KEYWORD_OBJECTS_PK" ON "GWB_KEYWORD_OBJECTS" ("KEYWORD_ID", "OBJECT_ID", "OBJECT_TYPE") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_KEYWORDS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_KEYWORDS_PK" ON "GWB_KEYWORDS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_LABORS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_LABORS_PK" ON "GWB_LABORS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_LEVEL_ATTRIBUTES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_LEVEL_ATTRIBUTES_PK" ON "GWB_LEVEL_ATTRIBUTES" ("LA_DATE_ID", "LA_ATTRIBUTE_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_LEVELCOMMENTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_LEVELCOMMENTS_PK" ON "GWB_LEVELCOMMENTS" ("COMMENTID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_LOGINS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_LOGINS_PK" ON "GWB_LOGINS" ("USER_ID", "LOGINTIME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MANHOLE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_MANHOLE_PK" ON "GWB_MANHOLE" ("OBJECT_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MAPS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_MAPS_PK" ON "GWB_MAPS" ("MAPCOMMENT") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MAPS_PROJECTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_MAPS_PROJECTS_PK" ON "GWB_MAPS_PROJECTS" ("MAP_ID", "PROJECT_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MEASDATE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_MEASDATE_PK" ON "GWB_MEASDATE" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MEASDATE_IDX1
--------------------------------------------------------

  CREATE INDEX "GWB_MEASDATE_IDX1" ON "GWB_MEASDATE" ("MESSTELLENID", "MESSDATUM") 
  ;
--------------------------------------------------------
--  DDL for Index IX_MEASDATE_LOGGER
--------------------------------------------------------

  CREATE INDEX "IX_MEASDATE_LOGGER" ON "GWB_MEASDATE" ("LOGGER", "MESSTELLENID", "MESSDATUM") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MEMOS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_MEMOS_PK" ON "GWB_MEMOS" ("WELL_ID", "MEMOTYPE", "DATE_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MISCSTRUCTURE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_MISCSTRUCTURE_PK" ON "GWB_MISCSTRUCTURE" ("OBJECT_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MSART_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_MSART_PK" ON "GWB_MSART" ("MSART") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MSSTAMM_IDX2
--------------------------------------------------------

  CREATE INDEX "GWB_MSSTAMM_IDX2" ON "GWB_MSSTAMM" ("KENNNR2") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MSSTAMM_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_MSSTAMM_IDX1" ON "GWB_MSSTAMM" ("KENNNR") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_MSSTAMM_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_MSSTAMM_PK" ON "GWB_MSSTAMM" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_NUTZUNG_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_NUTZUNG_PK" ON "GWB_NUTZUNG" ("NUTZUNG") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_OBJECT_PIPES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_OBJECT_PIPES_PK" ON "GWB_OBJECT_PIPES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_OBJECT_TECHPARTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_OBJECT_TECHPARTS_PK" ON "GWB_OBJECT_TECHPARTS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_GWB_OBJECTTYPES
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_GWB_OBJECTTYPES" ON "GWB_OBJECTTYPES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PARAMET_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PARAMET_IDX1" ON "GWB_PARAMET" ("PARAMETERKUERZEL") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PARAMET_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PARAMET_PK" ON "GWB_PARAMET" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PARAMLISTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PARAMLISTS_PK" ON "GWB_PARAMLISTS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PARAM_VALUECLASSES_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PARAM_VALUECLASSES_IDX1" ON "GWB_PARAM_VALUECLASSES" ("PARAM_ID", "MEDIUM", "CLASSVALUE") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PARAM_VALUECLASSES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PARAM_VALUECLASSES_PK" ON "GWB_PARAM_VALUECLASSES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PIPEMATERIALCAT_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PIPEMATERIALCAT_IDX1" ON "GWB_PIPEMATERIALCAT" ("ITEMNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PIPEMATERIALCAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PIPEMATERIALCAT_PK" ON "GWB_PIPEMATERIALCAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PIPES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PIPES_PK" ON "GWB_PIPES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PIPES_IX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PIPES_IX1" ON "GWB_PIPES" ("PIPENAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PIPETYPECAT_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PIPETYPECAT_IDX1" ON "GWB_PIPETYPECAT" ("ITEMNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PIPETYPECAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PIPETYPECAT_PK" ON "GWB_PIPETYPECAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PROBEN_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PROBEN_PK" ON "GWB_PROBEN" ("DATUMID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PROGGROUPS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PROGGROUPS_PK" ON "GWB_PROGGROUPS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PROGGROUPS_PROGS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PROGGROUPS_PROGS_PK" ON "GWB_PROGGROUPS_PROGS" ("GROUP_ID", "PROG_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PROGPARAM_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PROGPARAM_PK" ON "GWB_PROG_PARAM" ("PROG_ID", "SEQNR", "PARAM_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PROJECTS_IDX2
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PROJECTS_IDX2" ON "GWB_PROJECTS" ("PROJECTDESCR", "OWNER_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PROJECTS_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PROJECTS_IDX1" ON "GWB_PROJECTS" ("PROJECTDESCR") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PROJECTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PROJECTS_PK" ON "GWB_PROJECTS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PROJECTSUSERS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PROJECTSUSERS_PK" ON "GWB_PROJECTS_USERS" ("PU_PROJECTID", "PU_LOGINNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PUMP_DATA_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PUMP_DATA_PK" ON "GWB_PUMP_DATA" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PUMPEN_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PUMPEN_PK" ON "GWB_PUMPEN" ("PUMPENTYP") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_RAINFALL_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_RAINFALL_PK" ON "GWB_RAINFALL" ("WELL_ID", "DATE1") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_RATES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_RATES_PK" ON "GWB_RATES" ("MESSTELLENID", "DATUM1") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_REPORTGROUPS_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_REPORTGROUPS_IDX1" ON "GWB_REPORTGROUPS" ("GROUPNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_REPORTGROUPS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_REPORTGROUPS_PK" ON "GWB_REPORTGROUPS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_REPORTGROUPS_PARAMGROUPS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_REPORTGROUPS_PARAMGROUPS_PK" ON "GWB_REPORTGROUPS_PARAMGROUPS" ("GROUP_ID", "PARAMGROUP_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_REPORTGROUPS_PARAMS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_REPORTGROUPS_PARAMS_PK" ON "GWB_REPORTGROUPS_PARAMS" ("GROUP_ID", "PARAM_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_REPORTGROUPS_STATIONS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_REPORTGROUPS_STATIONS_PK" ON "GWB_REPORTGROUPS_STATIONS" ("GROUP_ID", "STATION_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_REPORTGROUPS_TEMPLATES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_REPORTGROUPS_TEMPLATES_PK" ON "GWB_REPORTGROUPS_TEMPLATES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SAMPLECALEDAR_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SAMPLECALEDAR_PK" ON "GWB_SAMPLECALENDAR" ("SAMPLEDATE", "WELL_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SAMPLECOLOR_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SAMPLECOLOR_PK" ON "GWB_SAMPLECOLOR" ("COLOR") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SAMPLEMATERIAL_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SAMPLEMATERIAL_PK" ON "GWB_SAMPLEMATERIAL" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SAMPLESEDIMENT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SAMPLESEDIMENT_PK" ON "GWB_SAMPLESEDIMENT" ("SEDIMENT") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SAMPLESMELL_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SAMPLESMELL_PK" ON "GWB_SAMPLESMELL" ("SMELL") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SAMPLESPROGS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SAMPLESPROGS_PK" ON "GWB_SAMPLES_PROGS" ("SAMPLE_ID", "PROG_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SAMPLETURBIDITY_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SAMPLETURBIDITY_PK" ON "GWB_SAMPLETURBIDITY" ("TURBIDITY") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SAMPLETYPE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SAMPLETYPE_PK" ON "GWB_SAMPLETYPE" ("SAMPLETYPE") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SAMPLEWEATHER_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SAMPLEWEATHER_PK" ON "GWB_SAMPLEWEATHER" ("WEATHER") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SAMPLINGREASONS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SAMPLINGREASONS_PK" ON "GWB_SAMPLINGREASONS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SELECTIONS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SELECTIONS_PK" ON "GWB_SELECTIONS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SENSORDEPTH_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SENSORDEPTH_PK" ON "GWB_SENSORDEPTH" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SITEOWNERS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SITEOWNERS_PK" ON "GWB_SITEOWNERS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SPEC_YIELD_IX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SPEC_YIELD_IX1" ON "GWB_SPEC_YIELD" ("WELL_ID", "MDATE") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SPEC_YIELD_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SPEC_YIELD_PK" ON "GWB_SPEC_YIELD" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SQLRECHERCHE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SQLRECHERCHE_PK" ON "GWB_SQLRECHERCHE" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_STATIONREPORTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_STATIONREPORTS_PK" ON "GWB_STATIONREPORTS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_STNFLOWDEVICEHISTORY_IX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_STNFLOWDEVICEHISTORY_IX1" ON "GWB_STNFLOWDEVICEHISTORY" ("FLOWDEVICE_ID", "FLOWDEVICEDATE") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_STNFLOWDEVICEHISTORY_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_STNFLOWDEVICEHISTORY_PK" ON "GWB_STNFLOWDEVICEHISTORY" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_STOFFKL_IDX1
--------------------------------------------------------

  CREATE INDEX "GWB_STOFFKL_IDX1" ON "GWB_STOFFKL" ("NAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_STOFFKL_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_STOFFKL_PK" ON "GWB_STOFFKL" ("CLASS_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SRNETAQUI_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SRNETAQUI_PK" ON "GWB_STOREDRIVERNET_AQUIFERS" ("STOREDRIVERNET_ID", "AQUIFER_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SRNETPNTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SRNETPNTS_PK" ON "GWB_STOREDRIVERNET_POINTS" ("STOREDRIVERNET_ID", "SEQNR") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SRNET_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SRNET_PK" ON "GWB_STOREDRIVERNETS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_STREETCAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_STREETCAT_PK" ON "GWB_STREETCAT" ("STREETKEY") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_STRUCTPARTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_STRUCTPARTS_PK" ON "GWB_STRUCTPARTS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_STRUCTPARTAQUI_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_STRUCTPARTAQUI_PK" ON "GWB_STRUCTPARTS_AQUIFERS" ("STRUCTPART_ID", "AQUIFER_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SPPOINTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SPPOINTS_PK" ON "GWB_STRUCTPARTS_POINTS" ("STRUCTPART_ID", "POINT_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_STRUCTPOINTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_STRUCTPOINTS_PK" ON "GWB_STRUCTPOINTS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_STRUCTURES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_STRUCTURES_PK" ON "GWB_STRUCTURES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SURFACEWATERPARTS_IDX2
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SURFACEWATERPARTS_IDX2" ON "GWB_SURFACEWATER_PARTS" ("MAIN_ID", "ITEMNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SURFACEWATER_PARTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SURFACEWATER_PARTS_PK" ON "GWB_SURFACEWATER_PARTS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SURFACEWATERS_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SURFACEWATERS_IDX1" ON "GWB_SURFACEWATERS" ("ITEMNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SURFACEWATERS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SURFACEWATERS_PK" ON "GWB_SURFACEWATERS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SYMBOLS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SYMBOLS_PK" ON "GWB_SYMBOLS" ("SYMBOLID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_SYMBOLSCATEGORIES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_SYMBOLSCATEGORIES_PK" ON "GWB_SYMBOLSCATEGORIES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TASTE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TASTE_PK" ON "GWB_TASTE" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHEQUIP_HISTORY_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHEQUIP_HISTORY_PK" ON "GWB_TECHEQUIP_HISTORY" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHEQUIP_MANUFACTURERCAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHEQUIP_MANUFACTURERCAT_PK" ON "GWB_TECHEQUIP_MANUFACTURERCAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHEQUIPMENT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHEQUIPMENT_PK" ON "GWB_TECHEQUIPMENT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHEQUIP_REPAIRS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHEQUIP_REPAIRS_PK" ON "GWB_TECHEQUIP_REPAIRS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHEQUIP_STORES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHEQUIP_STORES_PK" ON "GWB_TECHEQUIP_STORES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHEQUIP_TYPECAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHEQUIP_TYPECAT_PK" ON "GWB_TECHEQUIP_TYPECAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHEQUIP_WELLS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHEQUIP_WELLS_PK" ON "GWB_TECHEQUIP_WELLS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHPARTSCAT_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHPARTSCAT_IDX1" ON "GWB_TECHPARTSCAT" ("ITEMNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHPARTSCAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHPARTSCAT_PK" ON "GWB_TECHPARTSCAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHPARTSCLASSCAT_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHPARTSCLASSCAT_IDX1" ON "GWB_TECHPARTSCLASSCAT" ("ITEMNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TECHPARTSCLASSCAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TECHPARTSCLASSCAT_PK" ON "GWB_TECHPARTSCLASSCAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TODOCATEGORIES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TODOCATEGORIES_PK" ON "GWB_TODOCATEGORIES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_TOPOGRAF_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_TOPOGRAF_PK" ON "GWB_TOPOGRAF" ("PROJECT_ID", "RECHTSWERT", "HOCHWERT") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_UKAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_UKAT_PK" ON "GWB_UKAT" ("KATALOGNR") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_UMRECH_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_UMRECH_PK" ON "GWB_UMRECH" ("EINHEIT1", "EINHEIT2") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_USERS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_USERS_PK" ON "GWB_USERS" ("US_LOGINNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_VALUEMARKERS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_VALUEMARKERS_PK" ON "GWB_VALUEMARKERS" ("MARKER") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_VALVEPOSITION_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_VALVEPOSITION_PK" ON "GWB_VALVEPOSITION" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_VALVES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_VALVES_PK" ON "GWB_VALVES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_VALVETYPECAT_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_VALVETYPECAT_IDX1" ON "GWB_VALVETYPECAT" ("ITEMNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_VALVETYPECAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_VALVETYPECAT_PK" ON "GWB_VALVETYPECAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_VIRTUALWELLS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_VIRTUALWELLS_PK" ON "GWB_VIRTUALWELLS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WATERTYPECAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WATERTYPECAT_PK" ON "GWB_WATERTYPECAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WATERTYPECAT_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WATERTYPECAT_IDX1" ON "GWB_WATERTYPECAT" ("ITEMNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLGEOLOGY_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLGEOLOGY_PK" ON "GWB_WELLGEOLOGY" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLPROPERTIES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLPROPERTIES_PK" ON "GWB_WELLPROPERTIES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLPROPERTIES_VALUES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLPROPERTIES_VALUES_PK" ON "GWB_WELLPROPERTIES_VALUES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLPROPS__WELLS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLPROPS__WELLS_PK" ON "GWB_WELLPROPERTIES_WELLS" ("PROPERTY_ID", "WELL_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLPUMPRATES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLPUMPRATES_PK" ON "GWB_WELLPUMPRATES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLS_PROJECTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLS_PROJECTS_PK" ON "GWB_WELLS_PROJECTS" ("WELL_ID", "PROJECT_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLSTATUSCAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLSTATUSCAT_PK" ON "GWB_WELLSTATUSCAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLSTATUSCAT_IX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLSTATUSCAT_IX1" ON "GWB_WELLSTATUSCAT" ("STATUSNAME") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLSTATUSHISTORY_IX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLSTATUSHISTORY_IX1" ON "GWB_WELLSTATUSHISTORY" ("WELL_ID", "STATUSDATE") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLSTATUSHISTORY_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLSTATUSHISTORY_PK" ON "GWB_WELLSTATUSHISTORY" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLSTDTODOCATEGORIES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLSTDTODOCATEGORIES_PK" ON "GWB_WELLSTDTODOCATEGORIES" ("WELL_ID", "CATEGORY_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WELLTODOLIST_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WELLTODOLIST_PK" ON "GWB_WELLTODOLIST" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WSTAND_IDX1
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WSTAND_IDX1" ON "GWB_WSTAND" ("MESSTELLENID", "DATUMZEIT") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_WSTAND_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_WSTAND_PK" ON "GWB_WSTAND" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_GWC_WELLCATEGORIES
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_GWC_WELLCATEGORIES" ON "GWC_WELLCATEGORIES" ("TYPE_ID", "CATEGORY_ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_GWC_WELLCATEGORY_TYPES
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_GWC_WELLCATEGORY_TYPES" ON "GWC_WELLCATEGORY_TYPES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_DEPTHS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_DEPTHS_PK" ON "GWM_DEPTHS" ("WELL_ID", "DEPTH") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_PERSONS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_PERSONS_PK" ON "GWM_PERSONS" ("PERSON_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWM_PICTURECATEGORIESCAT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWM_PICTURECATEGORIESCAT_PK" ON "GWM_PICTURECATEGORIESCAT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_ROUTES_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_ROUTES_PK" ON "GWM_ROUTES" ("ROUTE_ID") 
  ;
--------------------------------------------------------
--  DDL for Index GWB_ROUTES_WELLS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "GWB_ROUTES_WELLS_PK" ON "GWM_ROUTES_WELLS" ("ROUTE_ID", "WELL_ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_GWW_DATASTATUS
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_GWW_DATASTATUS" ON "GWW_DATASTATUS" ("MSID", "DATATYPE", "PARAMID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_GWW_LAYERS
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_GWW_LAYERS" ON "GWW_LAYERS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_GWW_MAPS
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_GWW_MAPS" ON "GWW_MAPS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_GWW_MAPSERVICES
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_GWW_MAPSERVICES" ON "GWW_MAPSERVICES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_GWW_PROFILES
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_GWW_PROFILES" ON "GWW_PROFILES" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_GWW_WEBCONFIG
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_GWW_WEBCONFIG" ON "GWW_WEBCONFIG" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_GWW_WELLDATACOUNTS
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_GWW_WELLDATACOUNTS" ON "GWW_WELLDATACOUNTS" ("MSID") 
  ;
--------------------------------------------------------
--  DDL for Index REPITEMS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "REPITEMS_PK" ON "REPITEMS" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_RST_APPCONFIG
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_RST_APPCONFIG" ON "RST_APPCONFIG" ("MANDANT_ID", "MODULE_ID", "KEY_") 
  ;
--------------------------------------------------------
--  DDL for Index PK_RST_DBVERSION
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_RST_DBVERSION" ON "RST_DBVERSION" ("MANDANT_ID", "MODULE_ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_RST_SYNCHRONIZE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_RST_SYNCHRONIZE" ON "RST_SYNCHRONIZE" ("MANDANT_ID", "MODULE_ID", "ACTION_") 
  ;
--------------------------------------------------------
--  DDL for Trigger TRIG_AI_GWB_VALUEMARKERS
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "TRIG_AI_GWB_VALUEMARKERS" BEFORE INSERT ON GWB_ValueMarkers FOR EACH ROW 
BEGIN 
   SELECT SEQ_AI_GWB_ValueMarkers.NEXTVAL 
   INTO :new.ID 
   FROM dual; 
END; 


/
ALTER TRIGGER "TRIG_AI_GWB_VALUEMARKERS" ENABLE;
--------------------------------------------------------
--  DDL for Trigger TRIG_AI_GWB_VALUEMARKERS
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "TRIG_AI_GWB_VALUEMARKERS" BEFORE INSERT ON GWB_ValueMarkers FOR EACH ROW 
BEGIN 
   SELECT SEQ_AI_GWB_ValueMarkers.NEXTVAL 
   INTO :new.ID 
   FROM dual; 
END; 


/
ALTER TRIGGER "TRIG_AI_GWB_VALUEMARKERS" ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_ABWEICHUNGEN
--------------------------------------------------------

  ALTER TABLE "GPD_ABWEICHUNGEN" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GPD_ABWEICHUNGEN" MODIFY ("RECID" NOT NULL ENABLE);
  ALTER TABLE "GPD_ABWEICHUNGEN" ADD CONSTRAINT "GPD_ABWEICHUNGEN_PK" PRIMARY KEY ("MSID", "RECID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_ASBBOHRLOCH
--------------------------------------------------------

  ALTER TABLE "GPD_ASBBOHRLOCH" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GPD_ASBBOHRLOCH" MODIFY ("RECID" NOT NULL ENABLE);
  ALTER TABLE "GPD_ASBBOHRLOCH" ADD CONSTRAINT "GPD_ASBBOHRLOCH_PK" PRIMARY KEY ("MSID", "RECID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_ASBFILTER
--------------------------------------------------------

  ALTER TABLE "GPD_ASBFILTER" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GPD_ASBFILTER" MODIFY ("AFI_ROHRRECID" NOT NULL ENABLE);
  ALTER TABLE "GPD_ASBFILTER" ADD CONSTRAINT "GPD_ASBFILTER_PK" PRIMARY KEY ("MSID", "AFI_ROHRRECID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_ASBSONDERBAU
--------------------------------------------------------

  ALTER TABLE "GPD_ASBSONDERBAU" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GPD_ASBSONDERBAU" MODIFY ("RECID" NOT NULL ENABLE);
  ALTER TABLE "GPD_ASBSONDERBAU" ADD CONSTRAINT "GPD_ASBSONDERBAU_PK" PRIMARY KEY ("MSID", "RECID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_ASBVERFUELLUNG
--------------------------------------------------------

  ALTER TABLE "GPD_ASBVERFUELLUNG" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GPD_ASBVERFUELLUNG" MODIFY ("RECID" NOT NULL ENABLE);
  ALTER TABLE "GPD_ASBVERFUELLUNG" ADD CONSTRAINT "GPD_ASBVERFUELLUNG_PK" PRIMARY KEY ("MSID", "RECID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_ASBVERROHRUNG
--------------------------------------------------------

  ALTER TABLE "GPD_ASBVERROHRUNG" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GPD_ASBVERROHRUNG" MODIFY ("RECID" NOT NULL ENABLE);
  ALTER TABLE "GPD_ASBVERROHRUNG" ADD CONSTRAINT "GPD_ASBVERROHRUNG_PK" PRIMARY KEY ("MSID", "RECID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_HYDROPARAM
--------------------------------------------------------

  ALTER TABLE "GPD_HYDROPARAM" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GPD_HYDROPARAM" ADD CONSTRAINT "GPD_HYDROPARAM_PK" PRIMARY KEY ("MSID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_KLUEFTE
--------------------------------------------------------

  ALTER TABLE "GPD_KLUEFTE" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GPD_KLUEFTE" MODIFY ("RECID" NOT NULL ENABLE);
  ALTER TABLE "GPD_KLUEFTE" ADD CONSTRAINT "GPD_KLUEFTE_PK" PRIMARY KEY ("MSID", "RECID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_LOG
--------------------------------------------------------

  ALTER TABLE "GPD_LOG" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GPD_LOG" MODIFY ("RECID" NOT NULL ENABLE);
  ALTER TABLE "GPD_LOG" ADD CONSTRAINT "GPD_LOG_PK" PRIMARY KEY ("MSID", "RECID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_LOGDATA
--------------------------------------------------------

  ALTER TABLE "GPD_LOGDATA" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GPD_LOGDATA" MODIFY ("LD_LOGRECID" NOT NULL ENABLE);
  ALTER TABLE "GPD_LOGDATA" MODIFY ("LD_RECID" NOT NULL ENABLE);
  ALTER TABLE "GPD_LOGDATA" ADD CONSTRAINT "GPD_LOGDATA_PK" PRIMARY KEY ("MSID", "LD_LOGRECID", "LD_RECID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_MSPASSCONFIG
--------------------------------------------------------

  ALTER TABLE "GPD_MSPASSCONFIG" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GPD_MSPASSCONFIG" ADD CONSTRAINT "GPD_MSPASSCONFIG_PK" PRIMARY KEY ("MSID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_MSSTAMM
--------------------------------------------------------

  ALTER TABLE "GPD_MSSTAMM" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GPD_MSSTAMM" ADD CONSTRAINT "GPD_MSSTAMM_PK" PRIMARY KEY ("MSID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_MSSYNONYME
--------------------------------------------------------

  ALTER TABLE "GPD_MSSYNONYME" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GPD_MSSYNONYME" MODIFY ("MSSYN_ID" NOT NULL ENABLE);
  ALTER TABLE "GPD_MSSYNONYME" ADD CONSTRAINT "GPD_MSSYNONYME_PK" PRIMARY KEY ("MSID", "MSSYN_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_PACKERTEST
--------------------------------------------------------

  ALTER TABLE "GPD_PACKERTEST" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GPD_PACKERTEST" MODIFY ("RECID" NOT NULL ENABLE);
  ALTER TABLE "GPD_PACKERTEST" ADD CONSTRAINT "GPD_PACKERTEST_PK" PRIMARY KEY ("MSID", "RECID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_PLFIRMA
--------------------------------------------------------

  ALTER TABLE "GPD_PLFIRMA" MODIFY ("PLF_ID" NOT NULL ENABLE);
  ALTER TABLE "GPD_PLFIRMA" ADD CONSTRAINT "GPD_PLFIRMA_PK" PRIMARY KEY ("PLF_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_PLPERSON
--------------------------------------------------------

  ALTER TABLE "GPD_PLPERSON" MODIFY ("PLP_ID" NOT NULL ENABLE);
  ALTER TABLE "GPD_PLPERSON" ADD CONSTRAINT "GPD_PLPERSON_PK" PRIMARY KEY ("PLP_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_PLSTANDARD
--------------------------------------------------------

  ALTER TABLE "GPD_PLSTANDARD" MODIFY ("PLS_ID" NOT NULL ENABLE);
  ALTER TABLE "GPD_PLSTANDARD" ADD CONSTRAINT "GPD_PLSTANDARD_PK" PRIMARY KEY ("PLS_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_PLSTANDARD_TEMP
--------------------------------------------------------

  ALTER TABLE "GPD_PLSTANDARD_TEMP" MODIFY ("PLS_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table GPD_SCHICHTEN
--------------------------------------------------------

  ALTER TABLE "GPD_SCHICHTEN" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GPD_SCHICHTEN" MODIFY ("SD_LAYERID" NOT NULL ENABLE);
  ALTER TABLE "GPD_SCHICHTEN" MODIFY ("SD_INTVERSION" NOT NULL ENABLE);
  ALTER TABLE "GPD_SCHICHTEN" MODIFY ("SD_LAYERCNTR" NOT NULL ENABLE);
  ALTER TABLE "GPD_SCHICHTEN" ADD CONSTRAINT "GPD_SCHICHTEN_PK" PRIMARY KEY ("MSID", "SD_LAYERID", "SD_INTVERSION", "SD_LAYERCNTR")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_SCHICHTTITEL
--------------------------------------------------------

  ALTER TABLE "GPD_SCHICHTTITEL" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GPD_SCHICHTTITEL" MODIFY ("RECID" NOT NULL ENABLE);
  ALTER TABLE "GPD_SCHICHTTITEL" ADD CONSTRAINT "GPD_SCHICHTTITEL_PK" PRIMARY KEY ("MSID", "RECID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_SPUELUNG
--------------------------------------------------------

  ALTER TABLE "GPD_SPUELUNG" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GPD_SPUELUNG" MODIFY ("RECID" NOT NULL ENABLE);
  ALTER TABLE "GPD_SPUELUNG" ADD CONSTRAINT "GPD_SPUELUNG_PK" PRIMARY KEY ("MSID", "RECID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_STRATIGRAPHIE
--------------------------------------------------------

  ALTER TABLE "GPD_STRATIGRAPHIE" MODIFY ("STRT_ID" NOT NULL ENABLE);
  ALTER TABLE "GPD_STRATIGRAPHIE" ADD CONSTRAINT "GPD_STRATIGRAPHIE_PK" PRIMARY KEY ("STRT_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_STRATLISTS
--------------------------------------------------------

  ALTER TABLE "GPD_STRATLISTS" MODIFY ("SLST_ID" NOT NULL ENABLE);
  ALTER TABLE "GPD_STRATLISTS" ADD CONSTRAINT "GPD_STRATLISTS_PK" PRIMARY KEY ("SLST_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_SYNONYMKAT
--------------------------------------------------------

  ALTER TABLE "GPD_SYNONYMKAT" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GPD_SYNONYMKAT" ADD CONSTRAINT "GPD_SYNONYMKAT_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_TEMPAUSBAU
--------------------------------------------------------

  ALTER TABLE "GPD_TEMPAUSBAU" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GPD_TEMPAUSBAU" MODIFY ("RECID" NOT NULL ENABLE);
  ALTER TABLE "GPD_TEMPAUSBAU" ADD CONSTRAINT "GPD_TEMPAUSBAU_PK" PRIMARY KEY ("MSID", "RECID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_TEMPSCHICHTEN
--------------------------------------------------------

  ALTER TABLE "GPD_TEMPSCHICHTEN" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GPD_TEMPSCHICHTEN" MODIFY ("RECID" NOT NULL ENABLE);
  ALTER TABLE "GPD_TEMPSCHICHTEN" ADD CONSTRAINT "GPD_TEMPSCHICHTEN_PK" PRIMARY KEY ("MSID", "RECID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GPD_WASSERRECHT
--------------------------------------------------------

  ALTER TABLE "GPD_WASSERRECHT" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GPD_WASSERRECHT" ADD CONSTRAINT "GPD_WASSERRECHT_PK" PRIMARY KEY ("MSID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_ANALYMETHODS
--------------------------------------------------------

  ALTER TABLE "GWB_ANALYMETHODS" ADD CONSTRAINT "GWB_ANALYMETHODS_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_ANALYSEN
--------------------------------------------------------

  ALTER TABLE "GWB_ANALYSEN" ADD CONSTRAINT "GWB_ANALYSEN_PK" PRIMARY KEY ("DATUMID", "PARAMETERID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_BERICHTE
--------------------------------------------------------

  ALTER TABLE "GWB_BERICHTE" ADD CONSTRAINT "GWB_BERICHTE_PK" PRIMARY KEY ("BERICHTSNR")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_BETREIB
--------------------------------------------------------

  ALTER TABLE "GWB_BETREIB" ADD CONSTRAINT "GWB_BETREIB_PK" PRIMARY KEY ("BETREIBER")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_BOHRFIRM
--------------------------------------------------------

  ALTER TABLE "GWB_BOHRFIRM" ADD CONSTRAINT "GWB_BOHRFIRM_PK" PRIMARY KEY ("BOHRFIRMA")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_BOHRVERF
--------------------------------------------------------

  ALTER TABLE "GWB_BOHRVERF" ADD CONSTRAINT "GWB_BOHRVERF_PK" PRIMARY KEY ("BOHRVERFAHREN")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_BUILDINGMATERIALCAT
--------------------------------------------------------

  ALTER TABLE "GWB_BUILDINGMATERIALCAT" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_BUILDINGMATERIALCAT" MODIFY ("ITEMNAME" NOT NULL ENABLE);
  ALTER TABLE "GWB_BUILDINGMATERIALCAT" ADD CONSTRAINT "GWB_BUILDINGMATERIALCAT_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_CATCHMENTAREAS
--------------------------------------------------------

  ALTER TABLE "GWB_CATCHMENTAREAS" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_CATCHMENTAREAS" MODIFY ("AREANAME" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table GWB_CHANGELOGGER
--------------------------------------------------------

  ALTER TABLE "GWB_CHANGELOGGER" MODIFY ("MODIFIEDBY" NOT NULL ENABLE);
  ALTER TABLE "GWB_CHANGELOGGER" MODIFY ("MODIFIEDDATE" NOT NULL ENABLE);
  ALTER TABLE "GWB_CHANGELOGGER" ADD CONSTRAINT "GWB_CHANGELOGGER_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_CHECKRULES
--------------------------------------------------------

  ALTER TABLE "GWB_CHECKRULES" ADD CONSTRAINT "GWB_CHECKRULES_PK" PRIMARY KEY ("CR_WELLID", "CR_PARAMID", "CR_RULETYPE", "CR_CHECKVALUE", "CR_VALIDFROM", "CR_VALIDUNTIL")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_CHECKRULES_TEMPLATES
--------------------------------------------------------

  ALTER TABLE "GWB_CHECKRULES_TEMPLATES" MODIFY ("CR_PARAMID" NOT NULL ENABLE);
  ALTER TABLE "GWB_CHECKRULES_TEMPLATES" MODIFY ("CR_RULETYPE" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table GWB_CHECKRULES2
--------------------------------------------------------

  ALTER TABLE "GWB_CHECKRULES2" MODIFY ("CR_WELLID" NOT NULL ENABLE);
  ALTER TABLE "GWB_CHECKRULES2" MODIFY ("CR_PARAMID" NOT NULL ENABLE);
  ALTER TABLE "GWB_CHECKRULES2" MODIFY ("CR_RULETYPE" NOT NULL ENABLE);
  ALTER TABLE "GWB_CHECKRULES2" ADD CONSTRAINT "GWB_CHECKRULES2_PK" PRIMARY KEY ("CR_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_CLASS_PARAM
--------------------------------------------------------

  ALTER TABLE "GWB_CLASS_PARAM" ADD CONSTRAINT "GWB_CLASSPARAM_PK" PRIMARY KEY ("PARAM_ID", "CLASS_ID")
  USING INDEX "GWB_CLASS_PARAM_IDX1"  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_DISCHARGESTATISTIC
--------------------------------------------------------

  ALTER TABLE "GWB_DISCHARGESTATISTIC" ADD CONSTRAINT "GWB_DISCHARGESTATISTIC_PK" PRIMARY KEY ("WELL_ID", "STATYEAR")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_DOCCATEGORIES
--------------------------------------------------------

  ALTER TABLE "GWB_DOCCATEGORIES" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_DOCCATEGORIES" MODIFY ("CATEGORY" NOT NULL ENABLE);
  ALTER TABLE "GWB_DOCCATEGORIES" ADD CONSTRAINT "GWB_DOCCATEGORIES_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_DOCTYPES
--------------------------------------------------------

  ALTER TABLE "GWB_DOCTYPES" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_DOCTYPES" MODIFY ("DOCTYPE" NOT NULL ENABLE);
  ALTER TABLE "GWB_DOCTYPES" ADD CONSTRAINT "GWB_DOCTYPES_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_EINHEIT
--------------------------------------------------------

  ALTER TABLE "GWB_EINHEIT" ADD CONSTRAINT "GWB_EINHEIT_PK" PRIMARY KEY ("EINHEIT")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_ELEVATIONQUALITY
--------------------------------------------------------

  ALTER TABLE "GWB_ELEVATIONQUALITY" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_ELEVATIONQUALITY" MODIFY ("QUALITYTEXT" NOT NULL ENABLE);
  ALTER TABLE "GWB_ELEVATIONQUALITY" ADD CONSTRAINT "GWB_ELEVATIONQUALITY_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_FIELDCHECKS
--------------------------------------------------------

  ALTER TABLE "GWB_FIELDCHECKS" MODIFY ("TNAME" NOT NULL ENABLE);
  ALTER TABLE "GWB_FIELDCHECKS" MODIFY ("FNAME" NOT NULL ENABLE);
  ALTER TABLE "GWB_FIELDCHECKS" ADD CONSTRAINT "GWB_FIELDCHECKS_PK" PRIMARY KEY ("TNAME", "FNAME")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_FLOWMEASUREMENTCAT
--------------------------------------------------------

  ALTER TABLE "GWB_FLOWMEASUREMENTCAT" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_FLOWMEASUREMENTCAT" MODIFY ("ITEMNAME" NOT NULL ENABLE);
  ALTER TABLE "GWB_FLOWMEASUREMENTCAT" ADD CONSTRAINT "GWB_FLOWMEASUREMENTCAT_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_GEOLOGIE
--------------------------------------------------------

  ALTER TABLE "GWB_GEOLOGIE" MODIFY ("GEOLOGISCHEEINHEIT" NOT NULL ENABLE);
  ALTER TABLE "GWB_GEOLOGIE" ADD CONSTRAINT "GWB_GEOLOGIE_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_GERAETE
--------------------------------------------------------

  ALTER TABLE "GWB_GERAETE" ADD CONSTRAINT "GWB_GERAETE_PK" PRIMARY KEY ("PROBENNAHMEGERAET")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_GRAPHICS
--------------------------------------------------------

  ALTER TABLE "GWB_GRAPHICS" ADD CONSTRAINT "GWB_GRAPHICS_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_GWSTOCKW
--------------------------------------------------------

  ALTER TABLE "GWB_GWSTOCKW" MODIFY ("GRUNDWASSERSTOCKWERK" NOT NULL ENABLE);
  ALTER TABLE "GWB_GWSTOCKW" ADD CONSTRAINT "GWB_GWSTOCKW_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_HCHANGE
--------------------------------------------------------

  ALTER TABLE "GWB_HCHANGE" ADD CONSTRAINT "GWB_HCHANGE_PK" PRIMARY KEY ("MESSTELLENID", "DATUMAENDERUNG")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_IMPORTS
--------------------------------------------------------

  ALTER TABLE "GWB_IMPORTS" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_IMPORTS" ADD CONSTRAINT "GWB_IMPORT_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_INOUTLETSTRUCTURE
--------------------------------------------------------

  ALTER TABLE "GWB_INOUTLETSTRUCTURE" ADD CONSTRAINT "GWB_INOUTLETSTRUCTURE_PK" PRIMARY KEY ("OBJECT_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_IONRATIOS
--------------------------------------------------------

  ALTER TABLE "GWB_IONRATIOS" MODIFY ("DATE_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table GWB_KEYWORD_OBJECTS
--------------------------------------------------------

  ALTER TABLE "GWB_KEYWORD_OBJECTS" MODIFY ("KEYWORD_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_KEYWORD_OBJECTS" MODIFY ("OBJECT_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_KEYWORD_OBJECTS" MODIFY ("OBJECT_TYPE" NOT NULL ENABLE);
  ALTER TABLE "GWB_KEYWORD_OBJECTS" ADD CONSTRAINT "GWB_KEYWORD_OBJECTS_PK" PRIMARY KEY ("KEYWORD_ID", "OBJECT_ID", "OBJECT_TYPE")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_KEYWORDS
--------------------------------------------------------

  ALTER TABLE "GWB_KEYWORDS" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_KEYWORDS" MODIFY ("KEYWORD" NOT NULL ENABLE);
  ALTER TABLE "GWB_KEYWORDS" ADD CONSTRAINT "GWB_KEYWORDS_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_LABORS
--------------------------------------------------------

  ALTER TABLE "GWB_LABORS" MODIFY ("LABOR" NOT NULL ENABLE);
  ALTER TABLE "GWB_LABORS" ADD CONSTRAINT "GWB_LABORS_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_LEVEL_ATTRIBUTES
--------------------------------------------------------

  ALTER TABLE "GWB_LEVEL_ATTRIBUTES" ADD CONSTRAINT "GWB_LEVEL_ATTRIBUTES_PK" PRIMARY KEY ("LA_DATE_ID", "LA_ATTRIBUTE_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_LEVELCOMMENTS
--------------------------------------------------------

  ALTER TABLE "GWB_LEVELCOMMENTS" ADD CONSTRAINT "GWB_LEVELCOMMENTS_PK" PRIMARY KEY ("COMMENTID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_LEVELSTATISTIC
--------------------------------------------------------

  ALTER TABLE "GWB_LEVELSTATISTIC" MODIFY ("WELL_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table GWB_LOGINS
--------------------------------------------------------

  ALTER TABLE "GWB_LOGINS" MODIFY ("USER_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_LOGINS" ADD CONSTRAINT "GWB_LOGINS_PK" PRIMARY KEY ("USER_ID", "LOGINTIME")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_MANHOLE
--------------------------------------------------------

  ALTER TABLE "GWB_MANHOLE" ADD CONSTRAINT "GWB_MANHOLE_PK" PRIMARY KEY ("OBJECT_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_MAPS
--------------------------------------------------------

  ALTER TABLE "GWB_MAPS" ADD CONSTRAINT "GWB_MAPS_PK" PRIMARY KEY ("MAPCOMMENT")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_MAPS_PROJECTS
--------------------------------------------------------

  ALTER TABLE "GWB_MAPS_PROJECTS" ADD CONSTRAINT "GWB_MAPS_PROJECTS_PK" PRIMARY KEY ("MAP_ID", "PROJECT_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_MEASDATE
--------------------------------------------------------

  ALTER TABLE "GWB_MEASDATE" ADD CONSTRAINT "GWB_MEASDATE_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_MEMOS
--------------------------------------------------------

  ALTER TABLE "GWB_MEMOS" ADD CONSTRAINT "GWB_MEMOS_PK" PRIMARY KEY ("WELL_ID", "MEMOTYPE", "DATE_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_MISCSTRUCTURE
--------------------------------------------------------

  ALTER TABLE "GWB_MISCSTRUCTURE" ADD CONSTRAINT "GWB_MISCSTRUCTURE_PK" PRIMARY KEY ("OBJECT_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_MSART
--------------------------------------------------------

  ALTER TABLE "GWB_MSART" ADD CONSTRAINT "GWB_MSART_PK" PRIMARY KEY ("MSART")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_MSSTAMM
--------------------------------------------------------

  ALTER TABLE "GWB_MSSTAMM" MODIFY ("KENNNR" NOT NULL ENABLE);
  ALTER TABLE "GWB_MSSTAMM" ADD CONSTRAINT "GWB_MSSTAMM_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_NUTZUNG
--------------------------------------------------------

  ALTER TABLE "GWB_NUTZUNG" ADD CONSTRAINT "GWB_NUTZUNG_PK" PRIMARY KEY ("NUTZUNG")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_OBJECT_PIPES
--------------------------------------------------------

  ALTER TABLE "GWB_OBJECT_PIPES" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_OBJECT_PIPES" MODIFY ("OBJECT_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_OBJECT_PIPES" MODIFY ("ITEMNAME" NOT NULL ENABLE);
  ALTER TABLE "GWB_OBJECT_PIPES" ADD CONSTRAINT "GWB_OBJECT_PIPES_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_OBJECT_TECHPARTS
--------------------------------------------------------

  ALTER TABLE "GWB_OBJECT_TECHPARTS" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_OBJECT_TECHPARTS" ADD CONSTRAINT "GWB_OBJECT_TECHPARTS_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_OBJECTTYPES
--------------------------------------------------------

  ALTER TABLE "GWB_OBJECTTYPES" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_OBJECTTYPES" MODIFY ("DESCRIPTION" NOT NULL ENABLE);
  ALTER TABLE "GWB_OBJECTTYPES" ADD CONSTRAINT "PK_GWB_OBJECTTYPES" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_PARAMET
--------------------------------------------------------

  ALTER TABLE "GWB_PARAMET" ADD CONSTRAINT "GWB_PARAMET_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_PARAMLISTS
--------------------------------------------------------

  ALTER TABLE "GWB_PARAMLISTS" ADD CONSTRAINT "GWB_PARAMLISTS_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_PARAM_VALUECLASSES
--------------------------------------------------------

  ALTER TABLE "GWB_PARAM_VALUECLASSES" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_PARAM_VALUECLASSES" MODIFY ("PARAM_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_PARAM_VALUECLASSES" MODIFY ("MEDIUM" NOT NULL ENABLE);
  ALTER TABLE "GWB_PARAM_VALUECLASSES" MODIFY ("CLASSVALUE" NOT NULL ENABLE);
  ALTER TABLE "GWB_PARAM_VALUECLASSES" ADD CONSTRAINT "GWB_PARAM_VALUECLASSES_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_PIPEMATERIALCAT
--------------------------------------------------------

  ALTER TABLE "GWB_PIPEMATERIALCAT" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_PIPEMATERIALCAT" MODIFY ("ITEMNAME" NOT NULL ENABLE);
  ALTER TABLE "GWB_PIPEMATERIALCAT" ADD CONSTRAINT "GWB_PIPEMATERIALCAT_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_PIPES
--------------------------------------------------------

  ALTER TABLE "GWB_PIPES" ADD CONSTRAINT "GWB_PIPES_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_PIPETYPECAT
--------------------------------------------------------

  ALTER TABLE "GWB_PIPETYPECAT" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_PIPETYPECAT" MODIFY ("ITEMNAME" NOT NULL ENABLE);
  ALTER TABLE "GWB_PIPETYPECAT" ADD CONSTRAINT "GWB_PIPETYPECAT_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_PROBEN
--------------------------------------------------------

  ALTER TABLE "GWB_PROBEN" ADD CONSTRAINT "GWB_PROBEN_PK" PRIMARY KEY ("DATUMID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_PROGGROUPS
--------------------------------------------------------

  ALTER TABLE "GWB_PROGGROUPS" ADD CONSTRAINT "GWB_PROGGROUPS_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_PROGGROUPS_PROGS
--------------------------------------------------------

  ALTER TABLE "GWB_PROGGROUPS_PROGS" ADD CONSTRAINT "GWB_PROGGROUPS_PROGS_PK" PRIMARY KEY ("GROUP_ID", "PROG_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_PROG_PARAM
--------------------------------------------------------

  ALTER TABLE "GWB_PROG_PARAM" ADD CONSTRAINT "GWB_PROGPARAM_PK" PRIMARY KEY ("PROG_ID", "SEQNR", "PARAM_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_PROJECTS
--------------------------------------------------------

  ALTER TABLE "GWB_PROJECTS" ADD CONSTRAINT "GWB_PROJECTS_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_PROJECTS_USERS
--------------------------------------------------------

  ALTER TABLE "GWB_PROJECTS_USERS" ADD CONSTRAINT "GWB_PROJECTSUSERS_PK" PRIMARY KEY ("PU_PROJECTID", "PU_LOGINNAME")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_PUMP_DATA
--------------------------------------------------------

  ALTER TABLE "GWB_PUMP_DATA" MODIFY ("WELL_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_PUMP_DATA" MODIFY ("EQUIP_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_PUMP_DATA" ADD CONSTRAINT "GWB_PUMP_DATA_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_PUMPEN
--------------------------------------------------------

  ALTER TABLE "GWB_PUMPEN" ADD CONSTRAINT "GWB_PUMPEN_PK" PRIMARY KEY ("PUMPENTYP")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_RAINFALL
--------------------------------------------------------

  ALTER TABLE "GWB_RAINFALL" ADD CONSTRAINT "GWB_RAINFALL_PK" PRIMARY KEY ("WELL_ID", "DATE1")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_RATES
--------------------------------------------------------

  ALTER TABLE "GWB_RATES" ADD CONSTRAINT "GWB_RATES_PK" PRIMARY KEY ("MESSTELLENID", "DATUM1")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_REPORTGROUPS
--------------------------------------------------------

  ALTER TABLE "GWB_REPORTGROUPS" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_REPORTGROUPS" MODIFY ("GROUPNAME" NOT NULL ENABLE);
  ALTER TABLE "GWB_REPORTGROUPS" ADD CONSTRAINT "GWB_REPORTGROUPS_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_REPORTGROUPS_PARAMGROUPS
--------------------------------------------------------

  ALTER TABLE "GWB_REPORTGROUPS_PARAMGROUPS" MODIFY ("GROUP_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_REPORTGROUPS_PARAMGROUPS" MODIFY ("PARAMGROUP_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_REPORTGROUPS_PARAMGROUPS" ADD CONSTRAINT "GWB_REPORTGROUPS_PARAMGROUPS_PK" PRIMARY KEY ("GROUP_ID", "PARAMGROUP_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_REPORTGROUPS_PARAMS
--------------------------------------------------------

  ALTER TABLE "GWB_REPORTGROUPS_PARAMS" MODIFY ("GROUP_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_REPORTGROUPS_PARAMS" MODIFY ("PARAM_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_REPORTGROUPS_PARAMS" ADD CONSTRAINT "GWB_REPORTGROUPS_PARAMS_PK" PRIMARY KEY ("GROUP_ID", "PARAM_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_REPORTGROUPS_STATIONS
--------------------------------------------------------

  ALTER TABLE "GWB_REPORTGROUPS_STATIONS" MODIFY ("GROUP_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_REPORTGROUPS_STATIONS" MODIFY ("STATION_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_REPORTGROUPS_STATIONS" ADD CONSTRAINT "GWB_REPORTGROUPS_STATIONS_PK" PRIMARY KEY ("GROUP_ID", "STATION_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_REPORTGROUPS_TEMPLATES
--------------------------------------------------------

  ALTER TABLE "GWB_REPORTGROUPS_TEMPLATES" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_REPORTGROUPS_TEMPLATES" MODIFY ("GROUP_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_REPORTGROUPS_TEMPLATES" MODIFY ("REPORTTEMPLATE" NOT NULL ENABLE);
  ALTER TABLE "GWB_REPORTGROUPS_TEMPLATES" MODIFY ("SEQNO" NOT NULL ENABLE);
  ALTER TABLE "GWB_REPORTGROUPS_TEMPLATES" ADD CONSTRAINT "GWB_REPORTGROUPS_TEMPLATES_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_SAMPLECALENDAR
--------------------------------------------------------

  ALTER TABLE "GWB_SAMPLECALENDAR" MODIFY ("PROGGROUP_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_SAMPLECALENDAR" ADD CONSTRAINT "GWB_SAMPLECALEDAR_PK" PRIMARY KEY ("SAMPLEDATE", "WELL_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_SAMPLECOLOR
--------------------------------------------------------

  ALTER TABLE "GWB_SAMPLECOLOR" ADD CONSTRAINT "GWB_SAMPLECOLOR_PK" PRIMARY KEY ("COLOR")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_SAMPLEMATERIAL
--------------------------------------------------------

  ALTER TABLE "GWB_SAMPLEMATERIAL" ADD CONSTRAINT "GWB_SAMPLEMATERIAL_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_SAMPLESEDIMENT
--------------------------------------------------------

  ALTER TABLE "GWB_SAMPLESEDIMENT" ADD CONSTRAINT "GWB_SAMPLESEDIMENT_PK" PRIMARY KEY ("SEDIMENT")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_SAMPLESMELL
--------------------------------------------------------

  ALTER TABLE "GWB_SAMPLESMELL" ADD CONSTRAINT "GWB_SAMPLESMELL_PK" PRIMARY KEY ("SMELL")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_SAMPLES_PROGS
--------------------------------------------------------

  ALTER TABLE "GWB_SAMPLES_PROGS" ADD CONSTRAINT "GWB_SAMPLESPROGS_PK" PRIMARY KEY ("SAMPLE_ID", "PROG_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_SAMPLETURBIDITY
--------------------------------------------------------

  ALTER TABLE "GWB_SAMPLETURBIDITY" ADD CONSTRAINT "GWB_SAMPLETURBIDITY_PK" PRIMARY KEY ("TURBIDITY")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_SAMPLETYPE
--------------------------------------------------------

  ALTER TABLE "GWB_SAMPLETYPE" ADD CONSTRAINT "GWB_SAMPLETYPE_PK" PRIMARY KEY ("SAMPLETYPE")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_SAMPLEWEATHER
--------------------------------------------------------

  ALTER TABLE "GWB_SAMPLEWEATHER" ADD CONSTRAINT "GWB_SAMPLEWEATHER_PK" PRIMARY KEY ("WEATHER")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_SAMPLINGREASONS
--------------------------------------------------------

  ALTER TABLE "GWB_SAMPLINGREASONS" ADD CONSTRAINT "GWB_SAMPLINGREASONS_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_SELECTIONS
--------------------------------------------------------

  ALTER TABLE "GWB_SELECTIONS" ADD CONSTRAINT "GWB_SELECTIONS_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_SENSORDEPTH
--------------------------------------------------------

  ALTER TABLE "GWB_SENSORDEPTH" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_SENSORDEPTH" MODIFY ("WELL_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_SENSORDEPTH" MODIFY ("SENSORDEPTH" NOT NULL ENABLE);
  ALTER TABLE "GWB_SENSORDEPTH" MODIFY ("SENSORDATE" NOT NULL ENABLE);
  ALTER TABLE "GWB_SENSORDEPTH" ADD CONSTRAINT "GWB_SENSORDEPTH_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_SITEOWNERS
--------------------------------------------------------

  ALTER TABLE "GWB_SITEOWNERS" ADD CONSTRAINT "GWB_SITEOWNERS_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_SPEC_YIELD
--------------------------------------------------------

  ALTER TABLE "GWB_SPEC_YIELD" MODIFY ("WELL_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_SPEC_YIELD" ADD CONSTRAINT "GWB_SPEC_YIELD_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_SQLRECHERCHE
--------------------------------------------------------

  ALTER TABLE "GWB_SQLRECHERCHE" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_SQLRECHERCHE" ADD CONSTRAINT "GWB_SQLRECHERCHE_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_STATIONREPORTS
--------------------------------------------------------

  ALTER TABLE "GWB_STATIONREPORTS" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_STATIONREPORTS" MODIFY ("PARAMETER_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_STATIONREPORTS" ADD CONSTRAINT "GWB_STATIONREPORTS_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_STNFLOWDEVICEHISTORY
--------------------------------------------------------

  ALTER TABLE "GWB_STNFLOWDEVICEHISTORY" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_STNFLOWDEVICEHISTORY" MODIFY ("STATION_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_STNFLOWDEVICEHISTORY" MODIFY ("FLOWDEVICE_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_STNFLOWDEVICEHISTORY" MODIFY ("FLOWDEVICEDATE" NOT NULL ENABLE);
  ALTER TABLE "GWB_STNFLOWDEVICEHISTORY" ADD CONSTRAINT "GWB_STNFLOWDEVICEHISTORY_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_STOFFKL
--------------------------------------------------------

  ALTER TABLE "GWB_STOFFKL" ADD CONSTRAINT "GWB_STOFFKL_PK" PRIMARY KEY ("CLASS_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_STOREDRIVERNET_AQUIFERS
--------------------------------------------------------

  ALTER TABLE "GWB_STOREDRIVERNET_AQUIFERS" ADD CONSTRAINT "GWB_SRNETAQUI_PK" PRIMARY KEY ("STOREDRIVERNET_ID", "AQUIFER_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_STOREDRIVERNET_POINTS
--------------------------------------------------------

  ALTER TABLE "GWB_STOREDRIVERNET_POINTS" ADD CONSTRAINT "GWB_SRNETPNTS_PK" PRIMARY KEY ("STOREDRIVERNET_ID", "SEQNR")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_STOREDRIVERNETS
--------------------------------------------------------

  ALTER TABLE "GWB_STOREDRIVERNETS" ADD CONSTRAINT "GWB_SRNET_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_STREETCAT
--------------------------------------------------------

  ALTER TABLE "GWB_STREETCAT" MODIFY ("STREETKEY" NOT NULL ENABLE);
  ALTER TABLE "GWB_STREETCAT" MODIFY ("STREETNAME" NOT NULL ENABLE);
  ALTER TABLE "GWB_STREETCAT" ADD CONSTRAINT "GWB_STREETCAT_PK" PRIMARY KEY ("STREETKEY")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_STRUCTPARTS
--------------------------------------------------------

  ALTER TABLE "GWB_STRUCTPARTS" ADD CONSTRAINT "GWB_STRUCTPARTS_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_STRUCTPARTS_AQUIFERS
--------------------------------------------------------

  ALTER TABLE "GWB_STRUCTPARTS_AQUIFERS" ADD CONSTRAINT "GWB_STRUCTPARTAQUI_PK" PRIMARY KEY ("STRUCTPART_ID", "AQUIFER_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_STRUCTPARTS_POINTS
--------------------------------------------------------

  ALTER TABLE "GWB_STRUCTPARTS_POINTS" ADD CONSTRAINT "GWB_SPPOINTS_PK" PRIMARY KEY ("STRUCTPART_ID", "POINT_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_STRUCTPOINTS
--------------------------------------------------------

  ALTER TABLE "GWB_STRUCTPOINTS" ADD CONSTRAINT "GWB_STRUCTPOINTS_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_STRUCTURES
--------------------------------------------------------

  ALTER TABLE "GWB_STRUCTURES" ADD CONSTRAINT "GWB_STRUCTURES_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_SURFACEWATER_PARTS
--------------------------------------------------------

  ALTER TABLE "GWB_SURFACEWATER_PARTS" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_SURFACEWATER_PARTS" MODIFY ("MAIN_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_SURFACEWATER_PARTS" MODIFY ("ITEMNAME" NOT NULL ENABLE);
  ALTER TABLE "GWB_SURFACEWATER_PARTS" ADD CONSTRAINT "GWB_SURFACEWATER_PARTS_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_SURFACEWATERS
--------------------------------------------------------

  ALTER TABLE "GWB_SURFACEWATERS" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_SURFACEWATERS" MODIFY ("ITEMNAME" NOT NULL ENABLE);
  ALTER TABLE "GWB_SURFACEWATERS" ADD CONSTRAINT "GWB_SURFACEWATERS_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_SYMBOLS
--------------------------------------------------------

  ALTER TABLE "GWB_SYMBOLS" ADD CONSTRAINT "GWB_SYMBOLS_PK" PRIMARY KEY ("SYMBOLID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_SYMBOLSCATEGORIES
--------------------------------------------------------

  ALTER TABLE "GWB_SYMBOLSCATEGORIES" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_SYMBOLSCATEGORIES" MODIFY ("FIELD_NAME" NOT NULL ENABLE);
  ALTER TABLE "GWB_SYMBOLSCATEGORIES" ADD CONSTRAINT "GWB_SYMBOLSCATEGORIES_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_TASTE
--------------------------------------------------------

  ALTER TABLE "GWB_TASTE" ADD CONSTRAINT "GWB_TASTE_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_TECHEQUIP_HISTORY
--------------------------------------------------------

  ALTER TABLE "GWB_TECHEQUIP_HISTORY" MODIFY ("EQUIP_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_TECHEQUIP_HISTORY" MODIFY ("WELL_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_TECHEQUIP_HISTORY" ADD CONSTRAINT "GWB_TECHEQUIP_HISTORY_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_TECHEQUIP_MANUFACTURERCAT
--------------------------------------------------------

  ALTER TABLE "GWB_TECHEQUIP_MANUFACTURERCAT" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_TECHEQUIP_MANUFACTURERCAT" MODIFY ("MANUFACTURER" NOT NULL ENABLE);
  ALTER TABLE "GWB_TECHEQUIP_MANUFACTURERCAT" ADD CONSTRAINT "GWB_TECHEQUIP_MANUFACTURERCAT_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_TECHEQUIPMENT
--------------------------------------------------------

  ALTER TABLE "GWB_TECHEQUIPMENT" ADD CONSTRAINT "GWB_TECHEQUIPMENT_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_TECHEQUIP_REPAIRS
--------------------------------------------------------

  ALTER TABLE "GWB_TECHEQUIP_REPAIRS" MODIFY ("EQUIP_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_TECHEQUIP_REPAIRS" MODIFY ("HISTORY_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_TECHEQUIP_REPAIRS" ADD CONSTRAINT "GWB_TECHEQUIP_REPAIRS_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_TECHEQUIP_STORES
--------------------------------------------------------

  ALTER TABLE "GWB_TECHEQUIP_STORES" MODIFY ("EQUIP_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_TECHEQUIP_STORES" MODIFY ("HISTORY_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_TECHEQUIP_STORES" ADD CONSTRAINT "GWB_TECHEQUIP_STORES_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_TECHEQUIP_TYPECAT
--------------------------------------------------------

  ALTER TABLE "GWB_TECHEQUIP_TYPECAT" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_TECHEQUIP_TYPECAT" MODIFY ("EQUIPTYPE" NOT NULL ENABLE);
  ALTER TABLE "GWB_TECHEQUIP_TYPECAT" ADD CONSTRAINT "GWB_TECHEQUIP_TYPECAT_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_TECHEQUIP_WELLS
--------------------------------------------------------

  ALTER TABLE "GWB_TECHEQUIP_WELLS" MODIFY ("EQUIP_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_TECHEQUIP_WELLS" MODIFY ("HISTORY_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_TECHEQUIP_WELLS" ADD CONSTRAINT "GWB_TECHEQUIP_WELLS_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_TECHPARTSCAT
--------------------------------------------------------

  ALTER TABLE "GWB_TECHPARTSCAT" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_TECHPARTSCAT" MODIFY ("CLASS_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_TECHPARTSCAT" MODIFY ("ITEMNAME" NOT NULL ENABLE);
  ALTER TABLE "GWB_TECHPARTSCAT" ADD CONSTRAINT "GWB_TECHPARTSCAT_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_TECHPARTSCLASSCAT
--------------------------------------------------------

  ALTER TABLE "GWB_TECHPARTSCLASSCAT" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_TECHPARTSCLASSCAT" MODIFY ("ITEMNAME" NOT NULL ENABLE);
  ALTER TABLE "GWB_TECHPARTSCLASSCAT" ADD CONSTRAINT "GWB_TECHPARTSCLASSCAT_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_TODOCATEGORIES
--------------------------------------------------------

  ALTER TABLE "GWB_TODOCATEGORIES" ADD CONSTRAINT "GWB_TODOCATEGORIES_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_TOPOGRAF
--------------------------------------------------------

  ALTER TABLE "GWB_TOPOGRAF" ADD CONSTRAINT "GWB_TOPOGRAF_PK" PRIMARY KEY ("PROJECT_ID", "RECHTSWERT", "HOCHWERT")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_UKAT
--------------------------------------------------------

  ALTER TABLE "GWB_UKAT" ADD CONSTRAINT "GWB_UKAT_PK" PRIMARY KEY ("KATALOGNR")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_UMRECH
--------------------------------------------------------

  ALTER TABLE "GWB_UMRECH" ADD CONSTRAINT "GWB_UMRECH_PK" PRIMARY KEY ("EINHEIT1", "EINHEIT2")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_USERS
--------------------------------------------------------

  ALTER TABLE "GWB_USERS" ADD CONSTRAINT "GWB_USERS_PK" PRIMARY KEY ("US_LOGINNAME")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_USERSELECTION
--------------------------------------------------------

  ALTER TABLE "GWB_USERSELECTION" MODIFY ("USER_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_USERSELECTION" MODIFY ("WELL_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table GWB_VALUEMARKERS
--------------------------------------------------------

  ALTER TABLE "GWB_VALUEMARKERS" ADD CONSTRAINT "GWB_VALUEMARKERS_PK" PRIMARY KEY ("MARKER")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_VALVEPOSITION
--------------------------------------------------------

  ALTER TABLE "GWB_VALVEPOSITION" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_VALVEPOSITION" MODIFY ("VALVE_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_VALVEPOSITION" ADD CONSTRAINT "GWB_VALVEPOSITION_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_VALVES
--------------------------------------------------------

  ALTER TABLE "GWB_VALVES" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_VALVES" MODIFY ("OBJECT_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_VALVES" ADD CONSTRAINT "GWB_VALVES_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_VALVETYPECAT
--------------------------------------------------------

  ALTER TABLE "GWB_VALVETYPECAT" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_VALVETYPECAT" MODIFY ("ITEMNAME" NOT NULL ENABLE);
  ALTER TABLE "GWB_VALVETYPECAT" ADD CONSTRAINT "GWB_VALVETYPECAT_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_VIRTUALWELLS
--------------------------------------------------------

  ALTER TABLE "GWB_VIRTUALWELLS" MODIFY ("REFERENCESTATION_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_VIRTUALWELLS" ADD CONSTRAINT "GWB_VIRTUALWELLS_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_WATERTYPECAT
--------------------------------------------------------

  ALTER TABLE "GWB_WATERTYPECAT" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_WATERTYPECAT" MODIFY ("ITEMNAME" NOT NULL ENABLE);
  ALTER TABLE "GWB_WATERTYPECAT" ADD CONSTRAINT "GWB_WATERTYPECAT_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_WELLGEOLOGY
--------------------------------------------------------

  ALTER TABLE "GWB_WELLGEOLOGY" ADD CONSTRAINT "GWB_WELLGEOLOGY_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_WELLPROPERTIES
--------------------------------------------------------

  ALTER TABLE "GWB_WELLPROPERTIES" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_WELLPROPERTIES" MODIFY ("PROPERTY_NAME" NOT NULL ENABLE);
  ALTER TABLE "GWB_WELLPROPERTIES" ADD CONSTRAINT "GWB_WELLPROPERTIES_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_WELLPROPERTIES_VALUES
--------------------------------------------------------

  ALTER TABLE "GWB_WELLPROPERTIES_VALUES" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_WELLPROPERTIES_VALUES" MODIFY ("PROPERTY_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_WELLPROPERTIES_VALUES" MODIFY ("VALUETEXT" NOT NULL ENABLE);
  ALTER TABLE "GWB_WELLPROPERTIES_VALUES" ADD CONSTRAINT "GWB_WELLPROPERTIES_VALUES_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_WELLPROPERTIES_WELLS
--------------------------------------------------------

  ALTER TABLE "GWB_WELLPROPERTIES_WELLS" MODIFY ("PROPERTY_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_WELLPROPERTIES_WELLS" MODIFY ("WELL_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_WELLPROPERTIES_WELLS" ADD CONSTRAINT "GWB_WELLPROPS__WELLS_PK" PRIMARY KEY ("PROPERTY_ID", "WELL_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_WELLPUMPRATES
--------------------------------------------------------

  ALTER TABLE "GWB_WELLPUMPRATES" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_WELLPUMPRATES" MODIFY ("WELL_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_WELLPUMPRATES" ADD CONSTRAINT "GWB_WELLPUMPRATES_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_WELLS_PROJECTS
--------------------------------------------------------

  ALTER TABLE "GWB_WELLS_PROJECTS" ADD CONSTRAINT "GWB_WELLS_PROJECTS_PK" PRIMARY KEY ("WELL_ID", "PROJECT_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_WELLSTATUSCAT
--------------------------------------------------------

  ALTER TABLE "GWB_WELLSTATUSCAT" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_WELLSTATUSCAT" ADD CONSTRAINT "GWB_WELLSTATUSCAT_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_WELLSTATUSHISTORY
--------------------------------------------------------

  ALTER TABLE "GWB_WELLSTATUSHISTORY" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_WELLSTATUSHISTORY" MODIFY ("WELL_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_WELLSTATUSHISTORY" MODIFY ("STATUS_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_WELLSTATUSHISTORY" MODIFY ("STATUSDATE" NOT NULL ENABLE);
  ALTER TABLE "GWB_WELLSTATUSHISTORY" ADD CONSTRAINT "GWB_WELLSTATUSHISTORY_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_WELLSTDTODOCATEGORIES
--------------------------------------------------------

  ALTER TABLE "GWB_WELLSTDTODOCATEGORIES" MODIFY ("WELL_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_WELLSTDTODOCATEGORIES" MODIFY ("CATEGORY_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_WELLSTDTODOCATEGORIES" ADD CONSTRAINT "GWB_WELLSTDTODOCATEGORIES_PK" PRIMARY KEY ("WELL_ID", "CATEGORY_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_WELLTODOLIST
--------------------------------------------------------

  ALTER TABLE "GWB_WELLTODOLIST" ADD CONSTRAINT "GWB_WELLTODOLIST_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWB_WELLTODOLISTSAP_ERR
--------------------------------------------------------

  ALTER TABLE "GWB_WELLTODOLISTSAP_ERR" MODIFY ("GWB_ID" NOT NULL ENABLE);
  ALTER TABLE "GWB_WELLTODOLISTSAP_ERR" MODIFY ("TYPE" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table GWB_WSTAND
--------------------------------------------------------

  ALTER TABLE "GWB_WSTAND" MODIFY ("MESSTELLENID" NOT NULL ENABLE);
  ALTER TABLE "GWB_WSTAND" MODIFY ("DATUMZEIT" NOT NULL ENABLE);
  ALTER TABLE "GWB_WSTAND" ADD CONSTRAINT "GWB_WSTAND_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWC_WELLCATEGORIES
--------------------------------------------------------

  ALTER TABLE "GWC_WELLCATEGORIES" MODIFY ("TYPE_ID" NOT NULL ENABLE);
  ALTER TABLE "GWC_WELLCATEGORIES" MODIFY ("CATEGORY_ID" NOT NULL ENABLE);
  ALTER TABLE "GWC_WELLCATEGORIES" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "GWC_WELLCATEGORIES" ADD CONSTRAINT "PK_GWC_WELLCATEGORIES" PRIMARY KEY ("TYPE_ID", "CATEGORY_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWC_WELLCATEGORY_TYPES
--------------------------------------------------------

  ALTER TABLE "GWC_WELLCATEGORY_TYPES" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWC_WELLCATEGORY_TYPES" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "GWC_WELLCATEGORY_TYPES" ADD CONSTRAINT "PK_GWC_WELLCATEGORY_TYPES" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWM_DEPTHS
--------------------------------------------------------

  ALTER TABLE "GWM_DEPTHS" ADD CONSTRAINT "GWB_DEPTHS_PK" PRIMARY KEY ("WELL_ID", "DEPTH")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWM_PERSONS
--------------------------------------------------------

  ALTER TABLE "GWM_PERSONS" ADD CONSTRAINT "GWB_PERSONS_PK" PRIMARY KEY ("PERSON_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWM_PICTURECATEGORIESCAT
--------------------------------------------------------

  ALTER TABLE "GWM_PICTURECATEGORIESCAT" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWM_PICTURECATEGORIESCAT" MODIFY ("PICTURECATEGORY" NOT NULL ENABLE);
  ALTER TABLE "GWM_PICTURECATEGORIESCAT" ADD CONSTRAINT "GWM_PICTURECATEGORIESCAT_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWM_ROUTES
--------------------------------------------------------

  ALTER TABLE "GWM_ROUTES" ADD CONSTRAINT "GWB_ROUTES_PK" PRIMARY KEY ("ROUTE_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWM_ROUTES_WELLS
--------------------------------------------------------

  ALTER TABLE "GWM_ROUTES_WELLS" ADD CONSTRAINT "GWB_ROUTES_WELLS_PK" PRIMARY KEY ("ROUTE_ID", "WELL_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWW_DATASTATUS
--------------------------------------------------------

  ALTER TABLE "GWW_DATASTATUS" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GWW_DATASTATUS" MODIFY ("DATATYPE" NOT NULL ENABLE);
  ALTER TABLE "GWW_DATASTATUS" MODIFY ("PARAMID" NOT NULL ENABLE);
  ALTER TABLE "GWW_DATASTATUS" ADD CONSTRAINT "PK_GWW_DATASTATUS" PRIMARY KEY ("MSID", "DATATYPE", "PARAMID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWW_LAYERS
--------------------------------------------------------

  ALTER TABLE "GWW_LAYERS" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWW_LAYERS" MODIFY ("FILENAME" NOT NULL ENABLE);
  ALTER TABLE "GWW_LAYERS" MODIFY ("DIRECTORY" NOT NULL ENABLE);
  ALTER TABLE "GWW_LAYERS" ADD CONSTRAINT "PK_GWW_LAYERS" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWW_MAPS
--------------------------------------------------------

  ALTER TABLE "GWW_MAPS" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWW_MAPS" ADD CONSTRAINT "PK_GWW_MAPS" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWW_MAPSERVICES
--------------------------------------------------------

  ALTER TABLE "GWW_MAPSERVICES" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWW_MAPSERVICES" ADD CONSTRAINT "PK_GWW_MAPSERVICES" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWW_PROFILES
--------------------------------------------------------

  ALTER TABLE "GWW_PROFILES" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWW_PROFILES" MODIFY ("FILENAME" NOT NULL ENABLE);
  ALTER TABLE "GWW_PROFILES" MODIFY ("DIRECTORY" NOT NULL ENABLE);
  ALTER TABLE "GWW_PROFILES" ADD CONSTRAINT "PK_GWW_PROFILES" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWW_WEBCONFIG
--------------------------------------------------------

  ALTER TABLE "GWW_WEBCONFIG" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "GWW_WEBCONFIG" ADD CONSTRAINT "PK_GWW_WEBCONFIG" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table GWW_WELLDATACOUNTS
--------------------------------------------------------

  ALTER TABLE "GWW_WELLDATACOUNTS" MODIFY ("MSID" NOT NULL ENABLE);
  ALTER TABLE "GWW_WELLDATACOUNTS" ADD CONSTRAINT "PK_GWW_WELLDATACOUNTS" PRIMARY KEY ("MSID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table REPITEMS
--------------------------------------------------------

  ALTER TABLE "REPITEMS" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "REPITEMS" MODIFY ("REPORTTYPE" NOT NULL ENABLE);
  ALTER TABLE "REPITEMS" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "REPITEMS" ADD CONSTRAINT "REPITEMS_PK" PRIMARY KEY ("ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table RST_APPCONFIG
--------------------------------------------------------

  ALTER TABLE "RST_APPCONFIG" MODIFY ("MANDANT_ID" NOT NULL ENABLE);
  ALTER TABLE "RST_APPCONFIG" MODIFY ("MODULE_ID" NOT NULL ENABLE);
  ALTER TABLE "RST_APPCONFIG" MODIFY ("KEY_" NOT NULL ENABLE);
  ALTER TABLE "RST_APPCONFIG" ADD CONSTRAINT "PK_RST_APPCONFIG" PRIMARY KEY ("MANDANT_ID", "MODULE_ID", "KEY_")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table RST_DBVERSION
--------------------------------------------------------

  ALTER TABLE "RST_DBVERSION" MODIFY ("MANDANT_ID" NOT NULL ENABLE);
  ALTER TABLE "RST_DBVERSION" MODIFY ("MODULE_ID" NOT NULL ENABLE);
  ALTER TABLE "RST_DBVERSION" ADD CONSTRAINT "PK_RST_DBVERSION" PRIMARY KEY ("MANDANT_ID", "MODULE_ID")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Constraints for Table RST_SYNCHRONIZE
--------------------------------------------------------

  ALTER TABLE "RST_SYNCHRONIZE" MODIFY ("MANDANT_ID" NOT NULL ENABLE);
  ALTER TABLE "RST_SYNCHRONIZE" MODIFY ("MODULE_ID" NOT NULL ENABLE);
  ALTER TABLE "RST_SYNCHRONIZE" MODIFY ("ACTION_" NOT NULL ENABLE);
  ALTER TABLE "RST_SYNCHRONIZE" ADD CONSTRAINT "PK_RST_SYNCHRONIZE" PRIMARY KEY ("MANDANT_ID", "MODULE_ID", "ACTION_")
  USING INDEX  ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GPD_ASBBOHRLOCH
--------------------------------------------------------

  ALTER TABLE "GPD_ASBBOHRLOCH" ADD CONSTRAINT "FK_GPD_ASBBOHRLOCH_1" FOREIGN KEY ("MSID")
	  REFERENCES "GPD_MSSTAMM" ("MSID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GPD_ASBFILTER
--------------------------------------------------------

  ALTER TABLE "GPD_ASBFILTER" ADD CONSTRAINT "FK_GPD_ASBFILTER_1" FOREIGN KEY ("MSID", "AFI_ROHRRECID")
	  REFERENCES "GPD_ASBVERROHRUNG" ("MSID", "RECID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GPD_ASBSONDERBAU
--------------------------------------------------------

  ALTER TABLE "GPD_ASBSONDERBAU" ADD CONSTRAINT "FK_GPD_ASBSONDERBAU_1" FOREIGN KEY ("MSID")
	  REFERENCES "GPD_MSSTAMM" ("MSID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GPD_ASBVERFUELLUNG
--------------------------------------------------------

  ALTER TABLE "GPD_ASBVERFUELLUNG" ADD CONSTRAINT "FK_GPD_ASBVERFUELLUNG_1" FOREIGN KEY ("MSID")
	  REFERENCES "GPD_MSSTAMM" ("MSID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GPD_ASBVERROHRUNG
--------------------------------------------------------

  ALTER TABLE "GPD_ASBVERROHRUNG" ADD CONSTRAINT "FK_GPD_ASBVERROHRUNG_1" FOREIGN KEY ("MSID")
	  REFERENCES "GPD_MSSTAMM" ("MSID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GPD_HYDROPARAM
--------------------------------------------------------

  ALTER TABLE "GPD_HYDROPARAM" ADD CONSTRAINT "FK_GPD_HYDROPARAM_1" FOREIGN KEY ("MSID")
	  REFERENCES "GPD_MSSTAMM" ("MSID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GPD_KLUEFTE
--------------------------------------------------------

  ALTER TABLE "GPD_KLUEFTE" ADD CONSTRAINT "FK_GPD_KLUEFTE_1" FOREIGN KEY ("MSID")
	  REFERENCES "GPD_MSSTAMM" ("MSID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GPD_LOG
--------------------------------------------------------

  ALTER TABLE "GPD_LOG" ADD CONSTRAINT "FK_GPD_LOG_1" FOREIGN KEY ("MSID")
	  REFERENCES "GPD_MSSTAMM" ("MSID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GPD_LOGDATA
--------------------------------------------------------

  ALTER TABLE "GPD_LOGDATA" ADD CONSTRAINT "FK_GPD_LOGDATA_1" FOREIGN KEY ("MSID", "LD_LOGRECID")
	  REFERENCES "GPD_LOG" ("MSID", "RECID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GPD_MSPASSCONFIG
--------------------------------------------------------

  ALTER TABLE "GPD_MSPASSCONFIG" ADD CONSTRAINT "FK_GPD_MSPASSCONFIG_1" FOREIGN KEY ("MSID")
	  REFERENCES "GPD_MSSTAMM" ("MSID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GPD_MSSYNONYME
--------------------------------------------------------

  ALTER TABLE "GPD_MSSYNONYME" ADD CONSTRAINT "FK_GPD_MSSYNONYME_1" FOREIGN KEY ("MSID")
	  REFERENCES "GPD_MSSTAMM" ("MSID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GPD_PACKERTEST
--------------------------------------------------------

  ALTER TABLE "GPD_PACKERTEST" ADD CONSTRAINT "FK_GPD_PACKERTEST_1" FOREIGN KEY ("MSID")
	  REFERENCES "GPD_MSSTAMM" ("MSID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GPD_SCHICHTEN
--------------------------------------------------------

  ALTER TABLE "GPD_SCHICHTEN" ADD CONSTRAINT "FK_GPD_SCHICHTEN_1" FOREIGN KEY ("MSID")
	  REFERENCES "GPD_MSSTAMM" ("MSID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GPD_SCHICHTTITEL
--------------------------------------------------------

  ALTER TABLE "GPD_SCHICHTTITEL" ADD CONSTRAINT "FK_GPD_SCHICHTTITEL_1" FOREIGN KEY ("MSID")
	  REFERENCES "GPD_MSSTAMM" ("MSID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GPD_SPUELUNG
--------------------------------------------------------

  ALTER TABLE "GPD_SPUELUNG" ADD CONSTRAINT "FK_GPD_SPUELUNG_1" FOREIGN KEY ("MSID")
	  REFERENCES "GPD_MSSTAMM" ("MSID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GPD_WASSERRECHT
--------------------------------------------------------

  ALTER TABLE "GPD_WASSERRECHT" ADD CONSTRAINT "FK_GPD_WASSERRECHT_1" FOREIGN KEY ("MSID")
	  REFERENCES "GPD_MSSTAMM" ("MSID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_ANALYSEN
--------------------------------------------------------

  ALTER TABLE "GWB_ANALYSEN" ADD CONSTRAINT "GWB_ANALY_METHODS_FK" FOREIGN KEY ("METHOD_ID")
	  REFERENCES "GWB_ANALYMETHODS" ("ID") ENABLE;
  ALTER TABLE "GWB_ANALYSEN" ADD CONSTRAINT "GWB_ANALYSEN_MEASDATE_FK" FOREIGN KEY ("DATUMID")
	  REFERENCES "GWB_MEASDATE" ("ID") ON DELETE CASCADE ENABLE;
  ALTER TABLE "GWB_ANALYSEN" ADD CONSTRAINT "GWB_ANALYSEN_PARAMETER_FK" FOREIGN KEY ("PARAMETERID")
	  REFERENCES "GWB_PARAMET" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_CHECKRULES
--------------------------------------------------------

  ALTER TABLE "GWB_CHECKRULES" ADD CONSTRAINT "GWB_CHECKRULES_PARAM_FK" FOREIGN KEY ("CR_PARAMID")
	  REFERENCES "GWB_PARAMET" ("ID") ON DELETE CASCADE ENABLE;
  ALTER TABLE "GWB_CHECKRULES" ADD CONSTRAINT "GWB_CHECKRULES_WELL_FK" FOREIGN KEY ("CR_WELLID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_CHECKRULES_TEMPLATES
--------------------------------------------------------

  ALTER TABLE "GWB_CHECKRULES_TEMPLATES" ADD CONSTRAINT "GWB_CHECKRULESTEMPL_PARAM_FK" FOREIGN KEY ("CR_PARAMID")
	  REFERENCES "GWB_PARAMET" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_CHECKRULES2
--------------------------------------------------------

  ALTER TABLE "GWB_CHECKRULES2" ADD CONSTRAINT "GWB_CHECKRULES2_PARAM_FK" FOREIGN KEY ("CR_PARAMID")
	  REFERENCES "GWB_PARAMET" ("ID") ON DELETE CASCADE ENABLE;
  ALTER TABLE "GWB_CHECKRULES2" ADD CONSTRAINT "GWB_CHECKRULES2_WELL_FK" FOREIGN KEY ("CR_WELLID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_CLASS_PARAM
--------------------------------------------------------

  ALTER TABLE "GWB_CLASS_PARAM" ADD CONSTRAINT "GWB_CLASSPARAM_CLASS_FK" FOREIGN KEY ("CLASS_ID")
	  REFERENCES "GWB_STOFFKL" ("CLASS_ID") ON DELETE CASCADE ENABLE;
  ALTER TABLE "GWB_CLASS_PARAM" ADD CONSTRAINT "GWB_CLASSPARAM_PARAMETER_FK" FOREIGN KEY ("PARAM_ID")
	  REFERENCES "GWB_PARAMET" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_DISCHARGESTATISTIC
--------------------------------------------------------

  ALTER TABLE "GWB_DISCHARGESTATISTIC" ADD CONSTRAINT "GWB_DISCHARGESTAT_WELL_FK" FOREIGN KEY ("WELL_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_HCHANGE
--------------------------------------------------------

  ALTER TABLE "GWB_HCHANGE" ADD CONSTRAINT "GWB_HCHANGE_WELLS_FK" FOREIGN KEY ("MESSTELLENID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_INOUTLETSTRUCTURE
--------------------------------------------------------

  ALTER TABLE "GWB_INOUTLETSTRUCTURE" ADD CONSTRAINT "GWB_INOUTLETSTRUCTURE_OBJECT_FK" FOREIGN KEY ("OBJECT_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_LEVEL_ATTRIBUTES
--------------------------------------------------------

  ALTER TABLE "GWB_LEVEL_ATTRIBUTES" ADD CONSTRAINT "GWB_LEVELATTR_COMMENTS_FK" FOREIGN KEY ("LA_ATTRIBUTE_ID")
	  REFERENCES "GWB_LEVELCOMMENTS" ("COMMENTID") ENABLE;
  ALTER TABLE "GWB_LEVEL_ATTRIBUTES" ADD CONSTRAINT "GWB_LEVELATTR_DATES_FK" FOREIGN KEY ("LA_DATE_ID")
	  REFERENCES "GWB_WSTAND" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_LEVELCOMMENTS
--------------------------------------------------------

  ALTER TABLE "GWB_LEVELCOMMENTS" ADD CONSTRAINT "GWB_LEVELCOMM_TODOCAT_FK" FOREIGN KEY ("TODOCATEGORY_ID")
	  REFERENCES "GWB_TODOCATEGORIES" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_MANHOLE
--------------------------------------------------------

  ALTER TABLE "GWB_MANHOLE" ADD CONSTRAINT "GWB_MANHOLE_OBJECT_FK" FOREIGN KEY ("OBJECT_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ON DELETE CASCADE ENABLE;
  ALTER TABLE "GWB_MANHOLE" ADD CONSTRAINT "GWB_MANHOLE_MATERIAL_FK" FOREIGN KEY ("MATERIAL_ID")
	  REFERENCES "GWB_BUILDINGMATERIALCAT" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_MEASDATE
--------------------------------------------------------

  ALTER TABLE "GWB_MEASDATE" ADD CONSTRAINT "GWB_MEASDATE_WELL_FK" FOREIGN KEY ("MESSTELLENID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_MEMOS
--------------------------------------------------------

  ALTER TABLE "GWB_MEMOS" ADD CONSTRAINT "GWB_MEMOS_WELLS_FK" FOREIGN KEY ("WELL_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_MISCSTRUCTURE
--------------------------------------------------------

  ALTER TABLE "GWB_MISCSTRUCTURE" ADD CONSTRAINT "GWB_MISCSTRUCTURE_OBJECT_FK" FOREIGN KEY ("OBJECT_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_MSSTAMM
--------------------------------------------------------

  ALTER TABLE "GWB_MSSTAMM" ADD CONSTRAINT "GWB_WELLS_AQUIFER_FK" FOREIGN KEY ("AQUIFER_ID")
	  REFERENCES "GWB_GWSTOCKW" ("ID") ENABLE;
  ALTER TABLE "GWB_MSSTAMM" ADD CONSTRAINT "GWB_WELLS_GEOLOGY_FK" FOREIGN KEY ("GEOLOGY_ID")
	  REFERENCES "GWB_GEOLOGIE" ("ID") ENABLE;
  ALTER TABLE "GWB_MSSTAMM" ADD CONSTRAINT "GWB_MSSTAMM_STATUS_FK" FOREIGN KEY ("STATUS_ID")
	  REFERENCES "GWB_WELLSTATUSCAT" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_OBJECT_PIPES
--------------------------------------------------------

  ALTER TABLE "GWB_OBJECT_PIPES" ADD CONSTRAINT "GWB_OBJECT_PIPES_OBJECT_FK" FOREIGN KEY ("OBJECT_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ON DELETE CASCADE ENABLE;
  ALTER TABLE "GWB_OBJECT_PIPES" ADD CONSTRAINT "GWB_OBJECT_PIPES_WATERTYPE_FK" FOREIGN KEY ("WATERTYPE_ID")
	  REFERENCES "GWB_WATERTYPECAT" ("ID") ENABLE;
  ALTER TABLE "GWB_OBJECT_PIPES" ADD CONSTRAINT "GWB_OBJECT_PIPES_INPUTPIPE_FK" FOREIGN KEY ("INPUTPIPE_ID")
	  REFERENCES "GWB_PIPES" ("ID") ENABLE;
  ALTER TABLE "GWB_OBJECT_PIPES" ADD CONSTRAINT "GWB_OBJECT_PIPES_OUTPUTPIPE_FK" FOREIGN KEY ("OUTPUTPIPE_ID")
	  REFERENCES "GWB_PIPES" ("ID") ENABLE;
  ALTER TABLE "GWB_OBJECT_PIPES" ADD CONSTRAINT "GWB_OBJECT_PIPES_PIPETYPE_FK" FOREIGN KEY ("PIPETYPE_ID")
	  REFERENCES "GWB_PIPETYPECAT" ("ID") ENABLE;
  ALTER TABLE "GWB_OBJECT_PIPES" ADD CONSTRAINT "GWB_OBJECT_PIPES_MATERIAL_FK" FOREIGN KEY ("MATERIAL_ID")
	  REFERENCES "GWB_PIPEMATERIALCAT" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_OBJECT_TECHPARTS
--------------------------------------------------------

  ALTER TABLE "GWB_OBJECT_TECHPARTS" ADD CONSTRAINT "GWB_OBJECT_TECHPARTS_OBJECT_FK" FOREIGN KEY ("OBJECT_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ON DELETE CASCADE ENABLE;
  ALTER TABLE "GWB_OBJECT_TECHPARTS" ADD CONSTRAINT "GWB_OBJECT_TECHPARTS_PART_FK" FOREIGN KEY ("PART_ID")
	  REFERENCES "GWB_TECHPARTSCAT" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_PARAMET
--------------------------------------------------------

  ALTER TABLE "GWB_PARAMET" ADD CONSTRAINT "GWB_PARAM_METHODS_FK" FOREIGN KEY ("STDMETHOD_ID")
	  REFERENCES "GWB_ANALYMETHODS" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_PARAM_VALUECLASSES
--------------------------------------------------------

  ALTER TABLE "GWB_PARAM_VALUECLASSES" ADD CONSTRAINT "GWB_PVC_PARAM_FK" FOREIGN KEY ("PARAM_ID")
	  REFERENCES "GWB_PARAMET" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_PROBEN
--------------------------------------------------------

  ALTER TABLE "GWB_PROBEN" ADD CONSTRAINT "GWB_PROBEN_MEASDATE_FK" FOREIGN KEY ("DATUMID")
	  REFERENCES "GWB_MEASDATE" ("ID") ON DELETE CASCADE ENABLE;
  ALTER TABLE "GWB_PROBEN" ADD CONSTRAINT "GWB_PROBEN_REASON_FK" FOREIGN KEY ("REASON_ID")
	  REFERENCES "GWB_SAMPLINGREASONS" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_PROGGROUPS_PROGS
--------------------------------------------------------

  ALTER TABLE "GWB_PROGGROUPS_PROGS" ADD CONSTRAINT "GWB_PRGRPR_GROUP_FK" FOREIGN KEY ("GROUP_ID")
	  REFERENCES "GWB_PROGGROUPS" ("ID") ON DELETE CASCADE ENABLE;
  ALTER TABLE "GWB_PROGGROUPS_PROGS" ADD CONSTRAINT "GWB_PRGRPR_PROG_FK" FOREIGN KEY ("PROG_ID")
	  REFERENCES "GWB_UKAT" ("KATALOGNR") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_PROG_PARAM
--------------------------------------------------------

  ALTER TABLE "GWB_PROG_PARAM" ADD CONSTRAINT "GWB_PROGPARAM_PARAMETER_FK" FOREIGN KEY ("PARAM_ID")
	  REFERENCES "GWB_PARAMET" ("ID") ON DELETE CASCADE ENABLE;
  ALTER TABLE "GWB_PROG_PARAM" ADD CONSTRAINT "GWB_PROGPARAM_PROG_FK" FOREIGN KEY ("PROG_ID")
	  REFERENCES "GWB_UKAT" ("KATALOGNR") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_PROJECTS_USERS
--------------------------------------------------------

  ALTER TABLE "GWB_PROJECTS_USERS" ADD CONSTRAINT "GWB_PROJECTSUSERS_PROJECTS_FK" FOREIGN KEY ("PU_PROJECTID")
	  REFERENCES "GWB_PROJECTS" ("ID") ON DELETE CASCADE ENABLE;
  ALTER TABLE "GWB_PROJECTS_USERS" ADD CONSTRAINT "GWB_PROJECTSUSERS_USERS_FK" FOREIGN KEY ("PU_LOGINNAME")
	  REFERENCES "GWB_USERS" ("US_LOGINNAME") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_PUMP_DATA
--------------------------------------------------------

  ALTER TABLE "GWB_PUMP_DATA" ADD CONSTRAINT "GWB_PUMPDATA_EQUIP_FK" FOREIGN KEY ("EQUIP_ID")
	  REFERENCES "GWB_TECHEQUIPMENT" ("ID") ENABLE;
  ALTER TABLE "GWB_PUMP_DATA" ADD CONSTRAINT "GWB_PUMPDATA_WELL_FK" FOREIGN KEY ("WELL_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_RAINFALL
--------------------------------------------------------

  ALTER TABLE "GWB_RAINFALL" ADD CONSTRAINT "GWB_RAINFALL_WELLS_FK" FOREIGN KEY ("WELL_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_RATES
--------------------------------------------------------

  ALTER TABLE "GWB_RATES" ADD CONSTRAINT "GWB_RATES_WELLS_FK" FOREIGN KEY ("MESSTELLENID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_REPORTGROUPS_PARAMGROUPS
--------------------------------------------------------

  ALTER TABLE "GWB_REPORTGROUPS_PARAMGROUPS" ADD CONSTRAINT "GWB_RGPG_GROUP_FK" FOREIGN KEY ("GROUP_ID")
	  REFERENCES "GWB_REPORTGROUPS" ("ID") ON DELETE CASCADE ENABLE;
  ALTER TABLE "GWB_REPORTGROUPS_PARAMGROUPS" ADD CONSTRAINT "GWB_RGPG_PARAMGROUP_FK" FOREIGN KEY ("PARAMGROUP_ID")
	  REFERENCES "GWB_STOFFKL" ("CLASS_ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_REPORTGROUPS_PARAMS
--------------------------------------------------------

  ALTER TABLE "GWB_REPORTGROUPS_PARAMS" ADD CONSTRAINT "GWB_RGP_GROUP_FK" FOREIGN KEY ("GROUP_ID")
	  REFERENCES "GWB_REPORTGROUPS" ("ID") ON DELETE CASCADE ENABLE;
  ALTER TABLE "GWB_REPORTGROUPS_PARAMS" ADD CONSTRAINT "GWB_RGP_PARAM_FK" FOREIGN KEY ("PARAM_ID")
	  REFERENCES "GWB_PARAMET" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_REPORTGROUPS_STATIONS
--------------------------------------------------------

  ALTER TABLE "GWB_REPORTGROUPS_STATIONS" ADD CONSTRAINT "GWB_RGS_GROUP_FK" FOREIGN KEY ("GROUP_ID")
	  REFERENCES "GWB_REPORTGROUPS" ("ID") ON DELETE CASCADE ENABLE;
  ALTER TABLE "GWB_REPORTGROUPS_STATIONS" ADD CONSTRAINT "GWB_RGS_STATION_FK" FOREIGN KEY ("STATION_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_REPORTGROUPS_TEMPLATES
--------------------------------------------------------

  ALTER TABLE "GWB_REPORTGROUPS_TEMPLATES" ADD CONSTRAINT "GWB_RGT_GROUP_FK" FOREIGN KEY ("GROUP_ID")
	  REFERENCES "GWB_REPORTGROUPS" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_SAMPLECALENDAR
--------------------------------------------------------

  ALTER TABLE "GWB_SAMPLECALENDAR" ADD CONSTRAINT "GWB_SAMPLECALENDAR_PRGR_FK" FOREIGN KEY ("PROGGROUP_ID")
	  REFERENCES "GWB_PROGGROUPS" ("ID") ENABLE;
  ALTER TABLE "GWB_SAMPLECALENDAR" ADD CONSTRAINT "GWB_SAMPLECALENDAR_WELL_FK" FOREIGN KEY ("WELL_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_SAMPLES_PROGS
--------------------------------------------------------

  ALTER TABLE "GWB_SAMPLES_PROGS" ADD CONSTRAINT "GWB_SAMPLESPROGS_PROG_FK" FOREIGN KEY ("PROG_ID")
	  REFERENCES "GWB_UKAT" ("KATALOGNR") ON DELETE CASCADE ENABLE;
  ALTER TABLE "GWB_SAMPLES_PROGS" ADD CONSTRAINT "GWB_SAMPLESPROGS_SAMPLE_FK" FOREIGN KEY ("SAMPLE_ID")
	  REFERENCES "GWB_MEASDATE" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_SENSORDEPTH
--------------------------------------------------------

  ALTER TABLE "GWB_SENSORDEPTH" ADD CONSTRAINT "GWB_SENSORDEPTH_WELL_FK" FOREIGN KEY ("WELL_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_SPEC_YIELD
--------------------------------------------------------

  ALTER TABLE "GWB_SPEC_YIELD" ADD CONSTRAINT "GWB_SPEC_YIELD_WELL_FK" FOREIGN KEY ("WELL_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_STNFLOWDEVICEHISTORY
--------------------------------------------------------

  ALTER TABLE "GWB_STNFLOWDEVICEHISTORY" ADD CONSTRAINT "GWB_STNFLOWDEVICEHISTORY_STN_FK" FOREIGN KEY ("STATION_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ON DELETE CASCADE ENABLE;
  ALTER TABLE "GWB_STNFLOWDEVICEHISTORY" ADD CONSTRAINT "GWB_STNFLOWDEVICEHISTORY_DEVICE_FK" FOREIGN KEY ("FLOWDEVICE_ID")
	  REFERENCES "GWB_FLOWMEASUREMENTCAT" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_STOFFKL
--------------------------------------------------------

  ALTER TABLE "GWB_STOFFKL" ADD CONSTRAINT "GWB_STOFFKL_PARAMET_FK" FOREIGN KEY ("SUMPARAM_ID")
	  REFERENCES "GWB_PARAMET" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_STOREDRIVERNET_AQUIFERS
--------------------------------------------------------

  ALTER TABLE "GWB_STOREDRIVERNET_AQUIFERS" ADD CONSTRAINT "GWB_SRNETAQUI_AQUIFER_FK" FOREIGN KEY ("AQUIFER_ID")
	  REFERENCES "GWB_GWSTOCKW" ("ID") ON DELETE CASCADE ENABLE;
  ALTER TABLE "GWB_STOREDRIVERNET_AQUIFERS" ADD CONSTRAINT "GWB_SRNETAQUI_RIVERNET_FK" FOREIGN KEY ("STOREDRIVERNET_ID")
	  REFERENCES "GWB_STOREDRIVERNETS" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_STOREDRIVERNET_POINTS
--------------------------------------------------------

  ALTER TABLE "GWB_STOREDRIVERNET_POINTS" ADD CONSTRAINT "GWB_SRNETPNTS_RIVERNET_FK" FOREIGN KEY ("STOREDRIVERNET_ID")
	  REFERENCES "GWB_STOREDRIVERNETS" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_STRUCTPARTS
--------------------------------------------------------

  ALTER TABLE "GWB_STRUCTPARTS" ADD CONSTRAINT "GWB_STRUCTPARTS_STRUCT_FK" FOREIGN KEY ("STRUCT_ID")
	  REFERENCES "GWB_STRUCTURES" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_STRUCTPARTS_AQUIFERS
--------------------------------------------------------

  ALTER TABLE "GWB_STRUCTPARTS_AQUIFERS" ADD CONSTRAINT "GWB_SPAQUI_AQUIFER_FK" FOREIGN KEY ("AQUIFER_ID")
	  REFERENCES "GWB_GWSTOCKW" ("ID") ON DELETE CASCADE ENABLE;
  ALTER TABLE "GWB_STRUCTPARTS_AQUIFERS" ADD CONSTRAINT "GWB_SPAQUI_STRUCTPART_FK" FOREIGN KEY ("STRUCTPART_ID")
	  REFERENCES "GWB_STRUCTPARTS" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_STRUCTPARTS_POINTS
--------------------------------------------------------

  ALTER TABLE "GWB_STRUCTPARTS_POINTS" ADD CONSTRAINT "GWB_SPPOINTS_STRUCTPART_FK" FOREIGN KEY ("STRUCTPART_ID")
	  REFERENCES "GWB_STRUCTPARTS" ("ID") ON DELETE CASCADE ENABLE;
  ALTER TABLE "GWB_STRUCTPARTS_POINTS" ADD CONSTRAINT "GWB_SPPOINTS_STRUCTPOINT_FK" FOREIGN KEY ("POINT_ID")
	  REFERENCES "GWB_STRUCTPOINTS" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_STRUCTPOINTS
--------------------------------------------------------

  ALTER TABLE "GWB_STRUCTPOINTS" ADD CONSTRAINT "GWB_STRUCTPOINTS_WELLS_FK" FOREIGN KEY ("STATION_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_SURFACEWATER_PARTS
--------------------------------------------------------

  ALTER TABLE "GWB_SURFACEWATER_PARTS" ADD CONSTRAINT "GWB_SWPARTS_MAINSW_FK" FOREIGN KEY ("MAIN_ID")
	  REFERENCES "GWB_SURFACEWATERS" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_TECHEQUIP_HISTORY
--------------------------------------------------------

  ALTER TABLE "GWB_TECHEQUIP_HISTORY" ADD CONSTRAINT "GWB_TEHISTORY_EQUIP_FK" FOREIGN KEY ("EQUIP_ID")
	  REFERENCES "GWB_TECHEQUIPMENT" ("ID") ENABLE;
  ALTER TABLE "GWB_TECHEQUIP_HISTORY" ADD CONSTRAINT "GWB_TEHISTORY_WELLS_FK" FOREIGN KEY ("WELL_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_TECHEQUIP_REPAIRS
--------------------------------------------------------

  ALTER TABLE "GWB_TECHEQUIP_REPAIRS" ADD CONSTRAINT "GWB_TEREPAIRS_EQUIP_FK" FOREIGN KEY ("EQUIP_ID")
	  REFERENCES "GWB_TECHEQUIPMENT" ("ID") ENABLE;
  ALTER TABLE "GWB_TECHEQUIP_REPAIRS" ADD CONSTRAINT "GWB_TEREPAIRS_HISTORY_FK" FOREIGN KEY ("HISTORY_ID")
	  REFERENCES "GWB_TECHEQUIP_HISTORY" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_TECHEQUIP_STORES
--------------------------------------------------------

  ALTER TABLE "GWB_TECHEQUIP_STORES" ADD CONSTRAINT "GWB_TESTORES_EQUIP_FK" FOREIGN KEY ("EQUIP_ID")
	  REFERENCES "GWB_TECHEQUIPMENT" ("ID") ENABLE;
  ALTER TABLE "GWB_TECHEQUIP_STORES" ADD CONSTRAINT "GWB_TESTORES_HISTORY_FK" FOREIGN KEY ("HISTORY_ID")
	  REFERENCES "GWB_TECHEQUIP_HISTORY" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_TECHEQUIP_WELLS
--------------------------------------------------------

  ALTER TABLE "GWB_TECHEQUIP_WELLS" ADD CONSTRAINT "GWB_TEWELLS_EQUIP_FK" FOREIGN KEY ("EQUIP_ID")
	  REFERENCES "GWB_TECHEQUIPMENT" ("ID") ENABLE;
  ALTER TABLE "GWB_TECHEQUIP_WELLS" ADD CONSTRAINT "GWB_TEWELLS_HISTORY_FK" FOREIGN KEY ("HISTORY_ID")
	  REFERENCES "GWB_TECHEQUIP_HISTORY" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_VALVEPOSITION
--------------------------------------------------------

  ALTER TABLE "GWB_VALVEPOSITION" ADD CONSTRAINT "GWB_VALVEPOSITION_VALVE_FK" FOREIGN KEY ("VALVE_ID")
	  REFERENCES "GWB_VALVES" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_VALVES
--------------------------------------------------------

  ALTER TABLE "GWB_VALVES" ADD CONSTRAINT "GWB_VALVES_OBJECT_FK" FOREIGN KEY ("OBJECT_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_VIRTUALWELLS
--------------------------------------------------------

  ALTER TABLE "GWB_VIRTUALWELLS" ADD CONSTRAINT "GWB_VIRTUALWELLS_WELLS_FK" FOREIGN KEY ("REFERENCESTATION_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_WELLGEOLOGY
--------------------------------------------------------

  ALTER TABLE "GWB_WELLGEOLOGY" ADD CONSTRAINT "GWB_WELLGEOLOGY_GEOL_FK" FOREIGN KEY ("GEOLOGY_ID")
	  REFERENCES "GWB_GEOLOGIE" ("ID") ENABLE;
  ALTER TABLE "GWB_WELLGEOLOGY" ADD CONSTRAINT "GWB_WELLGEOLOGY_WELL_FK" FOREIGN KEY ("WELL_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_WELLPROPERTIES_VALUES
--------------------------------------------------------

  ALTER TABLE "GWB_WELLPROPERTIES_VALUES" ADD CONSTRAINT "GWB_WPVALUES_PROPERTY_FK" FOREIGN KEY ("PROPERTY_ID")
	  REFERENCES "GWB_WELLPROPERTIES" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_WELLSTATUSHISTORY
--------------------------------------------------------

  ALTER TABLE "GWB_WELLSTATUSHISTORY" ADD CONSTRAINT "GWB_WELLSTATUSHISTORY_WELL_FK" FOREIGN KEY ("WELL_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ON DELETE CASCADE ENABLE;
  ALTER TABLE "GWB_WELLSTATUSHISTORY" ADD CONSTRAINT "GWB_WELLSTATUSHISTORY_STATUS_FK" FOREIGN KEY ("STATUS_ID")
	  REFERENCES "GWB_WELLSTATUSCAT" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_WELLTODOLIST
--------------------------------------------------------

  ALTER TABLE "GWB_WELLTODOLIST" ADD CONSTRAINT "GWB_WELLTODOLIST_CAT_FK" FOREIGN KEY ("CATEGORY_ID")
	  REFERENCES "GWB_TODOCATEGORIES" ("ID") ENABLE;
  ALTER TABLE "GWB_WELLTODOLIST" ADD CONSTRAINT "GWB_WELLTODOLIST_WELL_FK" FOREIGN KEY ("WELL_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWB_WSTAND
--------------------------------------------------------

  ALTER TABLE "GWB_WSTAND" ADD CONSTRAINT "GWB_WSTAND_WELLS_FK" FOREIGN KEY ("MESSTELLENID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWM_DEPTHS
--------------------------------------------------------

  ALTER TABLE "GWM_DEPTHS" ADD CONSTRAINT "GWM_DEPTHS_WELL_FK" FOREIGN KEY ("WELL_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ON DELETE CASCADE ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table GWM_ROUTES_WELLS
--------------------------------------------------------

  ALTER TABLE "GWM_ROUTES_WELLS" ADD CONSTRAINT "GWM_ROUTESWELLS_ROUTE_FK" FOREIGN KEY ("ROUTE_ID")
	  REFERENCES "GWM_ROUTES" ("ROUTE_ID") ON DELETE CASCADE ENABLE;
  ALTER TABLE "GWM_ROUTES_WELLS" ADD CONSTRAINT "GWM_ROUTESWELLS_WELL_FK" FOREIGN KEY ("WELL_ID")
	  REFERENCES "GWB_MSSTAMM" ("ID") ON DELETE CASCADE ENABLE;
