-- ============================================================ -- Stand 2015-02-24 (TC) -- ============================================================ create table AG ( AGPLANNR FLOAT , AGNR NUMBER(5,0) , AGAG VARCHAR2(20) , AGVERS VARCHAR2(10) , AGBEZ VARCHAR2(50) , AGMAT NUMBER(5,0) , AGKOST NUMBER(5,0) , AGMASCH NUMBER(5,0) , AGMASSN VARCHAR2(50) , AGERST NUMBER(5,0) , AGERSTDAT DATE , AGAENDER NUMBER(5,0) , AGAENDERDAT DATE ) TABLESPACE QDAS_DEFAULT; create table AUFTRGEB ( AULFDNR NUMBER(10,0) , AUNR VARCHAR2(50) , AUNAME1 VARCHAR2(100) , AUNAME2 VARCHAR2(80) , AULAND VARCHAR2(50) , AUPLZ VARCHAR2(10) , AUORT VARCHAR2(50) , AUSTRASSE VARCHAR2(50) , AUPOSTFACH VARCHAR2(20) , AUWERK VARCHAR2(50) , AUWERKSSCHL VARCHAR2(50) , AUMEMO LONG , AUGSTATE NUMBER(10,0) default 0 ) TABLESPACE QDAS_DEFAULT; create table AUSPRAEG ( AUGROUP NUMBER(5,0) , AUKEY NUMBER(5,0) , AUTEXT VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; create unique index AUSPRAEG on AUSPRAEG (AUGROUP, AUKEY); create table AUSPRAEGGRP ( AUGROUP NUMBER(5,0) , AUGRPTEXT VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; create unique index AUSPRAEGGRP on AUSPRAEGGRP (AUGROUP); create table BERART ( BEBERART NUMBER(5,0) , BETEXT VARCHAR2(80) ) TABLESPACE QDAS_DEFAULT; create table CHARGE ( CHTEIL NUMBER(10,0) , CHMERKMAL NUMBER(5,0) , CHUNTERS NUMBER(5,0) , CHWERTVON NUMBER(10,0) , CHWERTBIS NUMBER(10,0) , CHCHARGENR VARCHAR2(30) ) TABLESPACE QDAS_DEFAULT; create table CNF_PART ( CNNO NUMBER(5,0) , CNNAME VARCHAR2(255) , CNPOS NUMBER(3,0) ) TABLESPACE QDAS_DEFAULT; create unique index CNF_PART on CNF_PART (CNNO); create table EG_AEND ( EGTEIL NUMBER(10,0) , EGMERKMAL NUMBER(5,0) , EGUNTERS NUMBER(5,0) , EGWERTNR NUMBER(10,0) , EGCP FLOAT , EGCPK FLOAT , EGLAGART NUMBER(3,0) , EGLAGSTREU NUMBER(3,0) , EGLAGGRART NUMBER(3,0) , EGPEARSON NUMBER(3,0) , EGMINMAX FLOAT , EGMITTELW NUMBER(3,0) , EGCWERTGUE NUMBER(5,0) , EGCAUSGZUL NUMBER(3,0) , EGCUN FLOAT , EGCUN_UN FLOAT , EGCUN_OB FLOAT , EGCOB FLOAT , EGCOB_UN FLOAT , EGCOB_OB FLOAT , EGC FLOAT , EGC_UN FLOAT , EGC_OB FLOAT , EGCUNATR NUMBER(3,0) , EGCUNVBATR NUMBER(3,0) , EGCOBATR NUMBER(3,0) , EGCOBVBATR NUMBER(3,0) , EGCATR NUMBER(3,0) , EGCVBATR NUMBER(3,0) , EGCKATR NUMBER(3,0) , EGLAGEMIN FLOAT , EGLAGEMAX FLOAT , EGLAGUEG FLOAT , EGLAGMITTE FLOAT , EGLAGOEG FLOAT , EGLAGUWG FLOAT , EGLAGOWG FLOAT , EGLAGUUNT FLOAT , EGLAGUOB FLOAT , EGP_F FLOAT , EGEW_F FLOAT , EGGS_F FLOAT , EGSAQRKGSF FLOAT , EGSTRART NUMBER(3,0) , EGSTRSTREU NUMBER(3,0) , EGSTRBER NUMBER(3,0) , EGSTRUEG FLOAT , EGSTRMITTE FLOAT , EGSTROEG FLOAT , EGSTRUWG FLOAT , EGSTROWG FLOAT , EGSTRPQFSK FLOAT , EGSTRNQFSK FLOAT , EGDAT DATE , EGMASCHINE NUMBER(10,0) , EGNEST NUMBER(10,0) , EGUGW FLOAT , EGOGW FLOAT , EGNENNMASS FLOAT , EGLAGUIG FLOAT , EGLAGOIG FLOAT , EGSTRUIG FLOAT , EGSTROIG FLOAT, EG_LEXL FLOAT, EG_UEXL FLOAT, EG_EXSTART DATE, EG_EXEND DATE, EG_EXVALID NUMBER(3,0) ) TABLESPACE QDAS_DEFAULT; create unique index EG_AEND on EG_AEND (EGTEIL, EGMERKMAL, EGUNTERS, EGWERTNR, EGMASCHINE); create table EINHEIT ( EIEINHEIT NUMBER(5,0) , EIEINHTEXT VARCHAR2(100) , EISTATE NUMBER(10,0) default 0, EIBEMERK VARCHAR2(200) ) TABLESPACE QDAS_DEFAULT; create table EREIG ( ERTEIL NUMBER(10,0) , ERMERKMAL NUMBER(5,0) , ERUNTERS NUMBER(5,0) , ERWERTNR NUMBER(10,0) , ERLFDNR NUMBER(3,0) , ERTEXTNR NUMBER(5,0) , EREINFLUSS VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; create unique index EREIG on EREIG (ERTEIL, ERMERKMAL, ERUNTERS, ERWERTNR, ERLFDNR); create index ERTEXTNR on EREIG (ERTEXTNR); create table EREIGTXT ( ETTEXTNR NUMBER(5,0) , ETTEXT VARCHAR2(100) , ETCODE VARCHAR2(40) , ETSTATE NUMBER(10,0) default 0, ETCAQKENNUNG VARCHAR2(10), ETBEMERK VARCHAR2(200) ) TABLESPACE QDAS_DEFAULT; create unique index EREIGTXT on EREIGTXT (ETTEXTNR); create index ETTEXT on EREIGTXT (ETTEXT); create table ERFART ( EAERFART NUMBER(3,0) , EAERFNAME VARCHAR2(80) , EAPORTNR NUMBER(5,0) , EAPORTADDR NUMBER(5,0) , EAIRQ NUMBER(5,0) , EABAUD NUMBER(5,0) , EAPARITY NUMBER(5,0) , EADATABITS NUMBER(5,0) , EASTOPBITS NUMBER(5,0) ) TABLESPACE QDAS_DEFAULT; create table ERFMASCH ( EMERFID NUMBER(5,0) , EMERFTEXT VARCHAR2(80) ) TABLESPACE QDAS_DEFAULT; create table FEHLKLAS ( FKFEHLART NUMBER(3,0) , FKBESCHR VARCHAR2(80) ) TABLESPACE QDAS_DEFAULT; create table FERTART ( FTFERTART NUMBER(5,0) , FTNR VARCHAR2(20) , FTBESCHR VARCHAR2(80) ) TABLESPACE QDAS_DEFAULT; create table FSK ( FSTEIL NUMBER(10,0) , FSLFDNR NUMBER(5,0) , FSBEZEICH VARCHAR2(80) , FSUMFSTI NUMBER(3,0) , FSANZTEIL NUMBER(5,0) , FSBEM LONG ) TABLESPACE QDAS_DEFAULT; create table HERSTELL ( HELFDNR NUMBER(10,0) , HENR VARCHAR2(50) , HENAME1 VARCHAR2(80) , HENAME2 VARCHAR2(80) , HELAND VARCHAR2(50) , HEPLZ VARCHAR2(10) , HEORT VARCHAR2(50) , HESTRASSE VARCHAR2(50) , HEPOSTFACH VARCHAR2(20) , HEWERK VARCHAR2(50) , HEWERKSSCHL VARCHAR2(50) , HEMEMO LONG , HESTATE NUMBER(10,0) default 0 ) TABLESPACE QDAS_DEFAULT; create table KUNDE ( KULFDNR NUMBER(10,0) , KUNR VARCHAR2(50) , KUNAME1 VARCHAR2(80) , KUNAME2 VARCHAR2(80) , KULAND VARCHAR2(50) , KUPLZ VARCHAR2(10) , KUORT VARCHAR2(50) , KUSTRASSE VARCHAR2(50) , KUPOSTFACH VARCHAR2(20) , KUWERK VARCHAR2(50) , KUWERKSSCHL VARCHAR2(50) , KUMEMO LONG , KUSTATE NUMBER(10,0) default 0 ) TABLESPACE QDAS_DEFAULT; create table LIEFERAN ( LILFDNR NUMBER(10,0) , LINR VARCHAR2(50) , LINAME1 VARCHAR2(80) , LINAME2 VARCHAR2(80) , LILAND VARCHAR2(50) , LIPLZ VARCHAR2(10) , LIORT VARCHAR2(50) , LISTRASSE VARCHAR2(50) , LIPOSTFACH VARCHAR2(20) , LIWERK VARCHAR2(50) , LIWERKSSCHL VARCHAR2(50) , LIMEMO LONG , LISTATE NUMBER(10,0) default 0 ) TABLESPACE QDAS_DEFAULT; create table MASCHINE ( MAMASCHINE NUMBER(10,0) , MANR VARCHAR2(40) , MABEZ VARCHAR2(100) , MATYP NUMBER(5,0) , MAHERST NUMBER(10,0) , MABESCH LONG , MASTATE NUMBER(10,0) default 0, MABEREICH VARCHAR2(50), MAABT VARCHAR2(50), MAOPNR VARCHAR2(50), MAEXTREFNR VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; create unique index MASCHINE on MASCHINE (MAMASCHINE); create table MERKART ( MAMERKART NUMBER(3,0) , MAMERKTXT VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; create unique index MERKART on MERKART (MAMERKART); create table MERKKLASS ( KLDPFLICHT NUMBER(3,0) , KLNR VARCHAR2(20) , KLBESCH VARCHAR2(80) ) TABLESPACE QDAS_DEFAULT; create table MERKMAL ( METEIL NUMBER(10,0) , MEMERKMAL NUMBER(5,0) , MEMERKNR VARCHAR2(20) , MEMERKBEZ VARCHAR2(80) , MENENNMAS FLOAT , MEARTUGW NUMBER(5,0) , MEARTOGW NUMBER(5,0) , MEARTPLAUSIUNT NUMBER(5,0) , MEARTPLAUSIOB NUMBER(5,0) , MEUGW FLOAT , MEOGW FLOAT , MEFSK NUMBER(5,0) , MEFEHLART NUMBER(3,0) , MEFEHLKOST FLOAT , MEDPFLICHT NUMBER(5,0) , MEEINHEIT NUMBER(10,0) , MEAUFLOES NUMBER(5,0) , MEKLASSENW FLOAT , MEFERTARTNR VARCHAR2(20) , MEFERTART VARCHAR2(80) , MEPMGRUPPE NUMBER(10,0) , MEPRUEFMIT NUMBER(10,0) , MEPRUEFMITNR NUMBER(10,0) , MEPMGRUPPET VARCHAR2(80) , MEPRUEFMITT VARCHAR2(80) , MEPRUEFMITNRT VARCHAR2(80) , MEERFART NUMBER(5,0) , MEMASCHINE NUMBER(10,0) , MEBEMERK LONG , MESTIFREQ NUMBER(5,0) , MEUMFSTICH NUMBER(5,0) , MEANZSTICH NUMBER(10,0) , MEANZMESSGC NUMBER(10,0) , MEANZPRUEF NUMBER(10,0) , MEUMFPROZ NUMBER(5,0) , MEANZWIED NUMBER(5,0) , MEANZTEILE NUMBER(10,0) , MENENNMAST VARCHAR2(50) , MEUGWT VARCHAR2(50) , MEOGWT VARCHAR2(50) , MEPLAUSIUT VARCHAR2(50) , MEPLAUSIOT VARCHAR2(50) , METOLERANZ NUMBER(5,0) , MEFORMEL VARCHAR2(255) , METRANSART NUMBER(3,0) , METRANSPA FLOAT , METRANSPB FLOAT , METRANSPC FLOAT , METRANSPD FLOAT , MEGLMITT NUMBER(5,0) , MEAUSWART NUMBER(5,0) , MEAUSWTYP NUMBER(5,0) , MEMERKART NUMBER(5,0) , MEVERTFORM NUMBER(5,0) , MEPLAUSIOB FLOAT , MEPLAUSIUN FLOAT , MEPROSTREUSTR VARCHAR2(40) , MEPROSTREU FLOAT , MENORMISTSTR VARCHAR2(80) , MENORMIST FLOAT , -- MENORMNR VARCHAR2(20) , korrigiert 12.11.99 MENORMNR VARCHAR2(40) , MENORMBEZ VARCHAR2(40) , MENORMTEMP VARCHAR2(40) , MEKONFIG VARCHAR2(1000) , MEKLASSUNT FLOAT , MEKLASSOB FLOAT , MEKLASSNR FLOAT , MEVORGCP FLOAT , MEVORGCPK FLOAT , MESTEUERB NUMBER(3,0) , MEEREIGKAT VARCHAR2(50) , MEZYKLUS NUMBER(5,0) , MEPRUEFZST NUMBER(5,0) , MEPRUEFORT NUMBER(5,0) , MEMASSN NUMBER(5,0) , MENENNMASSP VARCHAR2(50) , MEPRFSPEC NUMBER(5,0) , MEAUTOAKT NUMBER(5,0) , MEMERKKLASSE NUMBER(5,0) , MEUNTERSART NUMBER(5,0) , MEANZORDKLASSE NUMBER(5,0) , MEGLEITSTUMF NUMBER(5,0) , MEPUFFERSIZE NUMBER(5,0) , MEAUTOERKENNUNG NUMBER(5,0) , MEATTR NUMBER(5,0) , METRANSFEING NUMBER(5,0) , METRANSFEINGA FLOAT , METRANSFEINGB FLOAT , MENLINKSMA NUMBER(5,0) , MEERFKANAL VARCHAR2(20) , MEERFSUBKANAL VARCHAR2(20) , MENACHARBEIT NUMBER(5,0) , MEZIELWERT FLOAT , MEZIELWERTT FLOAT , MEPMAX FLOAT , MEEINHEITTEXT VARCHAR2(80) , MELOSUMFANG NUMBER(10,0) , MEKOSTENNACHARBEIT FLOAT , MEKOSTENAUSSCHUSS FLOAT , MEMASCHNR VARCHAR2(24) , MEMASCHBEZ VARCHAR2(80) , MEABT VARCHAR2(40) , MESTANDORT VARCHAR2(80) , MEAUFTRNR VARCHAR2(80) , MEAUFTRAGGEBNR NUMBER(10,0) , MEAUFTRAGGEBNRT VARCHAR2(20) , MEAUFTRAGGEB VARCHAR2(80) , MEPRUEFORTT VARCHAR2(80) , MEPRUEFBEGINN VARCHAR2(80) , MEPRUEFENDE VARCHAR2(80) , MEPRUEFER NUMBER(10,0) , MEPRUEFERNR VARCHAR2(20) , MEPRUEFERNAME VARCHAR2(80) , MEPRUEFBEDING VARCHAR2(255) , MEAUGROUP NUMBER(5,0) , MEUPPERMERKMAL NUMBER(5,0) , METOLERANZTEXT VARCHAR2(80) , MEWERKSTCK NUMBER(10,0) , MEWERKSTCKTEXT VARCHAR2(80) , MEANZSPTEXT VARCHAR2(80) , MEPMAUFLOES FLOAT , MEPRUEFBEGINND DATE , MEPRUEFENDED DATE , MENORMAL NUMBER(5,0) , MENORMALTEMP FLOAT , MESTIFREQT VARCHAR2(80) , MEWERKSTCKNR VARCHAR2(20) , MEKURZBEZ VARCHAR2(20) , MEUGSCHROTT FLOAT , MEOGSCHROTT FLOAT , MECG FLOAT , MECGK FLOAT , MEABWGC FLOAT , MEZEICHN VARCHAR2(80) , MEFERTARTKEY NUMBER(10,0) , MEPMHERST VARCHAR2(40) , MEKORRSTRAT NUMBER(5,0) , MEUKG FLOAT , MEOKG FLOAT , MEKORRZIEL FLOAT , MEERFNR NUMBER(5,0) , MEERFNAME VARCHAR2(40) , MEERFINDEX NUMBER(5,0) , MEANFINDEX NUMBER(5,0) , MEINTERFACE NUMBER(5,0) , MEBAUD NUMBER(10,0) , MEIRQ NUMBER(5,0) , MEPARITY NUMBER(5,0) , MEDATA NUMBER(5,0) , MESTOP NUMBER(5,0) , MEPZPKAT NUMBER(5,0) , METOLERANZCALC FLOAT , MEBEREICH VARCHAR2(40) , MEPTM VARCHAR2(40) , MEPPLANNRT VARCHAR2(20) , MEPPLAN VARCHAR2(40) , MEPPLANDAT VARCHAR2(20) , MEPPLANERST VARCHAR2(40) , MESPCNR VARCHAR2(20) , MESPCHERST VARCHAR2(40) , MESPCTYP VARCHAR2(20) , MECP FLOAT , MECPK FLOAT , MECPFIX FLOAT , MECPKFIX FLOAT , MEGAGE25 VARCHAR2(110) , MEEINHREL VARCHAR2(20) , MEADDFAKREL FLOAT , MEMULFAKREL FLOAT , MENORMISTUN FLOAT , MENORMISTOB FLOAT , -- -- aus MERKMAL_AD MENORMALSERNR VARCHAR2(20), MEPRUEFMITSERNR VARCHAR2(20), MEANZGERAET VARCHAR2(40), MEREFTEILNRSTR VARCHAR2(20), MEREFTEILBEZ VARCHAR2(40), MEREFTEILIST FLOAT, MEREFTEILTEMP FLOAT, MEREFTEILNR NUMBER(5,0), MEREFTEILSERNR VARCHAR2(20), MEKALTEILUNRSTR VARCHAR2(20), MEKALTEILUBEZ VARCHAR2(40), MEKALTEILUIST FLOAT, MEKALTEILUTEMP FLOAT, MEKALTEILUNR NUMBER(5,0), MEKALTEILUSERNR VARCHAR2(20), MEKALTEILMNRSTR VARCHAR2(20), MEKALTEILMBEZ VARCHAR2(40), MEKALTEILMIST FLOAT, MEKALTEILMTEMP FLOAT, MEKALTEILMNR NUMBER(5,0), MEKALTEILMSERNR VARCHAR2(20), MEKALTEILONRSTR VARCHAR2(20), MEKALTEILOBEZ VARCHAR2(40), MEKALTEILOIST FLOAT, MEKALTEILOTEMP FLOAT, MEKALTEILONR NUMBER(5,0), MEKALTEILOSERNR VARCHAR2(20), MEUEBERKAN NUMBER(5,0), MEMERKCODE VARCHAR2(40), MEMERKINDEX VARCHAR2(20), MEMERKTEXT VARCHAR2(50), MEBEARBZUST VARCHAR2(80), MEELEMCODE VARCHAR2(40), MEELEMINDEX VARCHAR2(20), MEELEMTEXT VARCHAR2(50), MEELEMADR VARCHAR2(20), MEFREIFELD NUMBER(3,0), MECALIBADD FLOAT, MECALIBMULT FLOAT, MEANZNIAUSGEF NUMBER(10,0), MEGCKONVART NUMBER(3,0), MEANZREF NUMBER(5,0), MEREFPKTX NUMBER(5,0), MEREFPKTY NUMBER(5,0), MEREFPKTZ NUMBER(5,0), ME_2430 NUMBER(5,0), ME_2432 NUMBER(5,0), ME_2434 NUMBER(5,0), ME_2436 VARCHAR2(10), ME_2438 VARCHAR2(10), ME_2440 VARCHAR2(40), ME_2442 VARCHAR2(15), ME_2444 VARCHAR2(40), ME_2446 VARCHAR2(40), ME_2448 VARCHAR2(40), ME_8530 NUMBER(5,0), ME_8531 FLOAT, ME_8532 FLOAT, ME_8540 NUMBER(5,0), ME_2073 FLOAT, ME_2107 FLOAT, ME_2170 FLOAT, ME_2171 FLOAT, ME_2172 FLOAT, ME_2173 FLOAT, ME_2228 FLOAT, ME_2229 FLOAT, ME_2230 FLOAT, ME_2231 FLOAT, ME_2232 FLOAT, ME_2233 FLOAT, ME_2235 FLOAT, ME_2236 FLOAT, ME_2016 NUMBER(3,0), MEMASTERGUID RAW(16), MEGUID RAW(16) ) TABLESPACE qmerk_table PCTFREE 20 PCTUSED 80 --PARALLEL (DEGREE DEFAULT) ; create unique index MERKMAL on MERKMAL (METEIL, MEMERKMAL) TABLESPACE qmerk_index; create index MEFEHLERKLASSE on MERKMAL (MEAUGROUP); create index MEMERKNR on MERKMAL (MEMERKNR); create index MEMERKBEZ on MERKMAL (MEMERKBEZ); create table MERKMAL_ZUS ( METEIL NUMBER(10,0) , MEMERKMAL NUMBER(5,0) , ME_2601 NUMBER(3,0) , ME_2605 VARCHAR2(255) , ME_2610 NUMBER(10,0) , ME_2611 FLOAT , ME_2612 FLOAT , ME_2613 FLOAT , ME_2615 FLOAT, ME_2617 FLOAT , ME_2618 FLOAT , ME_2619 FLOAT , ME_2630 FLOAT , ME_2631 FLOAT , ME_2640 FLOAT , ME_2641 FLOAT , ME_2642 FLOAT , ME_2643 FLOAT , ME_2644 NUMBER(10,0) , ME_2645 NUMBER(10,0) , ME_2646 NUMBER(10,0) , ME_2647 NUMBER(10,0) , ME_2648 VARCHAR2(255) , ME_2700 NUMBER(3,0) , ME_2711 FLOAT , ME_2712 FLOAT , ME_2713 FLOAT , ME_2714 FLOAT , ME_2174 NUMBER(10,0) , ME_2505 VARCHAR2(20) , ME_2506 NUMBER(10,0) , ME_2507 VARCHAR2(2) , ME_2508 NUMBER(10,0) , ME_2509 VARCHAR2(40) , ME_2511 VARCHAR2(20) , ME_2512 VARCHAR2(20) , ME_2513 VARCHAR2(20) , ME_2514 VARCHAR2(20) , ME_2515 VARCHAR2(20) , ME_2516 VARCHAR2(20) , ME_2517 VARCHAR2(20) , ME_2518 VARCHAR2(20) , ME_2519 VARCHAR2(20) , ME_2520 VARCHAR2(20) , ME_2521 FLOAT , ME_2522 FLOAT , ME_2523 FLOAT , ME_2524 VARCHAR2(20) , ME_2175 NUMBER(3,0) , ME_2176 NUMBER(3,0) , ME_2177 FLOAT , ME_2178 FLOAT , ME_2180 FLOAT , ME_2181 FLOAT , ME_2182 FLOAT , ME_2183 FLOAT , ME_2185 NUMBER(10,0) , ME_2186 FLOAT , ME_2720 NUMBER(3,0) , ME_2723 NUMBER(3,0) , ME_2724 FLOAT , ME_2725 FLOAT , ME_2733 NUMBER(3,0) , ME_2734 FLOAT , ME_2735 FLOAT , ME_2736 FLOAT , ME_2737 FLOAT , ME_2738 FLOAT , ME_2740 FLOAT , ME_2741 NUMBER(10,0), ME_2743 NUMBER(3,0), ME_2744 FLOAT, ME_2745 FLOAT, ME_2746 FLOAT, ME_2525 VARCHAR2(255), ME_2526 VARCHAR2(255), ME_2650 NUMBER(3,0), ME_2651 FLOAT, ME_2652 NUMBER(3,0), ME_2654 NUMBER(3,0), ME_2655 NUMBER(3,0), ME_2656 NUMBER(10,0), ME_2657 NUMBER(10,0), ME_2658 NUMBER(10,0), ME_2660 NUMBER(3,0), ME_2062 NUMBER(10,0), ME_2063 NUMBER(10,0), ME_2064 NUMBER(10,0), ME_2065 NUMBER(10,0), MEANZMESSV NUMBER(10,0), MEANZSTAB NUMBER(10,0), ME_2190 VARCHAR2(10), ME_2066 NUMBER(10,0), ME_2067 NUMBER(10,0), ME_2068 NUMBER(10,0), ME_2620 float, ME_2621 float, ME_2622 float, ME_2623 float, ME_2624 float, ME_2625 float, ME_2626 float, ME_2627 float, ME_2628 float, ME_2028 NUMBER(3,0), ME_2614 NUMBER(10,0), ME_2632 FLOAT, ME_2633 FLOAT, ME_2739 FLOAT, ME_8524 FLOAT, ME_8525 FLOAT, ME_2417 NUMBER(10,0) ) TABLESPACE qmerk_table PCTFREE 20 PCTUSED 80 --PARALLEL (DEGREE DEFAULT) ; create unique index MERKMAL_ZUS on MERKMAL_ZUS (METEIL, MEMERKMAL) TABLESPACE qmerk_index; create table NEST ( NENEST NUMBER(10,0) , NEWERKZ FLOAT , NEBESCH VARCHAR2(80) , NESTATE NUMBER(10,0) default 0, NEBEMERK VARCHAR2(200) ) TABLESPACE QDAS_DEFAULT; create unique index NEST on NEST (NENEST); create table PAUFTRAG ( PAPLAN NUMBER(10,0) , PAAUFTRAG NUMBER(10,0) , PAAUFTRAGNR VARCHAR2(40) , PAPAVERS VARCHAR2(20) , PABEZEICH VARCHAR2(100) , PAGRUND VARCHAR2(80) , PABEMERK LONG , PASTATUS NUMBER(3,0) , PAANMDAT DATE , PAANMBEN NUMBER(5,0) , PAAENDDAT NUMBER(10,0) , PAAENDBEN NUMBER(5,0) , PABEGINN DATE , PAENDE DATE , PAABMDAT DATE , PAABMBEN NUMBER(5,0) , PAPRUEFER NUMBER(5,0) , PAPRUEFORT VARCHAR2(50) , PAPRUEFART VARCHAR2(50) , PAGUID RAW(16), PASTATE NUMBER(10,0) default 0, PAFAELLIGMINUTEN NUMBER(10,0) default 0, PASTUECK NUMBER(10,0) default 0, PAFAELLIGSTUECK NUMBER(10,0) default 0, PAFAELLIGJETZT NUMBER(10,0) default 0, PAALARMMINUTEN NUMBER(10,0) default 0, PACHARGENR VARCHAR2(40), PAMASCHINE VARCHAR2(50), PAWERKZEUG VARCHAR2(50), PAWERKSTATT VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; create unique index PAUFTRAG on PAUFTRAG (PAPLAN, PAAUFTRAG); create table PBENTSCH ( PENR NUMBER(5,0) , PETEXT VARCHAR2(80) ) TABLESPACE QDAS_DEFAULT; create table PMGRUPPE ( PGGRUPPE NUMBER(5,0) , PGNR VARCHAR2(40) , PGBEZ VARCHAR2(80) ) TABLESPACE QDAS_DEFAULT; create table PPLAN ( PPPLAN NUMBER(10,0) , PPPLANNR VARCHAR2(40) , PPPPVERS VARCHAR2(20) , PPBEZEICH VARCHAR2(80) , PPTEIL NUMBER(10,0) , PPKUNDE NUMBER(5,0) , PPAUFTRAG NUMBER(5,0) , PPGRUND VARCHAR2(80) , PPBEMERK LONG , PPERSTDAT NUMBER(10,0) , PPERSTBEN VARCHAR2(20) , PPAENDDAT NUMBER(10,0) , PPAENDBEN VARCHAR2(20) , PPSPEZ NUMBER(5,0) , PPFERTORT NUMBER(5,0) , PPGUID RAW(16) ) TABLESPACE QDAS_DEFAULT; create unique index PPLAN on PPLAN (PPPLAN); create table PRODGRUP ( PGGRUPPE NUMBER(5,0) , PGGRUPPENR VARCHAR2(40) , PGBEZ VARCHAR2(80) , PGBESCH LONG ) TABLESPACE QDAS_DEFAULT; create table PRODUKT ( PRPROD NUMBER(10,0) , PRPRODNR VARCHAR2(40) , PRBEZ VARCHAR2(80) , PRBESCH LONG ) TABLESPACE QDAS_DEFAULT; create table PRUEFART ( PAART NUMBER(5,0) , PATEXT VARCHAR2(80) ) TABLESPACE QDAS_DEFAULT; create table PRUEFBER ( PBPRUEFBER NUMBER(10,0) , PBNR VARCHAR2(20) , PBVERSION VARCHAR2(20) , PBART NUMBER(5,0) , PBERSDATUM DATE , PBERSTELLE VARCHAR2(50) , PBAENDATUM DATE , PBAENDERER VARCHAR2(50) , PBABTEILUNG VARCHAR2(50) , PBLIEFERNR NUMBER(10,0) , PBABNEHMNR NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create table PRUEFER ( PRPRUEFER NUMBER(10,0) , PRNAME VARCHAR2(50) , PRVORNAME VARCHAR2(50) , PRABT VARCHAR2(50) , PRTELEFON VARCHAR2(50) , PRFAX VARCHAR2(50), PREMAIL VARCHAR2(50), PRPOS VARCHAR2(30), PRANREDE VARCHAR2(15), PRSTATE NUMBER(10,0) default 0, PRBEMERK VARCHAR2(200) ) TABLESPACE QDAS_DEFAULT; create unique index PRUEFER on PRUEFER (PRPRUEFER); create table PRUEFMIT ( PMPRUEFMIT NUMBER(10,0) , PMNR VARCHAR2(40) , PMBEZ VARCHAR2(80) , PMGRUPPE NUMBER(5,0) , PMPRUEFNAME VARCHAR2(20) , PMLETZTDAT DATE , PMNAECHDAT DATE , PMLAGERORT VARCHAR2(40) , PMEINSORT VARCHAR2(50) , PMBESITZER VARCHAR2(50) , PMINTERVAL NUMBER(3,0) , PMZEITRAUM NUMBER(5,0) , PMLIEFERAN NUMBER(10,0) , PMHERSTELL NUMBER(10,0) , PM_BEST_NR VARCHAR2(20) , PM_GARANTI NUMBER(5,0) , PM_PREIS FLOAT , PM_BESCH LONG , PMSTATE NUMBER(10,0) default 0, PMIPADDR VARCHAR2(30), PMCOMP VARCHAR2(50), PMQVERS VARCHAR2(30), PMSOFTW VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; create unique index PRUEFMIT on PRUEFMIT (PMPRUEFMIT); create table PVORGANG ( PVPLAN NUMBER(10,0) , PVAUFTRAG NUMBER(10,0) , PVVORGANG NUMBER(5,0) , PVVORGANGNR VARCHAR2(40) , PVBEZEICH VARCHAR2(80) , PVBEMERK LONG , PVDATZEIT DATE , PVANMDAT DATE , PVANMBEN NUMBER(5,0) , PVAENDDAT DATE , PVAENDBEN NUMBER(5,0) , PVBEGINN DATE , PVENDE DATE , PV_PAGUID RAW(16), PV_GUID RAW(16), PV_MODUL NUMBER(5,0) , PV_SUBTYPE NUMBER(5,0) , PV_STATUS NUMBER(5,0) , PV_BUTTONLEISTE VARCHAR2(255) ) TABLESPACE QDAS_DEFAULT; create unique index PVORGANG on PVORGANG (PVPLAN, PVAUFTRAG, PVVORGANG); create table SCHICHT ( SCSCHICHT NUMBER(5,0) , SCNR VARCHAR2(20) , SCBESCHR VARCHAR2(80) , SCSTART VARCHAR2(8) , SCENDE VARCHAR2(8) ) TABLESPACE QDAS_DEFAULT; create table STATUS ( STATUSNR NUMBER(5,0) , STATUSTEXT VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; create unique index STATUS on STATUS (STATUSNR); create table STEUCODE ( ACSTCODE NUMBER(10,0) , ACBESCHR VARCHAR2(255) ) TABLESPACE QDAS_DEFAULT; create table TEIL ( TETEIL NUMBER(10,0) , TETEILNR VARCHAR2(30) , TEBEZEICH VARCHAR2(80) , TEDPFLICHT NUMBER(5,0) , TEBEM LONG , TEHERSTELLERNR VARCHAR2(20) , TEHERSTELLERBEZ VARCHAR2(80) , TEWERKSTOFFNR VARCHAR2(20) , TEWERKSTOFFBEZ VARCHAR2(80) , TEZEICHNUNGNR VARCHAR2(30) , TEZEICHNUNGAEND VARCHAR2(20) , TEZEICHNUNGINDEX VARCHAR2(80) , TEAUFTRAGSTR VARCHAR2(40) , TEAUFTRAGGBNR VARCHAR2(20) , TEAUFTRAGGBBEZ VARCHAR2(80) , TEKUNDENR VARCHAR2(20) , TEKUNDEBEZ VARCHAR2(80) , TELIEFERANTNR VARCHAR2(20) , TELIEFERANTBEZ VARCHAR2(80) , TEPREINRNR VARCHAR2(24) , TEPREINRBEZ VARCHAR2(80) , TEPRGRUNDBEZ VARCHAR2(80) , TEPRBEGINNSTR VARCHAR2(40) , TEPRENDESTR VARCHAR2(40) , TEKURZBEZEICH VARCHAR2(20) , TEAENDSTAND VARCHAR2(20) , TEERZEUGNIS VARCHAR2(40) , TEMASCHINENR VARCHAR2(24) , TEMASCHINEBEZ VARCHAR2(40) , TEMASCHINEORT VARCHAR2(40) , TEARBEITSGANG VARCHAR2(40) , TEBEREICH VARCHAR2(40) , TEABT VARCHAR2(40) , TEPRPLATZ VARCHAR2(40) , TEPPLANERST VARCHAR2(40) , TEHERSTELLERKEY NUMBER(10,0) , TEWERKSTOFFKEY NUMBER(10,0) , TEZEICHNUNGKEY NUMBER(10,0) , TEAUFTRAGGBKEY NUMBER(10,0) , TEKUNDEKEY NUMBER(10,0) , TELIEFERANTKEY NUMBER(10,0) , TEMASCHINEKEY NUMBER(10,0) , TEPREINRKEY NUMBER(10,0) , TEKONFIG VARCHAR2(1000), TENRKURZ VARCHAR2(20), TEWERKSTATT VARCHAR2(40), TEREFTEIL VARCHAR2(10), TENORMNR VARCHAR2(40) , TENORMBEZ VARCHAR2(40) , TENORMAL NUMBER(5,0) , TEERZEUGNISKEY NUMBER(10,0), TETYP VARCHAR2(20), TECODE VARCHAR2(20), TEVARIANTE VARCHAR2(20), TESACHNRZUS VARCHAR2(20), TESACHNRIDX VARCHAR2(20), TETEILIDENT VARCHAR2(20), TEKOSTST VARCHAR2(40), TESCHICHT VARCHAR2(20), TEBESTNR VARCHAR2(20), TEWARENEINNR VARCHAR2(20), TEWUERFEL VARCHAR2(20), TEPOSITION VARCHAR2(20), TEVORRICHT VARCHAR2(40), TEFERTDAT VARCHAR2(40), TEPRUEFART VARCHAR2(20), TEMESSRAUM VARCHAR2(40), TEMESSPROGNR VARCHAR2(80), TEMESSPROGVER VARCHAR2(20), TEPRUEFERKEY NUMBER(10,0), TEPRUEFERNR VARCHAR2(20), TEPRUEFERNAME VARCHAR2(40), TEFREIFELD NUMBER(3,0), TEZSB_1016 VARCHAR2(30), TEREPORTFILE_1350 VARCHAR2(60), TE_1045 VARCHAR2(20), TE_1046 VARCHAR2(80), TE_1047 VARCHAR2(20), TE_1300 NUMBER(10,0), TE_1301 NUMBER(5,0), TE_1302 VARCHAR2(40), TE_1311 VARCHAR2(40), TE_1341 VARCHAR2(20), TE_1342 VARCHAR2(40), TE_1343 VARCHAR2(20), TEWERK VARCHAR2(40), TEMESSTYP NUMBER(10,0), TE_1344 VARCHAR2(50), TE_1015 NUMBER(5,0), TE_1017 NUMBER(3,0), TE_1087 VARCHAR2(40), TE_1018 NUMBER(10,0), TE_1401 NUMBER(10,0), TE_1402 NUMBER(10,0), TE_1403 NUMBER(10,0), TE_1404 NUMBER(10,0), TE_1405 NUMBER(10,0), TE_1407 NUMBER(10,0), TE_1408 NUMBER(10,0), TE_1410 VARCHAR2(255), TE_1411 NUMBER(10,0), TE_1091 VARCHAR2(20), TE_1092 VARCHAR2(40), TE_1105 VARCHAR2(20), TE_1106 VARCHAR2(20), TE_1107 VARCHAR2(20), TE_1108 VARCHAR2(20), TE_1304 VARCHAR2(20), TE_1048 VARCHAR2(80), TE_1412 NUMBER(10,0), TE_1413 FLOAT, TE_1414 NUMBER(10,0), TE_1415 NUMBER(3,0), TE_1094 VARCHAR2(24), TE_1095 VARCHAR2(40), TE_1096 NUMBER(10,0), TE_1019 NUMBER(10,0), TE_1798 NUMBER(10,0), TE_1799 VARCHAR2(3999), TEGUID RAW(16) ) TABLESPACE QDAS_DEFAULT; create unique index TEIL on TEIL (TETEIL); create table TEILKETT ( TKTEIL NUMBER(10,0) , TKFOLGTEIL NUMBER(10,0) , TKBESCHR VARCHAR2(80) ) TABLESPACE QDAS_DEFAULT; create unique index TEILKETT on TEILKETT (TKTEIL, TKFOLGTEIL); create table TMFREIFELD ( TMTEIL NUMBER(10,0) , TMMERKMAL NUMBER(5,0) , TMKEY NUMBER(5,0) , TMBEZ VARCHAR2(50) , TMTYP VARCHAR2(1) , TMINHALT VARCHAR2(255) -- CONSTRAINT TMFREIFELD -- PRIMARY KEY (TMTEIL,TMMERKMAL,TMKEY) -- USING INDEX ) TABLESPACE QDAS_DEFAULT; create unique index TMFREIFELD on TMFREIFELD (TMTEIL,TMMERKMAL,TMKEY); create table TMP_DAT ( MINDAT DATE , MAXDAT DATE ) TABLESPACE QDAS_DEFAULT; create table TMP_WERTNR ( TEILNR NUMBER(10,0) , MERKMALNR NUMBER(5,0) , WERTNR NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create table UAUSWERT ( AWTEIL NUMBER(10,0) , AWMERKMAL NUMBER(5,0) , AWUNTERS NUMBER(5,0) , AWNR NUMBER(10,0) , AWSTCODE NUMBER(10,0) , AWWERT FLOAT , AWTEXT VARCHAR2(80) ) TABLESPACE QDAS_DEFAULT; create table UNTERS ( USTEIL NUMBER(10,0), USMERKMAL NUMBER(5,0), USUNTERS NUMBER(5,0), USPLAN NUMBER(10,0), USAUFTRAG NUMBER(10,0), USVORGANG NUMBER(5,0), USUNTERSNR VARCHAR2(20), USBEZEICHN VARCHAR2(80), USART NUMBER(5,0), USVERDICHT NUMBER(5,0), USURWERT NUMBER(5,0), USERFASS NUMBER(3,0), USCODE NUMBER(10,0), USPRUEFORTNR NUMBER(10,0), USNSTMAX NUMBER(10,0), USFAELLIGMINUTEN NUMBER(10,0), USFAELLIGSTUECK NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index UNTERS on UNTERS (USTEIL, USMERKMAL, USUNTERS); create table USERINI ( USERNAME VARCHAR2(50) , USERSECTION VARCHAR2(255) , USERENTRY VARCHAR2(255) , USERVALUE VARCHAR2(255) ) TABLESPACE QDAS_DEFAULT; create unique index USERINI on USERINI (USERNAME, USERSECTION, USERENTRY); create index SectionKey on USERINI (USERNAME, USERSECTION); create table UVERDICH ( UVTEIL NUMBER(10,0) , UVMERKMAL NUMBER(5,0) , UVUNTERS NUMBER(5,0) , UVVERDICHT NUMBER(10,0) , UVWERTVON NUMBER(10,0) , UVWERTBIS NUMBER(10,0) , UVZEITVON VARCHAR2(12) , UVZEITBIS VARCHAR2(12) , UVPRDATVON VARCHAR2(12) , UVPRDATBIS VARCHAR2(12) , UVSTPRUMF NUMBER(10,0) , UVANZSTPR NUMBER(10,0) , UVWERTINT NUMBER(10,0) , UVZEITEINH VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; create table VERTFORM ( VFNR NUMBER(5,0) , VFTVERT VARCHAR2(80) ) TABLESPACE QDAS_DEFAULT; create unique index VERTFORM on VERTFORM (VFNR); create table WECHSWIR ( WWTEIL NUMBER(10,0) , WWMERKMAL NUMBER(5,0) , WWZUORD VARCHAR2(80) ) TABLESPACE QDAS_DEFAULT; create table WERKSTOF ( WSLFDNR NUMBER(10,0) , WSNR VARCHAR2(50) , WSBEZEICH VARCHAR2(100) , WSSTATE NUMBER(10,0) default 0, WSBEMERK VARCHAR2(200), WSALPHA FLOAT, WSUALPHA FLOAT ) TABLESPACE QDAS_DEFAULT; create table WERKZEUG ( WEWERKZ NUMBER(10,0) , WENR VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; create unique index WERKZEUG on WERKZEUG (WEWERKZ); create table WERTEATT ( WATEIL NUMBER(10,0) , WAMERKMAL NUMBER(5,0) , WAUNTERS NUMBER(5,0) , WAWERTNR NUMBER(10,0) , WAUMFANG NUMBER(10,0) , WAKLUGW NUMBER(10,0) , WAGROGW NUMBER(10,0) , WAATTRIBUT NUMBER(5,0) , WAPRUEFER NUMBER(5,0) , WAPRUEFMIT NUMBER(5,0) , WAMASCHINE NUMBER(5,0) , WANEST NUMBER(5,0) , WADATZEIT DATE , WASTIANF NUMBER(3,0) , WACHARGE VARCHAR2(20) , WAAUFTRAG VARCHAR2(20) -- CONSTRAINT WERTEATT -- PRIMARY KEY (WATEIL, WAMERKMAL, WAUNTERS, WAWERTNR) -- USING INDEX -- TABLESPACE qwert_index ) TABLESPACE qwert_table PCTFREE 20 PCTUSED 80 --PARALLEL (DEGREE DEFAULT) ; create unique index WERTEATT on WERTEATT (WATEIL, WAMERKMAL, WAUNTERS, WAWERTNR) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create index WAATTRIBUT on WERTEATT (WAATTRIBUT) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create index WACHARGE on WERTEATT (WACHARGE) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create index WADATZEIT on WERTEATT (WADATZEIT) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create index WAMASCHINE on WERTEATT (WAMASCHINE) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create index WAMERKMAL on WERTEATT (WAMERKMAL) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create index WANEST on WERTEATT (WANEST) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create index WAPRUEFER on WERTEATT (WAPRUEFER) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create index WAPRUEFMIT on WERTEATT (WAPRUEFMIT) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create index WAAUFTRAG on WERTEATT (WAAUFTRAG) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create table WERTEVAR ( WVTEIL NUMBER(10,0) , WVMERKMAL NUMBER(5,0) , WVUNTERS NUMBER(5,0) , WVWERTNR NUMBER(10,0) , WVWERT FLOAT , WVATTRIBUT NUMBER(5,0) , WVPRUEFER NUMBER(10,0) , WVPRUEFMIT NUMBER(10,0) , WVMASCHINE NUMBER(10,0) , WVNEST NUMBER(10,0) , WVDATZEIT DATE , WVSTIANF NUMBER(3,0) , WVCHARGE VARCHAR2(20) , WVAUFTRAG VARCHAR2(20), WV0005 VARCHAR2(35) -- ,WV0031 RAW(16) -- CONSTRAINT WERTEVAR -- PRIMARY KEY (WVTEIL, WVMERKMAL, WVUNTERS, WVWERTNR) -- USING INDEX -- TABLESPACE qwert_index ) TABLESPACE qwert_table PCTFREE 20 PCTUSED 80 --PARALLEL (DEGREE DEFAULT) ; create unique index WERTEVAR on WERTEVAR (WVTEIL, WVMERKMAL, WVUNTERS, WVWERTNR) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create index WVATTRIBUT on WERTEVAR (WVATTRIBUT) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create index WVCHARGE on WERTEVAR (WVCHARGE) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create index WVDATZEIT on WERTEVAR (WVDATZEIT) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create index WVMASCHINE on WERTEVAR (WVMASCHINE) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; -- create index WVMERKMAL on WERTEVAR (WVMERKMAL) -- TABLESPACE qwert_index -- PARALLEL (DEGREE DEFAULT) -- ; create index WVNEST on WERTEVAR (WVNEST) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create index WVPRUEFER on WERTEVAR (WVPRUEFER) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create index WVPRUEFMIT on WERTEVAR (WVPRUEFMIT) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create index WVAUFTRAG on WERTEVAR (WVAUFTRAG) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create index WV0005 on WERTEVAR (WV0005) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create table WERTTXT ( WTTEIL NUMBER(10,0) , WTMERKMAL NUMBER(5,0) , WTUNTERS NUMBER(5,0) , WTWERTNR NUMBER(10,0) , WTTEXT LONG ) TABLESPACE QDAS_DEFAULT; create unique index WERTTXT on WERTTXT (WTTEIL, WTMERKMAL, WTUNTERS, WTWERTNR); create table ZEICHN ( ZNTEIL NUMBER(10,0) , ZNZNR VARCHAR2(40) , ZNZNRindex VARCHAR2(100) , ZNDATEI VARCHAR2(50) , ZNSTATE NUMBER(10,0) default 0, ZNBEMERK VARCHAR2(200) ) TABLESPACE QDAS_DEFAULT; create table ZU_AG_ME ( ZUPPLANNR FLOAT , ZUAGNR NUMBER(5,0) , ZUTEIL NUMBER(5,0) , ZUMERKMAL NUMBER(5,0) ) TABLESPACE QDAS_DEFAULT; create table ZU_ME_PA ( MATEIL NUMBER(10,0) , MAMERKMAL NUMBER(5,0) , MAPPLAN VARCHAR2(20) , MAPPVERS VARCHAR2(40) , MAPAUFTRAG VARCHAR2(20) , MAPAVERS VARCHAR2(40) , MAPRUEFMIT NUMBER(5,0) , MABEZEICHN VARCHAR2(50) , MABEMERK LONG ) TABLESPACE QDAS_DEFAULT; create table ZU_ME_PP ( MPTEIL NUMBER(10,0) , MPMERKMAL NUMBER(5,0) , MPPPLAN VARCHAR2(20) , MPPPVERS VARCHAR2(40) , MPGRUPPE NUMBER(5,0) , MPSTPLAN NUMBER(3,0) , MPWICHTUNG NUMBER(3,0) , MPBEZEICHN VARCHAR2(50) , MPBEMERK LONG ) TABLESPACE QDAS_DEFAULT; create table ZU_PA_MA ( PMPLAN NUMBER(10,0) , PMAUFTRAG NUMBER(10,0) , PMMASCHINE NUMBER(5,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_PA_MA on ZU_PA_MA (PMPLAN, PMAUFTRAG, PMMASCHINE); create table ZU_PR_PG ( PPGRUPPE NUMBER(10,0) , PPPROD NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create table ZU_PV_ME ( MVPLAN NUMBER(10,0) , MVAUFTRAG NUMBER(10,0) , MVVORGANG NUMBER(5,0) , MVTEIL NUMBER(10,0) , MVMERKMAL NUMBER(5,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_PV_ME on ZU_PV_ME (MVPLAN, MVAUFTRAG, MVVORGANG, MVTEIL, MVMERKMAL); create table ZU_TE_AU ( TATEIL NUMBER(5,0) , TAAUFTRAG NUMBER(10,0) , TAAUFTRNR VARCHAR2(50) , TAAUFTRDAT DATE , TATEILNR VARCHAR2(40) , TATEILBEZ VARCHAR2(80) ) TABLESPACE QDAS_DEFAULT; create table ZU_TE_HE ( THTEIL NUMBER(5,0) , THHERST NUMBER(10,0) , THTEILNR VARCHAR2(40) , THTEILBEZ VARCHAR2(80) ) TABLESPACE QDAS_DEFAULT; create table ZU_TE_KU ( TKTEIL NUMBER(5,0) , TKKUNDE NUMBER(10,0) , TKBESTNR VARCHAR2(50) , TKBESTDAT DATE , TKBESTNAME VARCHAR2(50) , TKTEILNR VARCHAR2(40) , TKTEILBEZ VARCHAR2(80) ) TABLESPACE QDAS_DEFAULT; create table ZU_TE_LI ( TLTEIL NUMBER(5,0) , TLLIEF NUMBER(10,0) , TKBESTNR VARCHAR2(50) , TKBESTDAT DATE , TKBESTNAME VARCHAR2(50) , TKTEILNR VARCHAR2(40) , TKTEILBEZ VARCHAR2(80) ) TABLESPACE QDAS_DEFAULT; create table ZU_TE_MA ( TMTEIL NUMBER(10,0) , TMMASCHINE NUMBER(5,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_TE_MA on ZU_TE_MA (TMTEIL, TMMASCHINE); create table ZU_TE_PP ( TPTEIL NUMBER(10,0) , TPPLAN NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_TE_PP on ZU_TE_PP (TPTEIL, TPPLAN); create table ZU_TE_PR ( TPTEIL NUMBER(10,0) , TPPROD NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create table ZU_TE_WE ( TWTEIL NUMBER(10,0) , TWSTOFF NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create table ZU_US_PB ( UBTEIL NUMBER(10,0) , UBMERKMAL NUMBER(5,0) , UBUNTERS NUMBER(5,0) , UBPRUEFBER NUMBER(10,0) , UBENTSCH NUMBER(5,0) , UBMEMO LONG ) TABLESPACE QDAS_DEFAULT; create table ZU_US_SELECT ( USERNO NUMBER(5,0) , CNNO NUMBER(5,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_US_SELECT on ZU_US_SELECT (USERNO, CNNO); create table ZU_W_T_L ( WTLTEIL NUMBER(10,0) , WTLSTOFF NUMBER(10,0) , WTLLIEFER NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create table ZUSTAEND ( ZUSTNR NUMBER(5,0) , ZUSTTEXT VARCHAR2(80) ) TABLESPACE QDAS_DEFAULT; create unique index ZUSTAEND on ZUSTAEND (ZUSTNR); create table ZYKLUS ( ZYNR NUMBER(5,0) , ZYTXT VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; create unique index ZYKLUS on ZYKLUS (ZYNR); create table USERLOCK ( LCTEIL NUMBER(10,0) , LCUSER VARCHAR2(90) ) TABLESPACE QDAS_DEFAULT; create unique index USERLOCK on USERLOCK (LCTEIL); CREATE VIEW V_AUSPRAEG AS SELECT AUSPRAEGGRP.AUGROUP, AUSPRAEG.AUKEY, AUSPRAEGGRP.AUGRPTEXT, AUSPRAEG.AUTEXT FROM AUSPRAEG,AUSPRAEGGRP WHERE AUSPRAEG.AUGROUP = AUSPRAEGGRP.AUGROUP(+); CREATE VIEW V_WERKZEUGNEST AS SELECT NEST.NENEST, WERKZEUG.WENR, NEST.NEBESCH FROM NEST,WERKZEUG WHERE NEST.NEWERKZ = WERKZEUG.WEWERKZ(+); CREATE VIEW WERTEVAREREIG AS SELECT WVTEIL, WVMERKMAL, WVUNTERS, WVWERTNR, WVWERT, WVATTRIBUT, WVPRUEFER, WVPRUEFMIT, WVMASCHINE, WVNEST, WVDATZEIT, WVSTIANF, WVCHARGE, WVAUFTRAG, ERTEXTNR AS WVEREIGNIS FROM EREIG,WERTEVAR WHERE WERTEVAR.WVWERTNR = EREIG.ERWERTNR(+) AND WERTEVAR.WVMERKMAL = EREIG.ERMERKMAL(+) AND WERTEVAR.WVTEIL = EREIG.ERTEIL(+); CREATE VIEW WERTEVAREREIGTEXT AS SELECT WERTEVAREREIG.*, WERTTXT.WTTEXT AS WVTEXT FROM WERTEVAREREIG ,WERTTXT WHERE (WERTEVAREREIG.WVWERTNR = WERTTXT.WTWERTNR(+)) AND (WERTEVAREREIG.WVMERKMAL = WERTTXT.WTMERKMAL(+)) AND (WERTEVAREREIG.WVTEIL = WERTTXT.WTTEIL(+)); CREATE VIEW WERTEATTEREIG AS SELECT WATEIL, WAMERKMAL, WAUNTERS, WAWERTNR, WAUMFANG,WAKLUGW,WAGROGW ,WAATTRIBUT, WAPRUEFER, WAPRUEFMIT, WAMASCHINE, WANEST, WADATZEIT, WASTIANF, WACHARGE, WAAUFTRAG, ERTEXTNR AS WAEREIGNIS FROM EREIG,WERTEATT WHERE WERTEATT.WAWERTNR = EREIG.ERWERTNR(+) AND WERTEATT.WAMERKMAL = EREIG.ERMERKMAL(+) AND WERTEATT.WATEIL = EREIG.ERTEIL(+); CREATE VIEW WERTEATTEREIGTEXT AS SELECT WERTEATTEREIG.*, WERTTXT.WTTEXT AS WATEXT FROM WERTEATTEREIG ,WERTTXT WHERE (WERTEATTEREIG.WAWERTNR = WERTTXT.WTWERTNR(+)) AND (WERTEATTEREIG.WAMERKMAL = WERTTXT.WTMERKMAL(+)) AND (WERTEATTEREIG.WATEIL = WERTTXT.WTTEIL(+)); create table DB_VERSION ( VERSION VARCHAR2(10) ) TABLESPACE QDAS_DEFAULT; Insert INTO DB_VERSION VALUES('8.0'); create table ABT ( ABTKEY NUMBER(5,0) , ABTNR VARCHAR2(40) , ABTNAME VARCHAR2(80) ) TABLESPACE QDAS_DEFAULT; create unique index ABT on ABT (ABTKEY); create table BEREICH ( BEKEY NUMBER(5,0) , BEREICHNR VARCHAR2(40) , BEREICHNAME VARCHAR2(80) ) TABLESPACE QDAS_DEFAULT; create unique index BEREICH on BEREICH (BEKEY); create table KOSTST ( KOKEY NUMBER(5,0) , KONR VARCHAR2(40) , KONAME VARCHAR2(80) ) TABLESPACE QDAS_DEFAULT; create unique index KOSTST on KOSTST(KOKEY); create table ZU_BE_TE ( TEBER NUMBER(5,0) , TEABT NUMBER(5,0) , TEKOSTST NUMBER(5,0) , TETEIL NUMBER(10,0) , TEMASCHINE NUMBER(5,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_BE_TE on ZU_BE_TE(TEBER,TEABT,TEKOSTST,TEMASCHINE); create table ZU_UR_ERG ( URTEIL VARCHAR2(10) , URMERKMAL VARCHAR2(10) , URUNTERS VARCHAR2(50) , URERGEBNIS VARCHAR2(20) , ZIELTEIL VARCHAR2(10) , ZIELMERKMAL VARCHAR2(10) , ZIELUNTERS VARCHAR2(20) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_UR_ERG on ZU_UR_ERG(URTEIL,URMERKMAL,URUNTERS,URERGEBNIS); create table EREIGKAT ( EKNR NUMBER(10,0) , EKTEXT VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; create unique index EREIGKAT on EREIGKAT(EKNR); create table ZU_ET_EK ( ETTEXTNR NUMBER(10,0) , EKNR NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_ET_EK on ZU_ET_EK(ETTEXTNR,EKNR); create table PROZPARAM ( PPTEIL NUMBER(10,0) , PPMERKMAL NUMBER(10,0) , PPUNTERS NUMBER(10,0) , PPWERTNR NUMBER(10,0) , PPLFDNR NUMBER(10,0) , PPTEXTNR NUMBER(10,0) , PPPPWERTNR NUMBER(10,0) , PPEINFLUSS VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; create unique index PROZPARAM on PROZPARAM(PPTEIL,PPMERKMAL,PPUNTERS,PPWERTNR,PPLFDNR); create table PROZPARAMTXT ( PPNR NUMBER(10,0) , PPNRTEXT VARCHAR2(40) , PPKURZTEXT VARCHAR2(20) , PPLANGTEXT VARCHAR2(100) , PPSTATE NUMBER(10,0) default 0, PPBEMERK VARCHAR2(200) ) TABLESPACE QDAS_DEFAULT; create unique index PROZPARAMTXT on PROZPARAMTXT(PPNR); create table PROZPARAMKAT ( PPKNR NUMBER(10,0) , PPKTEXT VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; create unique index PROZPARAMKAT on PROZPARAMKAT(PPKNR); create table ZU_PP_PPK ( PPNR NUMBER(10,0) , PPKATNR NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_PP_PPK on ZU_PP_PPK(PPNR,PPKATNR); create table PROZPARAMWERT ( PPWNR NUMBER(10,0) , PPWPPNR NUMBER(10,0) , PPWNRTEXT VARCHAR2(40) , PPWERTTEXT VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; create unique index PROZPARAMWERT on PROZPARAMWERT(PPWNR); create table USER1 ( USERNO NUMBER(5,0) , USERGROUP NUMBER(5,0) , USERNAME VARCHAR2(50) , PASSWORD VARCHAR2(20) , USINIDAT VARCHAR2(50) , USHIERA NUMBER(5,0) , USBEREICH NUMBER(10,0) , USABT NUMBER(10,0) , USWERKSTATT NUMBER(10,0) , USNAME VARCHAR2(50) , USFIRMA VARCHAR2(50) , USABTNAME VARCHAR2(50) , USFON VARCHAR2(50) , USFAX VARCHAR2(50) , USMAIL VARCHAR2(50) , USZUS NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index USER1 on USER1(USERNO); create table USERGROUP ( GROUPNO NUMBER(5,0) , GROUPNAME VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; create unique index USERGROUP on USERGROUP(GROUPNO); create table ZUGRECHTE ( ZRUSERGROUP NUMBER(10,0) , ZRMESSWEIN VARCHAR2(50) , ZRMESSWAEND VARCHAR2(50) , ZRPRPLEIN VARCHAR2(50) , ZRPRPLAEND VARCHAR2(50) , ZRAUSWLES VARCHAR2(50) , ZRSYSKONF VARCHAR2(50) , ZROPTIONAL VARCHAR2(250) ) TABLESPACE QDAS_DEFAULT; create unique index ZUGRECHTE on ZUGRECHTE(ZRUSERGROUP); create table HIERARCHIE ( HINR NUMBER(5,0) , HIBEZ VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; Insert INTO HIERARCHIE VALUES(1,'bereichsübergreifend'); Insert INTO HIERARCHIE VALUES(2,'Bereichsleiter'); Insert INTO HIERARCHIE VALUES(3,'Abteilungsleiter'); Insert INTO HIERARCHIE VALUES(4,'Werkstattleiter'); Insert INTO HIERARCHIE VALUES(5,'Bediener vor Ort'); create table ERZEUGNIS ( EZERZEUGNIS NUMBER(10,0) , EZNUMMER VARCHAR2(20) , EZBEZ VARCHAR2(80) , EZKUNDE NUMBER(10,0) , EZSTATE NUMBER(10,0) default 0, EZBEMERK VARCHAR2(200) ) TABLESPACE QDAS_DEFAULT; create unique index ERZEUGNIS on ERZEUGNIS (EZERZEUGNIS); CREATE VIEW V_BEREICH AS SELECT BEREICH.BEREICHNR, ABT.ABTNR, KOSTST.KONR, TEIL.TETEILNR, TEIL.TEBEZEICH, TEIL.TEERZEUGNIS, TEIL.TEAENDSTAND, MASCHINE.MANR, MASCHINE.MABEZ FROM ZU_BE_TE,BEREICH,ABT,KOSTST,TEIL,MASCHINE WHERE ZU_BE_TE.TEBER = BEREICH.BEKEY(+) AND ZU_BE_TE.TEABT = ABT.ABTKEY(+) AND ZU_BE_TE.TEKOSTST = KOSTST.KOKEY(+) AND ZU_BE_TE.TETEIL = TEIL.TETEIL(+) AND ZU_BE_TE.TEMASCHINE = MASCHINE.MAMASCHINE(+); create table NIO ( NIOTEIL NUMBER(10,0) , NIOCHARGE VARCHAR2(20) , NIOAUFTRAG VARCHAR2(30) ) TABLESPACE QDAS_DEFAULT; create unique index NIO on NIO(NIOTEIL,NIOCHARGE,NIOAUFTRAG); create table wv_tab_ind ( TNAME varchar2(30), FULLINDEX number(1) ) TABLESPACE QDAS_DEFAULT; create unique index wv_tab_ind on wv_tab_ind (TNAME); create index wv_tab_ind_i on wv_tab_ind (FULLINDEX); create table wa_tab_ind ( TNAME varchar2(30), FULLINDEX number(1) ) TABLESPACE QDAS_DEFAULT; create unique index wa_tab_ind on wa_tab_ind (TNAME); create index wa_tab_ind_i on wa_tab_ind (FULLINDEX); create table LASTIDENT ( LITEIL NUMBER(10,0), LIDENT NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index LASTIDENT on LASTIDENT(LITEIL); create table NENNMASS ( NMARTIKEL NUMBER(10,0), NMMERKMAL NUMBER(10,0), NMARBEITSGANG VARCHAR2(40), NMNENNMASS FLOAT ) TABLESPACE QDAS_DEFAULT; create unique index NENNMASS on NENNMASS(NMARTIKEL, NMMERKMAL, NMARBEITSGANG); create table ERGEBNIS ( ETEIL NUMBER(10,0), EMERKMAL NUMBER(10,0), EMODUL NUMBER(5,0), EAUSGAPUNKT VARCHAR2(20), EERGEBNIS FLOAT, EERGEBNISSTR VARCHAR2(30), ESTARTDAT DATE, EENDDAT DATE, EPRUEFER NUMBER(10,0), EPRUEFMIT NUMBER(10,0), EMASCHINE NUMBER(10,0), ENEST NUMBER(10,0), ECHARGE VARCHAR2(20), EAUFTRAG VARCHAR2(20), EANZWERTE NUMBER(10,0), EZUSDATLIST VARCHAR2(50) ) TABLESPACE qmerk_table PCTFREE 20 PCTUSED 80 --PARALLEL (DEGREE DEFAULT) ; create index ERGEBNIS on ERGEBNIS (ETEIL, EMERKMAL, EMODUL) TABLESPACE qmerk_index --PARALLEL (DEGREE DEFAULT) ; create index EAUFTRAG on ERGEBNIS (EAUFTRAG) TABLESPACE qmerk_index --PARALLEL (DEGREE DEFAULT) ; create table BUILDPHASE ( BPKEY NUMBER(10,0), BPNAME VARCHAR2(20) ) TABLESPACE QDAS_DEFAULT; create unique index BUILDPHASE on BUILDPHASE(BPKEY); create table ERGEBZEITRAUM ( EZTEIL NUMBER(10,0), EZMODUL NUMBER(5,0), EZAUSGAPUNKT VARCHAR2(20), EZBAUPHASE VARCHAR2(20), MINDAT DATE, MAXDAT DATE ) TABLESPACE QDAS_DEFAULT; create unique index ERGEBZEITRAUM on ERGEBZEITRAUM(EZTEIL,EZMODUL,EZAUSGAPUNKT,EZBAUPHASE); create table PARTCONFIG ( PARTID NUMBER(10,0), PARTCONFIG VARCHAR2(80), PARTWINDOWLIST LONG ) TABLESPACE QDAS_DEFAULT; create unique index PARTCONFIG on PARTCONFIG(PARTID); create table MEASVALUES ( MV_PARTID NUMBER(10,0), MV_INTERNALID NUMBER(10,0), MV_MEASUREMENTID VARCHAR2(50), MV_MEASVALUES LONG, MV_ATTRIBUTE NUMBER(5,0), MV_INSPECTOR NUMBER(5,0), MV_MEASSYSTEM NUMBER(5,0), MV_MACHINE NUMBER(5,0), MV_NEST NUMBER(5,0), MV_MEASSTARTDATETIME DATE, MV_MEASENDDATETIME DATE, MV_SAMPLEFLAG NUMBER(3,0), MV_BATCHSTART VARCHAR2(20), MV_BATCHEND VARCHAR2(20), MV_ORDER VARCHAR2(20), MV_MEASUREMENTCOUNT NUMBER(10,0), WV0005 VARCHAR2(20) ) TABLESPACE QDAS_DEFAULT; create unique index MEASVALUES on MEASVALUES(MV_PARTID,MV_INTERNALID); create index MV_INTERNALID on MEASVALUES(MV_INTERNALID); create index MV_MEASENDDATETIME on MEASVALUES(MV_MEASENDDATETIME); create index MV_MEASSTARTDATETIME on MEASVALUES(MV_MEASSTARTDATETIME); create index MV_MEASUREMENTID on MEASVALUES(MV_MEASUREMENTID); create index MV_ATTRIBUTE on MEASVALUES(MV_ATTRIBUTE); create index MV_INSPECTOR on MEASVALUES(MV_INSPECTOR); create index MV_MEASSYSTEM on MEASVALUES(MV_MEASSYSTEM); create index MV_MACHINE on MEASVALUES(MV_MACHINE); create index MV_NEST on MEASVALUES(MV_NEST); create table HIERATEIL ( HITEIL NUMBER(10,0), HISUBKEY1 NUMBER(10,0), HISUBKEY2 NUMBER(10,0), HISTRUKTUR LONG ) TABLESPACE QDAS_DEFAULT; create unique index HIERATEIL on HIERATEIL(HITEIL, HISUBKEY1, HISUBKEY2); create table LAST_UPLOAD ( MEUPLOADKEY NUMBER(10,0), METEIL NUMBER(10,0), MEMERKMAL NUMBER(5,0), FILENAME VARCHAR2(255), MEWERT NUMBER(10,0), K0006 VARCHAR2(20), K0007 NUMBER(10,0), K0008 NUMBER(10,0), K0010 NUMBER(10,0), K0012 NUMBER(10,0), K0053 VARCHAR2(20), STATION_NO VARCHAR2(50), MMNRINTERN NUMBER(5, 0), TIDNR VARCHAR2(20), K1001 VARCHAR2(40), K1002 VARCHAR2(80), SPU NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index LAST_UPLOAD on LAST_UPLOAD(MEUPLOADKEY, METEIL, MEMERKMAL); create index LAST_UPLOAD_TEIL on LAST_UPLOAD(METEIL); create index LAST_UPLOAD_STATION_NO on LAST_UPLOAD(STATION_NO); create table MERKMAL_REPORT ( METEIL NUMBER(10,0), MEMERKMAL NUMBER(5,0), MEREPORT VARCHAR2(255), MODUL NUMBER(5,0), EMAIL VARCHAR2(255), PRINTER VARCHAR2(255), CONFNAME VARCHAR2(50), GRUPPE NUMBER(10,0), TEMPLATE VARCHAR2(255), MEREPORTALARM VARCHAR2(255), PDFPATH VARCHAR2(255), WITHOUT_AL_TXT VARCHAR2(255), PDF_URL VARCHAR2(255), ALTPDFDNERZ VARCHAR2(255) ) TABLESPACE QDAS_DEFAULT; create index MERKMAL_REPORT_TEIL on MERKMAL_REPORT(METEIL); CREATE TABLE MERKMAL_REPORT_NO_SELECT ( METEIL NUMBER(10, 0) , MEMERKMAL NUMBER(5, 0) , MEREPORT VARCHAR2(255) , MODUL NUMBER(5, 0) , CONFNAME VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; create index MERKMAL_REPORT_NST on MERKMAL_REPORT_NO_SELECT(METEIL); create table REPORTS ( REPORTNO NUMBER(5,0), REPORTNAME VARCHAR2(255), REPORTTYPE NUMBER(5,0), MODUL NUMBER(5,0), CONFNAME VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; create table ALARM_FILES ( ALARM_ID NUMBER(10,0), ENTRY_TYPE NUMBER(10,0), ENTRY LONG RAW, UPLOAD_DIR VARCHAR2(255), REPORTNAME VARCHAR2(255) ) TABLESPACE QDAS_DEFAULT; create unique index ALARM_FILES on ALARM_FILES(ALARM_ID, ENTRY_TYPE); create table ALARMS ( ALARM_ID NUMBER(10,0), ALARM_COUNT NUMBER(10,0), ALARM_TYPE NUMBER(10,0), ALARM_STATUS NUMBER(10,0), ALARM_DATETIME DATE, ALARM_EVENT VARCHAR2(255), ALARM_EW NUMBER(10, 0) , ALARM_QRK_L NUMBER(10, 0) , ALARM_QRK_S NUMBER(10, 0) , ALARM_CP NUMBER(10, 0) , K0006 VARCHAR2(20) , K0007 NUMBER(10, 0) , K0008 NUMBER(10, 0) , K0010 NUMBER(10, 0) , K0012 NUMBER(10, 0) , K0053 VARCHAR2(20) , K1000 NUMBER(10, 0) , K0000 NUMBER(10, 0) , SUMMARY_NR NUMBER(10, 0) , STATUS_PRINTED NUMBER(10, 0) , POINTS NUMBER(10,0) , STATION_NO VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; create unique index ALARMS on ALARMS(ALARM_ID); CREATE TABLE ALARM_VALUES ( ALARM_ID NUMBER(10, 0) , ALARM_VALUE_ID NUMBER(10, 0) , ALARM_STATUS NUMBER(10, 0) , ALARM_DATETIME DATE , CONFIRM_DATETIME DATE , CLOSE_DATETIME DATE , CONFIRM_USER VARCHAR2(50) , CLOSE_USER VARCHAR2(50) , ALARM_EW NUMBER(10, 0) , ALARM_QRK_L NUMBER(10, 0) , ALARM_QRK_S NUMBER(10, 0) , ALARM_CP NUMBER(10, 0) , ALARM_EVENT VARCHAR2(255) , K0006 VARCHAR2(20) , K0007 NUMBER(10, 0) , K0008 NUMBER(10, 0) , K0010 NUMBER(10, 0) , K0012 NUMBER(10, 0) , K0053 VARCHAR2(20) , K1000 NUMBER(10, 0) , K2000 NUMBER(10, 0) , K0000 NUMBER(10, 0) , POINTS NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index ALARM_ID on ALARM_VALUES(ALARM_ID,ALARM_VALUE_ID); -- für EMPB CREATE TABLE EMPB_3000 ( K3000 NUMBER(10,0), K3001 VARCHAR2(20), K3002 VARCHAR2(30), K3003 VARCHAR2(20), K3004 VARCHAR2(20), K3005 VARCHAR2(20), K3006 VARCHAR2(20), K3010 NUMBER(10,0), K3011 VARCHAR2(20), K3020 NUMBER(5,0), K3021 NUMBER(5,0), K3022 NUMBER(5,0), K3023 VARCHAR2(40), K3025 VARCHAR2(20), K3030 VARCHAR2(120), K3031 VARCHAR2(40), K3035 VARCHAR2(50), K3036 VARCHAR2(50), K3037 NUMBER(5,0), K3040 NUMBER(5,0), K3050 VARCHAR2(30), K3052 VARCHAR2(50), K3055 VARCHAR2(30), K3056 VARCHAR2(20), K3057 DATE, K3058 VARCHAR2(20), K3070 VARCHAR2(30), K3071 VARCHAR2(30), K3077 DATE, K3078 DATE, K3080 VARCHAR2(30), K3087 DATE, K3100 VARCHAR2(30), K3101 VARCHAR2(20), K3102 VARCHAR2(20), K3103 VARCHAR2(20), K3105 VARCHAR2(20), K3106 VARCHAR2(20), K3107 VARCHAR2(20), K3108 NUMBER(5,0), K3109 NUMBER(5,0), K3110 VARCHAR2(20), K3112 VARCHAR2(30), K3113 VARCHAR2(30), K3115 NUMBER(5,0), K3117 VARCHAR2(20), K3118 VARCHAR2(20), K3119 DATE, K3150 NUMBER(10,0), K3160 VARCHAR2(30), K3167 DATE, -- K3180 K3187 VARCHAR2(20), K3188 VARCHAR2(20), -- K3190 K3200 VARCHAR2(30), K3210 VARCHAR2(30), K3301 VARCHAR2(20), K3302 VARCHAR2(30), K3303 VARCHAR2(20), K3304 VARCHAR2(20), K3306 VARCHAR2(20), K3310 NUMBER(10,0), K3350 VARCHAR2(30), K3352 VARCHAR2(50), K3355 VARCHAR2(30), K3356 VARCHAR2(30), K3357 DATE, K3358 VARCHAR2(20), K3372 VARCHAR2(30), K3379 DATE, K3380 VARCHAR2(20), K3387 DATE, K3390 VARCHAR2(30), K3404 VARCHAR2(30), K3410 VARCHAR2(20), K3420 NUMBER(5,0), K3421 NUMBER(5,0), K3422 NUMBER(5,0), K3423 NUMBER(5,0), K3424 NUMBER(5,0), K3425 NUMBER(5,0), K3433 NUMBER(5,0), K3438 NUMBER(5,0), K3439 VARCHAR2(20), K3440 VARCHAR2(20), K3442 NUMBER(5,0), K3445 VARCHAR2(50), K3447 DATE, K3450 VARCHAR2(50), K3451 VARCHAR2(20), K3460 VARCHAR2(20), K3467 DATE, K3470 NUMBER(10,0), -- K3481 -- K3490 K3560 VARCHAR2(30), K3561 VARCHAR2(30), K3562 VARCHAR2(30), K3563 VARCHAR2(30), K3564 VARCHAR2(30), K3565 VARCHAR2(30), K3566 VARCHAR2(30), K3569 VARCHAR2(30), K3600 NUMBER(5,0), K3601 VARCHAR2(30), K3602 VARCHAR2(60), K3610 VARCHAR2(50), K3617 DATE, K3650 NUMBER(5,0), K3701 NUMBER(5,0), K3702 NUMBER(5,0), K3703 NUMBER(5,0), K3704 NUMBER(5,0), K3705 NUMBER(5,0), K3706 NUMBER(5,0), K3707 NUMBER(5,0), K3708 NUMBER(5,0), K3709 NUMBER(5,0), K3710 NUMBER(5,0), K3711 NUMBER(5,0), K3712 NUMBER(5,0), K3713 NUMBER(5,0), K3714 NUMBER(5,0), K3750 NUMBER(5,0), K3752 NUMBER(5,0), K3754 NUMBER(5,0), K3756 NUMBER(5,0), K3757 VARCHAR2(20), K3758 VARCHAR2(20), K3760 NUMBER(5,0), K3761 VARCHAR2(50), K3763 NUMBER(5,0), K3764 VARCHAR2(20), -- ab VDA2, 4. Aufl. K3015 NUMBER(3,0), K3016 NUMBER(3,0), K3017 VARCHAR2(20), K3019 NUMBER(3,0), K3426 NUMBER(5,0), K3427 NUMBER(10,0), K3428 NUMBER(5,0), K3429 NUMBER(5,0), K3430 NUMBER(5,0), K3431 NUMBER(5,0), K3432 NUMBER(5,0), K3434 NUMBER(5,0), K3435 NUMBER(5,0), K3437 NUMBER(5,0), K3446 DATE, K3448 VARCHAR2(20), K3449 DATE, K3840 NUMBER(5,0), K3841 NUMBER(5,0), K3843 NUMBER(5,0), K3844 NUMBER(5,0), K3845 NUMBER(5,0), K3846 NUMBER(5,0), K3847 NUMBER(5,0), K3901 VARCHAR2(20), K3902 VARCHAR2(20), K3903 VARCHAR2(20), K3904 VARCHAR2(20), K3905 VARCHAR2(20), K3906 VARCHAR2(20), K3907 VARCHAR2(20), K3908 VARCHAR2(20), K3909 VARCHAR2(20), K3910 VARCHAR2(20), K3911 VARCHAR2(20), K3912 VARCHAR2(20), K3913 VARCHAR2(20), K3914 VARCHAR2(20), K3915 VARCHAR2(20), K3916 VARCHAR2(20), K3917 VARCHAR2(20), K3920 VARCHAR2(20), K3921 VARCHAR2(20), K3923 VARCHAR2(20), K3924 VARCHAR2(20), K3925 VARCHAR2(20), K3926 VARCHAR2(20), K3927 VARCHAR2(20), K3931 VARCHAR2(50), K3932 VARCHAR2(50), K3933 VARCHAR2(50), K3934 VARCHAR2(50), K3935 VARCHAR2(50), K3936 VARCHAR2(50), K3937 VARCHAR2(50), K3938 VARCHAR2(50), K3939 VARCHAR2(50), K3940 VARCHAR2(50), K3941 VARCHAR2(50), K3942 VARCHAR2(50), K3943 VARCHAR2(50), K3944 VARCHAR2(50), K3945 VARCHAR2(50), K3946 VARCHAR2(50), K3947 VARCHAR2(50), K3950 VARCHAR2(50), K3951 VARCHAR2(50), K3953 VARCHAR2(50), K3954 VARCHAR2(50), K3955 VARCHAR2(50), K3956 VARCHAR2(50), K3957 VARCHAR2(50), K3961 NUMBER(5,0), K3962 NUMBER(5,0), K3963 NUMBER(5,0), K3964 NUMBER(5,0), K3965 NUMBER(5,0), K3966 NUMBER(5,0), K3967 NUMBER(5,0), K3968 NUMBER(5,0), K3969 NUMBER(5,0), K3970 NUMBER(5,0), K3971 NUMBER(5,0), K3972 NUMBER(5,0), K3973 NUMBER(5,0), K3974 NUMBER(5,0), K3975 NUMBER(5,0), K3976 NUMBER(5,0), K3977 NUMBER(5,0), K3980 NUMBER(5,0), K3981 NUMBER(5,0), K3983 NUMBER(5,0), K3984 NUMBER(5,0), K3985 NUMBER(5,0), K3986 NUMBER(5,0), K3987 NUMBER(5,0), -- ab PPAP 4. Aufl. K3186 VARCHAR2(20), K3192 NUMBER(3,0), K3250 VARCHAR2(50), K3251 VARCHAR2(30), K3770 NUMBER(3,0), K3771 VARCHAR2(80), K3371 VARCHAR2(30), K3377 DATE, K3436 NUMBER(5,0), K3780 VARCHAR2(120), K3781 VARCHAR2(120), K3782 VARCHAR2(120) ) TABLESPACE QDAS_DEFAULT; create unique index EMPB_3000 on EMPB_3000(K3000); CREATE TABLE EMPB_3000_ZUS ( K3000 NUMBER(10,0), K3418 NUMBER(5,0), K3419 NUMBER(5,0), K3500 NUMBER(5,0), K3501 NUMBER(5,0), K3502 NUMBER(5,0), K3503 NUMBER(5,0), K3504 NUMBER(5,0), K3505 NUMBER(5,0), K3506 NUMBER(5,0), K3507 NUMBER(5,0), K3508 NUMBER(5,0), K3509 NUMBER(5,0), K3510 NUMBER(5,0), K3660 VARCHAR2(20), K3661 VARCHAR2(20), K3662 VARCHAR2(20), K3663 VARCHAR2(20), K3664 VARCHAR2(20), K3665 VARCHAR2(20), K3666 VARCHAR2(20), K3667 VARCHAR2(20), K3668 VARCHAR2(20), K3669 VARCHAR2(20), K3670 VARCHAR2(20), K3673 VARCHAR2(50), K3674 VARCHAR2(50), K3675 VARCHAR2(50), K3676 VARCHAR2(50), K3677 VARCHAR2(50), K3678 VARCHAR2(50), K3679 VARCHAR2(50), K3680 VARCHAR2(50), K3681 VARCHAR2(50), K3682 VARCHAR2(50), K3683 VARCHAR2(50), K3686 NUMBER(5,0), K3687 NUMBER(5,0), K3688 NUMBER(5,0), K3689 NUMBER(5,0), K3690 NUMBER(5,0), K3691 NUMBER(5,0), K3692 NUMBER(5,0), K3693 NUMBER(5,0), K3694 NUMBER(5,0), K3695 NUMBER(5,0), K3696 NUMBER(5,0), K3220 VARCHAR2(40), K3221 DATE ) TABLESPACE QDAS_DEFAULT; create unique index EMPB_3000_ZUS on EMPB_3000_ZUS(K3000); Create table MEMO_FIELDS( MM_PART NUMBER(10,0), MM_CHARACT NUMBER(5,0), MM_MEASVALUE NUMBER(10,0), MM_K_R_KEY NUMBER(5,0), MM_K_FIELD NUMBER(5,0), MM_CONTENTS LONG ) TABLESPACE QDAS_DEFAULT; create unique index MEMO_FIELDS on MEMO_FIELDS(MM_PART, MM_CHARACT, MM_MEASVALUE, MM_K_R_KEY, MM_K_FIELD); create table MITARB ( MIMITARB NUMBER(10,0), MINAME1 VARCHAR2(50), MINAME2 VARCHAR2(50), MIABT VARCHAR2(50), MITELEFON VARCHAR2(50), MIFAX VARCHAR2(50), MIEMAIL VARCHAR2(50), MIPOS VARCHAR2(30), MIANREDE VARCHAR2(15), MISTATE NUMBER(10,0) default 0, MIBEMERK VARCHAR2(200) ) TABLESPACE QDAS_DEFAULT; create unique index MITARB on MITARB (MIMITARB); create table SIGNATUR ( SIGNATUR_ID NUMBER(10,0), SIGNATUR_COUNTER NUMBER(5,0), SIGNATUR_MODUL NUMBER(5,0), SIGNATUR_USER VARCHAR2(50), SIGNATUR_USERDATE DATE, SIGNATUR_COMMENT VARCHAR2(255), SIGNATUR_REASON NUMBER(5,0) ) TABLESPACE QDAS_DEFAULT; create unique index SIGNATUR on SIGNATUR (SIGNATUR_ID,SIGNATUR_COUNTER); create table SIGNATUR_FILES ( SIGNATUR_ID NUMBER(10,0), SIGNATUR_COUNTER NUMBER(10,0), SIGNATUR_TYPE NUMBER(10,0), SIGNATUR_ENTRY LONG RAW, SIGNATUR_DESC VARCHAR2(255), SIGNATUR_SIZE VARCHAR2(20) ) TABLESPACE QDAS_DEFAULT; create unique index SIGNATUR_FILES on SIGNATUR_FILES (SIGNATUR_ID,SIGNATUR_COUNTER,SIGNATUR_TYPE); create table SIGNATUR_MASTER ( SIGNATUR_ID NUMBER(10,0), SIGNATUR_MODUL NUMBER(5,0), SIGNATUR_MASTERKEY VARCHAR2(255), SIGNATUR_DATE DATE, SIGNATUR_EVALSTRAT NUMBER(10,0), SIGNATUR_EVALNAME VARCHAR2(50), SIGNATUR_COMMENT1 VARCHAR2(255), SIGNATUR_COMMENT2 VARCHAR2(255), SIGNATUR_COMMENT3 VARCHAR2(255) ) TABLESPACE QDAS_DEFAULT; create unique index SIGNATUR_MASTER on SIGNATUR_MASTER (SIGNATUR_ID); create table SIGNATUR_REASON ( SIGNATUR_REASON NUMBER(5,0), SIGNATUR_MODUL NUMBER(5,0), SIGNATUR_REASON_DESC VARCHAR2(50), SIGNATUR_MUSTFILL NUMBER(5,0) ) TABLESPACE QDAS_DEFAULT; create unique index SIGNATUR_REASON on SIGNATUR_REASON (SIGNATUR_REASON,SIGNATUR_MODUL); Insert INTO SIGNATUR_REASON VALUES(1,1,'Review',1); Insert INTO SIGNATUR_REASON VALUES(2,1,'Approval',2); Insert INTO SIGNATUR_REASON VALUES(1,10,'Review',1); Insert INTO SIGNATUR_REASON VALUES(2,10,'Approval',2); Insert INTO SIGNATUR_REASON VALUES(1,20,'Review',1); Insert INTO SIGNATUR_REASON VALUES(2,20,'Approval',2); Insert INTO SIGNATUR_REASON VALUES(1,26,'Review',1); Insert INTO SIGNATUR_REASON VALUES(2,26,'Approval',2); Insert INTO SIGNATUR_REASON VALUES(1,30,'Review',1); Insert INTO SIGNATUR_REASON VALUES(2,30,'Approval',2); Insert INTO SIGNATUR_REASON VALUES(1,60,'Review',1); Insert INTO SIGNATUR_REASON VALUES(2,60,'Approval',2); CREATE TABLE ARCHIVES( ARARCHIVENO NUMBER(10,0), ARSTARTDATE DATE, ARENDDATE DATE, ARDATABASE VARCHAR2(150), ARDBTYPE NUMBER(10,0), ARTABLESUFFIX VARCHAR2(20), ARACTIVATED NUMBER(3,0), ARARCHIVATED NUMBER(3,0), ARVALUESDELETED NUMBER(3,0) ) TABLESPACE QDAS_DEFAULT; CREATE UNIQUE INDEX ARCHIVES ON ARCHIVES(ARARCHIVENO); CREATE TABLE ARCHIVEACTIONS( AAARCHIVENO NUMBER(10,0), AAACTIONNO NUMBER(10,0), AADATE DATE, AAUSER VARCHAR2(50), AAACTION NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; CREATE UNIQUE INDEX ARCHIVEACTIONS ON ARCHIVEACTIONS(AAARCHIVENO, AAACTIONNO); CREATE TABLE RESULTS( RPART NUMBER(10,0), RCHARACTERISTIC NUMBER(10,0), RMODULE NUMBER(10,0), RFIRSTDATE DATE, RLASTDATE DATE, ROPERATOR NUMBER(10,0), RGAGE NUMBER(10,0), RMACHINE NUMBER(10,0), RNEST NUMBER(10,0), RBATCHNO VARCHAR2(20), RORDERNO VARCHAR2(20), RSEPERFIELDS VARCHAR2(50), RSTRATEGY NUMBER(10,0), RID NUMBER(10,0), RAUSWSTATUS NUMBER(10,0), RCWERTEART NUMBER(10,0), RCWERTEQUALITAET NUMBER(10,0), RMFA VARCHAR2(4000), R1000_0 FLOAT, R1000_0_T FLOAT, R1100_0 FLOAT, R1100_0_T FLOAT, R1200_0 FLOAT, R1200_0_T FLOAT, R1300_0 FLOAT, R1300_0_T FLOAT, R2000_0 FLOAT, R2000_0_T FLOAT, R2100_0 FLOAT, R2100_0_T FLOAT, R2300_0 FLOAT, R2300_0_T FLOAT, R4180_1 FLOAT, R4180_1_T FLOAT, R4190_1 FLOAT, R4190_1_T FLOAT, R4180_2 FLOAT, R4180_2_T FLOAT, R4190_2 FLOAT, R4190_2_T FLOAT, R4180_3 FLOAT, R4180_3_T FLOAT, R4190_3 FLOAT, R4190_3_T FLOAT, R4180_4 FLOAT, R4180_4_T FLOAT, R4190_4 FLOAT, R4190_4_T FLOAT, R4180_5 FLOAT, R4180_5_T FLOAT, R4190_5 FLOAT, R4190_5_T FLOAT, R4180_6 FLOAT, R4180_6_T FLOAT, R4190_6 FLOAT, R4190_6_T FLOAT, R4180_7 FLOAT, R4180_7_T FLOAT, R4190_7 FLOAT, R4190_7_T FLOAT, R4210_25 FLOAT, R4210_25_T FLOAT, R4210_75 FLOAT, R4210_75_T FLOAT, R5210_0 FLOAT, R5210_0_T FLOAT, R5220_0 FLOAT, R5220_0_T FLOAT, R5210_10 FLOAT, R5210_10_T FLOAT, R5220_10 FLOAT, R5220_10_T FLOAT, R6000_0 FLOAT, R6000_0_T FLOAT, R6100_0 FLOAT, R6101_0 FLOAT, R6102_0 FLOAT, R6103_0 FLOAT, R6104_0 FLOAT, R6301_0 FLOAT, R6302_0 FLOAT, R8910_0 FLOAT, R10500_0 FLOAT, R10501_0 FLOAT, R15000_0 FLOAT, R5240_0 FLOAT, R5240_0_T FLOAT, R5240_10 FLOAT, R5240_10_T FLOAT, K2005_0 NUMBER(5,0), R5210_20 FLOAT, R5210_20_T FLOAT, R5220_20 FLOAT, R5220_20_T FLOAT, REVENTS VARCHAR2(100), R5500_0 FLOAT, R5500_0_T FLOAT, R5510_0 FLOAT, R5510_0_T FLOAT, R5520_0 FLOAT, R5520_0_T FLOAT, R5530_0 FLOAT, R5530_0_T FLOAT ) TABLESPACE QDAS_DEFAULT; CREATE INDEX RESULTS ON RESULTS(RPART, RCHARACTERISTIC, RMODULE, RSTRATEGY); CREATE TABLE RESULTS_FILES( RPART NUMBER(10,0), RCHARACTERISTIC NUMBER(10,0), RMODULE NUMBER(10,0), RFIRSTDATE DATE, RLASTDATE DATE, ROPERATOR NUMBER(10,0), RGAGE NUMBER(10,0), RMACHINE NUMBER(10,0), RNEST NUMBER(10,0), RBATCHNO VARCHAR2(20), RORDERNO VARCHAR2(20), RSEPERFIELDS VARCHAR2(50), RSTRATEGY NUMBER(10,0), RID NUMBER(10,0), RREPORT_NUM NUMBER(5,0), RENTRY_TYPE NUMBER(10,0), RENTRY LONG RAW, REPORTNAME VARCHAR2(255) ) TABLESPACE QDAS_DEFAULT; CREATE INDEX RESULTS_FILES ON RESULTS_FILES(RPART, RCHARACTERISTIC, RMODULE, RSTRATEGY); create table TRANSMIT_HEADER ( STATIONGUID RAW(16), TEILGUID RAW(16), MERKMALGUID RAW(16), KFELD NUMBER(5), INHALT LONG, AENDDAT DATE, AENDUSER VARCHAR2(50), STATUS NUMBER(10) ) TABLESPACE QWERT_TABLE ; CREATE INDEX TH_AENDDAT ON TRANSMIT_HEADER(AENDDAT); CREATE INDEX TH_MERKMAL ON TRANSMIT_HEADER(MERKMALGUID); CREATE INDEX TH_TEIL ON TRANSMIT_HEADER(TEILGUID); create table TRANSMIT_WERTEVAR ( WVTEILGUID RAW(16), WVMERKMALGUID RAW(16), WVUNTERS NUMBER(5), WVWERTNR NUMBER(10), WVWERT FLOAT(126), WVATTRIBUT NUMBER(5), WVPRUEFER NUMBER(10), WVPRUEFMIT NUMBER(10), WVMASCHINE NUMBER(10), WVNEST NUMBER(10), WVDATZEIT DATE, WVSTIANF NUMBER(3), WVCHARGE VARCHAR2(20), WVAUFTRAG VARCHAR2(20), WVSTATUS NUMBER(10), WVAENDDAT DATE, WVAENDUSER VARCHAR2(20), WV0005 VARCHAR2(35) ) TABLESPACE QWERT_TABLE ; CREATE INDEX TW_WVATTRIBUT ON TRANSMIT_WERTEVAR(WVATTRIBUT); CREATE INDEX TW_WVTEILGUID ON TRANSMIT_WERTEVAR(WVTEILGUID); CREATE INDEX TW_WVMERKMALGUID ON TRANSMIT_WERTEVAR(WVMERKMALGUID); CREATE INDEX TW_WVDATZEIT ON TRANSMIT_WERTEVAR(WVDATZEIT); CREATE INDEX TW_WVMASCHINE ON TRANSMIT_WERTEVAR(WVMASCHINE); CREATE INDEX TW_WVNEST ON TRANSMIT_WERTEVAR(WVNEST); CREATE INDEX TW_WVPRUEFER ON TRANSMIT_WERTEVAR(WVPRUEFER); CREATE INDEX TW_WVPRUEFMIT ON TRANSMIT_WERTEVAR(WVPRUEFMIT); CREATE INDEX TW_WV0005 ON TRANSMIT_WERTEVAR(WV0005); create table STATION ( STATION_KEY RAW(16), STATION_NO VARCHAR2(50), STATION_DESC VARCHAR2(50), STATION_IP VARCHAR2(50), LASTSUCCESSFULL_SYNCH_END DATE, STATION_SYNCH_DATE_SERVER DATE, SYNCHRONIZE_START DATE, SYNCHRONIZE_END DATE, SYNCHRONIZE_INTERVAL DATE, SYNCHRONIZE_OFFSET DATE, LAST_SYNCH_START DATE, NEXT_SYNCH_EVENT DATE, DB_COMPRESS_INTERVAL DATE, LAST_DB_COMPRESSION DATE, MAX_VALUES NUMBER(10), MAX_LOGFILES_SIZE NUMBER(10), WITHOUT_REQUEST NUMBER(3,0), INFO VARCHAR2(255), STATION_PATH VARCHAR2(255), PP_DESELECT NUMBER(3,0) ) TABLESPACE QDAS_DEFAULT; CREATE UNIQUE INDEX STATION ON STATION(STATION_KEY); create table STATIONS_PART ( STATION RAW(16), PART NUMBER(10), LASTERROR VARCHAR2(255), CHANGEDATETIME DATE, TODELETE NUMBER(3,0) ) TABLESPACE QDAS_DEFAULT; CREATE UNIQUE INDEX STATIONS_PART ON STATIONS_PART(STATION,PART); CREATE TABLE ORDKLASS ( OKKEY NUMBER(10,0), OKNR VARCHAR2(40), OKBEZ VARCHAR2(100), OKKURZBEZ VARCHAR2(20), OKBEWERT NUMBER(5,0) default 0, OKSTATE NUMBER(10,0) default 0, OKRANG NUMBER(10, 0), OKBEMERK VARCHAR2(200) ) TABLESPACE QDAS_DEFAULT; CREATE UNIQUE INDEX ORDKLASS ON ORDKLASS(OKKEY); CREATE TABLE ORDKLASSKAT ( OKKKEY NUMBER(10,0), OKKBEZ VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; CREATE UNIQUE INDEX ORDKLASSKAT ON ORDKLASSKAT(OKKKEY); CREATE TABLE ZU_OK_OKK ( OKKEY NUMBER(10,0), OKKKEY NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; CREATE UNIQUE INDEX ZU_OK_OKK ON ZU_OK_OKK(OKKEY, OKKKEY); CREATE TABLE FORMS ( FO_GUID RAW(16), FO_PARTGUID RAW(16), FO_CHARGUID RAW(16), FO_USAGE NUMBER(3,0), FO_MODULES VARCHAR2(50), FO_GC_TYPES VARCHAR2(50), FO_INTKEY1 NUMBER(10,0), FO_INTKEY2 NUMBER(10,0), FO_STRINGKEY1 VARCHAR2(50), FO_STRINGKEY2 VARCHAR2(50), FO_NAME VARCHAR2(50), FO_CONTENTS LONG, FO_ALLPARTGUIDS VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; CREATE UNIQUE INDEX FORMS ON FORMS(FO_GUID); CREATE TABLE FORMS_PARTS ( FO_GUID RAW(16), FO_ALL_PART_GUIDS LONG ) TABLESPACE QDAS_DEFAULT; CREATE UNIQUE INDEX FORMS_PARTS ON FORMS_PARTS(FO_GUID); CREATE TABLE PSTEPS ( PV_VORGANGGUID RAW(16), PV_STEP NUMBER(10,0), PV_STEPNAME VARCHAR2(50), PV_START DATE, PV_END DATE, PV_USER NUMBER(5,0), PV_COMMENT LONG ) TABLESPACE QDAS_DEFAULT; CREATE UNIQUE INDEX PSTEPS ON PSTEPS(PV_VORGANGGUID,PV_STEP); CREATE TABLE PVERSUCH ( PVPLAN NUMBER(10,0), PVAUFTRAG NUMBER(10,0), PVVORGANG NUMBER(5,0), PVVERSUCH NUMBER(5,0), PVVERSUCHNR VARCHAR2(40), PVBEZEICH VARCHAR2(80), PVBEMERK LONG, PVDATZEIT DATE, PVANMDAT DATE, PVANMBEN NUMBER(5,0), PVAENDDAT DATE, PVAENDBEN NUMBER(5,0), PVBEGINN DATE, PVENDE DATE, PV_VORGANGGUID RAW(16), PV_0031 RAW(16), PV_STATUS NUMBER(5,0), PV_SIGNATUR_ID NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; CREATE UNIQUE INDEX PVERSUCH ON PVERSUCH(PVPLAN,PVAUFTRAG,PVVORGANG,PVVERSUCH); CREATE INDEX PVERSUCH_VORG ON PVERSUCH(PV_VORGANGGUID); CREATE INDEX PVERSUCH_SIGID ON PVERSUCH(PV_SIGNATUR_ID); CREATE TABLE REDUCED_FIELDS ( FIELDLISTID NUMBER(10,0), FIELDLISTNAME VARCHAR2(50), FIELDREDUCED NUMBER(5,0), FIELDMERKMAL_ZUS NUMBER(5,0), FIELDLIST LONG ) TABLESPACE QDAS_DEFAULT; CREATE UNIQUE INDEX REDUCED_FIELDS ON REDUCED_FIELDS(FIELDLISTID); create table SERIAL_NUMBERS ( SERIAL_ID NUMBER(10,0), SERIAL_NO VARCHAR2(50), CUST_SERIAL_NO VARCHAR2(50), CUSTOMER_ID NUMBER(10,0), PRODUCTION_DATE DATE, ORDER_NO VARCHAR2(50), PALLET_NO VARCHAR2(50), BATCH_NO VARCHAR2(50), CUST_DESCR VARCHAR2(40), PROJECT_NO VARCHAR2(20), ADDITIONAL_DATE DATE, K0005 VARCHAR2(40), K0007 NUMBER(10,0), K0008 NUMBER(10,0), K0009 VARCHAR2(100), K0010 NUMBER(10,0), K0011 VARCHAR2(40), K0012 NUMBER(10,0), K0014 VARCHAR2(32), K0015 NUMBER(10,0), K0016 VARCHAR2(32), K0017 VARCHAR2(32), K0054 VARCHAR2(32), K0055 VARCHAR2(32), K0056 VARCHAR2(32), K0057 VARCHAR2(32), K0058 VARCHAR2(32), K0059 VARCHAR2(32), K0060 VARCHAR2(32), K0061 NUMBER(10,0), K0062 NUMBER(10,0), K0063 NUMBER(10,0) ) TABLESPACE qwert_table PCTFREE 20 PCTUSED 80 --PARALLEL (DEGREE DEFAULT) ; create unique index SERIAL_NUMBERS_ID on SERIAL_NUMBERS (SERIAL_ID) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create index SERIAL_NUMBERS_NO on SERIAL_NUMBERS (SERIAL_NO) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create index SERIAL_NUMBERS_CUNO on SERIAL_NUMBERS (CUST_SERIAL_NO) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create index SERIAL_NUMBERS_DATE on SERIAL_NUMBERS (PRODUCTION_DATE) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create table SERIAL_KEYS ( SERIAL_ID NUMBER(10,0), STATION NUMBER(10,0), SERIAL_NO VARCHAR2(50), SERIAL_DATE DATE, READING_QLTY_ALL VARCHAR2(20), READING_QLTY_1 VARCHAR2(20), READING_QLTY_2 VARCHAR2(20), READING_QLTY_3 VARCHAR2(20), READING_QLTY_4 VARCHAR2(20), ORDER_NO VARCHAR2(50), PALLET_NO VARCHAR2(50), GREENBODY_NO VARCHAR2(50), DRAWING_NO VARCHAR2(50), DRAWIND_IDX VARCHAR2(30), MATERIAL_NO VARCHAR2(50), PLANT VARCHAR2(50), MATERIAL_TEXT VARCHAR2(80), DIMENSION VARCHAR2(20), INSPECTIONLOT VARCHAR2(20), ADDITIONAL_DATE DATE, K0005 VARCHAR2(40), K0007 NUMBER(10,0), K0008 NUMBER(10,0), K0009 VARCHAR2(100), K0010 NUMBER(10,0), K0011 VARCHAR2(40), K0012 NUMBER(10,0), K0014 VARCHAR2(32), K0015 NUMBER(10,0), K0016 VARCHAR2(32), K0017 VARCHAR2(32), K0054 VARCHAR2(32), K0055 VARCHAR2(32), K0056 VARCHAR2(32), K0057 VARCHAR2(32), K0058 VARCHAR2(32), K0059 VARCHAR2(32), K0060 VARCHAR2(32), K0061 NUMBER(10,0), K0062 NUMBER(10,0), K0063 NUMBER(10,0), BATCH_NO VARCHAR2(50) ) TABLESPACE qwert_table PCTFREE 20 PCTUSED 80 --PARALLEL (DEGREE DEFAULT) ; create unique index SERIAL_KEYS on SERIAL_KEYS (SERIAL_ID, STATION) TABLESPACE qwert_index --PARALLEL (DEGREE DEFAULT) ; create table EQUIPMENT ( EQ_KEY NUMBER(10,0), EQ_NUMBER VARCHAR2(30), EQ_DESC VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; create unique index EQUIPMENT on EQUIPMENT(EQ_KEY); create table SERIAL_EQUIPMENT ( SERIAL_ID NUMBER(10,0), STATION NUMBER(10,0), EQUIPMENT_KEY NUMBER(10,0), EQUIPMENT_BATCHNO VARCHAR2(50), EQUIPMENT_PARTNO VARCHAR2(50), EQUIPMENT_DMC VARCHAR2(50), EQUIPMENT_ORDERNO VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; create unique index SERIAL_EQUIPMENT on SERIAL_EQUIPMENT(SERIAL_ID, STATION, EQUIPMENT_KEY); create index SERIAL_ID on SERIAL_EQUIPMENT(SERIAL_ID); create table KUNDEKAT ( KUKNR NUMBER(10,0), KUKBEZ VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; create unique index KUNDEKAT on KUNDEKAT(KUKNR); create table ZU_KU_KUK ( KUKEY NUMBER(10,0), KUKNR NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_KU_KUK on ZU_KU_KUK(KUKEY, KUKNR); create table HERSTELLKAT ( HEKNR NUMBER(10,0), HEKBEZ VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; create unique index HERSTELLKAT on HERSTELLKAT(HEKNR); create table ZU_HE_HEK ( HEKEY NUMBER(10,0), HEKNR NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_HE_HEK on ZU_HE_HEK(HEKEY, HEKNR); create table LIEFKAT ( LIKNR NUMBER(10,0), LIKBEZ VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; create unique index LIEFKAT on LIEFKAT(LIKNR); create table ZU_LI_LIK ( LIKEY NUMBER(10,0), LIKNR NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_LI_LIK on ZU_LI_LIK(LIKEY, LIKNR); create table PAUFTKAT ( PAKNR NUMBER(10,0), PAKBEZ VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; create unique index PAUFTKAT on PAUFTKAT(PAKNR); create table ZU_PA_PAK ( PAKEY NUMBER(10,0), PAKNR NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_PA_PAK on ZU_PA_PAK(PAKEY, PAKNR); create table WERKSTOFFKAT ( WSKNR NUMBER(10,0), WSKBEZ VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; create unique index WERKSTOFFKAT on WERKSTOFFKAT(WSKNR); create table ZU_WS_WSK ( WSKEY NUMBER(10,0), WSKNR NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_WS_WSK on ZU_WS_WSK(WSKEY, WSKNR); create table ZEICHNKAT ( ZNKNR NUMBER(10,0), ZNKBEZ VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; create unique index ZEICHNKAT on ZEICHNKAT(ZNKNR); create table ZU_ZN_ZNK ( ZNKEY NUMBER(10,0), ZNKNR NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_ZN_ZNK on ZU_ZN_ZNK(ZNKEY, ZNKNR); create table MASCHINKAT ( MAKNR NUMBER(10,0), MAKBEZ VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; create unique index MASCHINKAT on MASCHINKAT(MAKNR); create table ZU_MA_MAK ( MAKEY NUMBER(10,0), MAKNR NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_MA_MAK on ZU_MA_MAK(MAKEY, MAKNR); create table PRUEFMITKAT ( PMKNR NUMBER(10,0), PMKBEZ VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; create unique index PRUEFMITKAT on PRUEFMITKAT(PMKNR); create table ZU_PM_PMK ( PMKEY NUMBER(10,0), PMKNR NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_PM_PMK on ZU_PM_PMK(PMKEY, PMKNR); create table EINHEITKAT ( EIKNR NUMBER(10,0), EIKBEZ VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; create unique index EINHEITKAT on EINHEITKAT(EIKNR); create table ZU_EI_EIK ( EIKEY NUMBER(10,0), EIKNR NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_EI_EIK on ZU_EI_EIK(EIKEY, EIKNR); create table PRUEFERKAT ( PRKNR NUMBER(10,0), PRKBEZ VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; create unique index PRUEFERKAT on PRUEFERKAT(PRKNR); create table ZU_PR_PRK ( PRKEY NUMBER(10,0), PRKNR NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_PR_PRK on ZU_PR_PRK(PRKEY, PRKNR); create table AUFTRGEBKAT ( AUGKNR NUMBER(10,0), AUGKBEZ VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; create unique index AUFTRGEBKAT on AUFTRGEBKAT(AUGKNR); create table ZU_AUG_AUGK ( AUGKEY NUMBER(10,0), AUGKNR NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_AUG_AUGK on ZU_AUG_AUGK(AUGKEY, AUGKNR); create table ERZEUGNISKAT ( EZKNR NUMBER(10,0), EZKBEZ VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; create unique index ERZEUGNISKAT on ERZEUGNISKAT(EZKNR); create table ZU_EZ_EZK ( EZKEY NUMBER(10,0), EZKNR NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_EZ_EZK on ZU_EZ_EZK(EZKEY, EZKNR); create table MITARBKAT ( MIKNR NUMBER(10,0), MIKBEZ VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; create unique index MITARBKAT on MITARBKAT(MIKNR); create table ZU_MI_MIK ( MIKEY NUMBER(10,0), MIKNR NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_MI_MIK on ZU_MI_MIK(MIKEY, MIKNR); create table NESTKAT ( NEKNR NUMBER(10,0), NEKBEZ VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; create unique index NESTKAT on NESTKAT(NEKNR); create table ZU_NE_NEK ( NEKEY NUMBER(10,0), NEKNR NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_NE_NEK on ZU_NE_NEK(NEKEY, NEKNR); CREATE SEQUENCE SIGNATURE_KEYS MINVALUE 1 INCREMENT BY 1 START WITH 1 NOCACHE ORDER; create table MERKMAL_MASTER ( METEIL NUMBER(10,0) , MEMERKMAL NUMBER(5,0) , MEMERKNR VARCHAR2(20) , MEMERKBEZ VARCHAR2(80) , MENENNMAS FLOAT , MEARTUGW NUMBER(5,0) , MEARTOGW NUMBER(5,0) , MEARTPLAUSIUNT NUMBER(5,0) , MEARTPLAUSIOB NUMBER(5,0) , MEUGW FLOAT , MEOGW FLOAT , MEFSK NUMBER(5,0) , MEFEHLART NUMBER(3,0) , MEFEHLKOST FLOAT , MEDPFLICHT NUMBER(5,0) , MEEINHEIT NUMBER(5,0) , MEAUFLOES NUMBER(5,0) , MEKLASSENW FLOAT , MEFERTARTNR VARCHAR2(20) , MEFERTART VARCHAR2(80) , MEPMGRUPPE NUMBER(5,0) , MEPRUEFMIT NUMBER(10,0) , MEPRUEFMITNR NUMBER(5,0) , MEPMGRUPPET VARCHAR2(80) , MEPRUEFMITT VARCHAR2(80) , MEPRUEFMITNRT VARCHAR2(80) , MEERFART NUMBER(5,0) , MEMASCHINE NUMBER(10,0) , MEBEMERK LONG , MESTIFREQ NUMBER(5,0) , MEUMFSTICH NUMBER(5,0) , MEANZSTICH NUMBER(10,0) , MEANZMESSGC NUMBER(10,0) , MEANZPRUEF NUMBER(10,0) , MEUMFPROZ NUMBER(5,0) , MEANZWIED NUMBER(5,0) , MEANZTEILE NUMBER(10,0) , MENENNMAST VARCHAR2(50) , MEUGWT VARCHAR2(50) , MEOGWT VARCHAR2(50) , MEPLAUSIUT VARCHAR2(50) , MEPLAUSIOT VARCHAR2(50) , METOLERANZ NUMBER(5,0) , MEFORMEL VARCHAR2(255) , METRANSART NUMBER(3,0) , METRANSPA FLOAT , METRANSPB FLOAT , METRANSPC FLOAT , METRANSPD FLOAT , MEGLMITT NUMBER(5,0) , MEAUSWART NUMBER(5,0) , MEAUSWTYP NUMBER(5,0) , MEMERKART NUMBER(5,0) , MEVERTFORM NUMBER(5,0) , MEPLAUSIOB FLOAT , MEPLAUSIUN FLOAT , MEPROSTREUSTR VARCHAR2(40) , MEPROSTREU FLOAT , MENORMISTSTR VARCHAR2(80) , MENORMIST FLOAT , -- MENORMNR VARCHAR2(20) , korrigiert 12.11.99 MENORMNR VARCHAR2(40) , MENORMBEZ VARCHAR2(40) , MENORMTEMP VARCHAR2(40) , MEKONFIG VARCHAR2(1000) , MEKLASSUNT FLOAT , MEKLASSOB FLOAT , MEKLASSNR FLOAT , MEVORGCP FLOAT , MEVORGCPK FLOAT , MESTEUERB NUMBER(3,0) , MEEREIGKAT VARCHAR2(50) , MEZYKLUS NUMBER(5,0) , MEPRUEFZST NUMBER(5,0) , MEPRUEFORT NUMBER(5,0) , MEMASSN NUMBER(5,0) , MENENNMASSP VARCHAR2(50) , MEPRFSPEC NUMBER(5,0) , MEAUTOAKT NUMBER(5,0) , MEMERKKLASSE NUMBER(5,0) , MEUNTERSART NUMBER(5,0) , MEANZORDKLASSE NUMBER(5,0) , MEGLEITSTUMF NUMBER(5,0) , MEPUFFERSIZE NUMBER(5,0) , MEAUTOERKENNUNG NUMBER(5,0) , MEATTR NUMBER(5,0) , METRANSFEING NUMBER(5,0) , METRANSFEINGA FLOAT , METRANSFEINGB FLOAT , MENLINKSMA NUMBER(5,0) , MEERFKANAL VARCHAR2(20) , MEERFSUBKANAL VARCHAR2(20) , MENACHARBEIT NUMBER(5,0) , MEZIELWERT FLOAT , MEZIELWERTT FLOAT , MEPMAX FLOAT , MEEINHEITTEXT VARCHAR2(80) , MELOSUMFANG NUMBER(10,0) , MEKOSTENNACHARBEIT FLOAT , MEKOSTENAUSSCHUSS FLOAT , MEMASCHNR VARCHAR2(24) , MEMASCHBEZ VARCHAR2(80) , MEABT VARCHAR2(40) , MESTANDORT VARCHAR2(80) , MEAUFTRNR VARCHAR2(80) , MEAUFTRAGGEBNR NUMBER(5,0) , MEAUFTRAGGEBNRT VARCHAR2(20) , MEAUFTRAGGEB VARCHAR2(80) , MEPRUEFORTT VARCHAR2(80) , MEPRUEFBEGINN VARCHAR2(80) , MEPRUEFENDE VARCHAR2(80) , MEPRUEFER NUMBER(10,0) , MEPRUEFERNR VARCHAR2(20) , MEPRUEFERNAME VARCHAR2(80) , MEPRUEFBEDING VARCHAR2(255) , MEAUGROUP NUMBER(5,0) , MEUPPERMERKMAL NUMBER(5,0) , METOLERANZTEXT VARCHAR2(80) , MEWERKSTCK NUMBER(10,0) , MEWERKSTCKTEXT VARCHAR2(80) , MEANZSPTEXT VARCHAR2(80) , MEPMAUFLOES FLOAT , MEPRUEFBEGINND DATE , MEPRUEFENDED DATE , MENORMAL NUMBER(5,0) , MENORMALTEMP FLOAT , MESTIFREQT VARCHAR2(80) , MEWERKSTCKNR VARCHAR2(20) , MEKURZBEZ VARCHAR2(20) , MEUGSCHROTT FLOAT , MEOGSCHROTT FLOAT , MECG FLOAT , MECGK FLOAT , MEABWGC FLOAT , MEZEICHN VARCHAR2(80) , MEFERTARTKEY NUMBER(5,0) , MEPMHERST VARCHAR2(40) , MEKORRSTRAT NUMBER(5,0) , MEUKG FLOAT , MEOKG FLOAT , MEKORRZIEL FLOAT , MEERFNR NUMBER(5,0) , MEERFNAME VARCHAR2(40) , MEERFINDEX NUMBER(5,0) , MEANFINDEX NUMBER(5,0) , MEINTERFACE NUMBER(5,0) , MEBAUD NUMBER(10,0) , MEIRQ NUMBER(5,0) , MEPARITY NUMBER(5,0) , MEDATA NUMBER(5,0) , MESTOP NUMBER(5,0) , MEPZPKAT NUMBER(5,0) , METOLERANZCALC FLOAT , MEBEREICH VARCHAR2(40) , MEPTM VARCHAR2(40) , MEPPLANNRT VARCHAR2(20) , MEPPLAN VARCHAR2(40) , MEPPLANDAT VARCHAR2(20) , MEPPLANERST VARCHAR2(40) , MESPCNR VARCHAR2(20) , MESPCHERST VARCHAR2(40) , MESPCTYP VARCHAR2(20) , MECP FLOAT , MECPK FLOAT , MECPFIX FLOAT , MECPKFIX FLOAT , MEGAGE25 VARCHAR2(110) , MEEINHREL VARCHAR2(20) , MEADDFAKREL FLOAT , MEMULFAKREL FLOAT , MENORMISTUN FLOAT , MENORMISTOB FLOAT , -- -- aus MERKMAL_AD MENORMALSERNR VARCHAR2(20), MEPRUEFMITSERNR VARCHAR2(20), MEANZGERAET VARCHAR2(40), MEREFTEILNRSTR VARCHAR2(20), MEREFTEILBEZ VARCHAR2(40), MEREFTEILIST FLOAT, MEREFTEILTEMP FLOAT, MEREFTEILNR NUMBER(5,0), MEREFTEILSERNR VARCHAR2(20), MEKALTEILUNRSTR VARCHAR2(20), MEKALTEILUBEZ VARCHAR2(40), MEKALTEILUIST FLOAT, MEKALTEILUTEMP FLOAT, MEKALTEILUNR NUMBER(5,0), MEKALTEILUSERNR VARCHAR2(20), MEKALTEILMNRSTR VARCHAR2(20), MEKALTEILMBEZ VARCHAR2(40), MEKALTEILMIST FLOAT, MEKALTEILMTEMP FLOAT, MEKALTEILMNR NUMBER(5,0), MEKALTEILMSERNR VARCHAR2(20), MEKALTEILONRSTR VARCHAR2(20), MEKALTEILOBEZ VARCHAR2(40), MEKALTEILOIST FLOAT, MEKALTEILOTEMP FLOAT, MEKALTEILONR NUMBER(5,0), MEKALTEILOSERNR VARCHAR2(20), MEUEBERKAN NUMBER(5,0), MEMERKCODE VARCHAR2(40), MEMERKINDEX VARCHAR2(20), MEMERKTEXT VARCHAR2(50), MEBEARBZUST VARCHAR2(80), MEELEMCODE VARCHAR2(40), MEELEMINDEX VARCHAR2(20), MEELEMTEXT VARCHAR2(50), MEELEMADR VARCHAR2(20), MEFREIFELD NUMBER(3,0), MECALIBADD FLOAT, MECALIBMULT FLOAT, MEANZNIAUSGEF NUMBER(10,0), MEGCKONVART NUMBER(3,0), MEANZREF NUMBER(5,0), MEREFPKTX NUMBER(5,0), MEREFPKTY NUMBER(5,0), MEREFPKTZ NUMBER(5,0), ME_2430 NUMBER(5,0), ME_2432 NUMBER(5,0), ME_2434 NUMBER(5,0), ME_2436 VARCHAR2(10), ME_2438 VARCHAR2(10), ME_2440 VARCHAR2(40), ME_2442 VARCHAR2(15), ME_2444 VARCHAR2(40), ME_2446 VARCHAR2(40), ME_2448 VARCHAR2(40), ME_8530 NUMBER(5,0), ME_8531 FLOAT, ME_8532 FLOAT, ME_8540 NUMBER(5,0), ME_2073 FLOAT, ME_2107 FLOAT, ME_2170 FLOAT, ME_2171 FLOAT, ME_2172 FLOAT, ME_2173 FLOAT, ME_2228 FLOAT, ME_2229 FLOAT, ME_2230 FLOAT, ME_2231 FLOAT, ME_2232 FLOAT, ME_2233 FLOAT, ME_2235 FLOAT, ME_2236 FLOAT, ME_2016 NUMBER(3,0), MEMASTERGUID RAW(16), MEGUID RAW(16) ) TABLESPACE qmerk_table PCTFREE 20 PCTUSED 80 --PARALLEL (DEGREE DEFAULT) ; create unique index MERKMAL_MASTER on MERKMAL_MASTER (MEMASTERGUID) TABLESPACE qmerk_index; create table PART_CHAR_OPER_LINK ( OPERATION_GUID RAW(16), PART_KEY NUMBER(10,0), CHAR_KEY NUMBER(10,0), CHAR_GUID RAW(16), SAMPLE_SIZE NUMBER(10,0), SAMPLE_FREQ VARCHAR2(50), RECORD_TYPE VARCHAR2(50), GAGE VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; create unique index PART_CHAR_OPER_LINK on PART_CHAR_OPER_LINK(OPERATION_GUID, PART_KEY, CHAR_KEY); create table PLANT_LEVEL ( LEVEL_ID NUMBER(10,0), LEVEL_NO VARCHAR2(50), LEVEL_DESC VARCHAR2(255), LEVEL_SOURCE NUMBER(10,0), LEVEL_DESC_NO VARCHAR2(255), LEVEL_TYPE_FIELD_NO VARCHAR2(50), LEVEL_DESC_DESC VARCHAR2(255), LEVEL_TYPE_FIELD_DESC VARCHAR2(50), LEVEL_IMAGE LONG RAW, LEVEL_NEW_TEXT VARCHAR2(50), LEVEL_DESC_FIELD_01 VARCHAR2(255), LEVEL_TYPE_FIELD_01 VARCHAR2(50), LEVEL_DESC_FIELD_02 VARCHAR2(255), LEVEL_TYPE_FIELD_02 VARCHAR2(50), LEVEL_DESC_FIELD_03 VARCHAR2(255), LEVEL_TYPE_FIELD_03 VARCHAR2(50), LEVEL_DESC_FIELD_04 VARCHAR2(255), LEVEL_TYPE_FIELD_04 VARCHAR2(50), LEVEL_DESC_FIELD_05 VARCHAR2(255), LEVEL_TYPE_FIELD_05 VARCHAR2(50), LEVEL_DESC_FIELD_06 VARCHAR2(255), LEVEL_TYPE_FIELD_06 VARCHAR2(50), LEVEL_DESC_FIELD_07 VARCHAR2(255), LEVEL_TYPE_FIELD_07 VARCHAR2(50), LEVEL_DESC_FIELD_08 VARCHAR2(255), LEVEL_TYPE_FIELD_08 VARCHAR2(50), LEVEL_DESC_FIELD_09 VARCHAR2(255), LEVEL_TYPE_FIELD_09 VARCHAR2(50), LEVEL_DESC_FIELD_10 VARCHAR2(255), LEVEL_TYPE_FIELD_10 VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; create unique index PLANT_LEVEL on PLANT_LEVEL(LEVEL_ID); create table PLANT_STRUCT ( NODE_ID RAW(16), PARENT_ID RAW(16), NODE_LEVEL NUMBER(10,0), NODE_LOCALPOS NUMBER(10,0), NODE_SOURCE_KEY NUMBER(10,0), NODE_SOURCE_GUID RAW(16), NODE_NO VARCHAR2(50), NODE_DESC VARCHAR2(255), NODE_IMAGE LONG RAW, NODE_FIELD_01 VARCHAR2(255), NODE_FIELD_02 VARCHAR2(255), NODE_FIELD_03 VARCHAR2(255), NODE_FIELD_04 VARCHAR2(255), NODE_FIELD_05 VARCHAR2(255), NODE_FIELD_06 VARCHAR2(255), NODE_FIELD_07 VARCHAR2(255), NODE_FIELD_08 VARCHAR2(255), NODE_FIELD_09 VARCHAR2(255), NODE_FIELD_10 VARCHAR2(255), NODE_FILTER_PART VARCHAR2(255), NODE_FILTER_CHAR VARCHAR2(255), NODE_FILTER_VALUE VARCHAR2(255) ) TABLESPACE QDAS_DEFAULT; create unique index PLANT_STRUCT on PLANT_STRUCT(NODE_ID); CREATE INDEX PLANT_STRUCT2 ON PLANT_STRUCT(NODE_LEVEL, NODE_LOCALPOS); CREATE TABLE PLANT_DISTR_NUMS ( MACHINE_NODE_ID RAW(16), CHAR_MASTER_GUID RAW(16), MACHINE_CATALOGKEY NUMBER(10,0), DISTR_NUMBER VARCHAR2(40) ) TABLESPACE QDAS_DEFAULT; create unique index PLANT_DISTR_NUMS on PLANT_DISTR_NUMS(MACHINE_NODE_ID, CHAR_MASTER_GUID); create index PDN_MACHINE_CATALOGKEY on PLANT_DISTR_NUMS(MACHINE_CATALOGKEY); CREATE TABLE LINE_ALERT_DISTRIB ( LINE_ID RAW(16), OPERATION_ID RAW(16), RECIPIENT_KEY NUMBER(10,0), EMAIL NUMBER(1,0), SMS NUMBER(1,0) ) TABLESPACE QDAS_DEFAULT; create unique index LINE_ALERT_DISTRIB on LINE_ALERT_DISTRIB(LINE_ID, OPERATION_ID, RECIPIENT_KEY); create table PRODUCT_LEVEL ( LEVEL_ID NUMBER(10,0), LEVEL_NO VARCHAR2(50), LEVEL_DESC VARCHAR2(255), LEVEL_SOURCE NUMBER(10,0), LEVEL_DESC_NO VARCHAR2(255), LEVEL_TYPE_FIELD_NO VARCHAR2(50), LEVEL_DESC_DESC VARCHAR2(255), LEVEL_TYPE_FIELD_DESC VARCHAR2(50), LEVEL_IMAGE LONG RAW, LEVEL_NEW_TEXT VARCHAR2(50), LEVEL_DESC_FIELD_01 VARCHAR2(255), LEVEL_TYPE_FIELD_01 VARCHAR2(50), LEVEL_DESC_FIELD_02 VARCHAR2(255), LEVEL_TYPE_FIELD_02 VARCHAR2(50), LEVEL_DESC_FIELD_03 VARCHAR2(255), LEVEL_TYPE_FIELD_03 VARCHAR2(50), LEVEL_DESC_FIELD_04 VARCHAR2(255), LEVEL_TYPE_FIELD_04 VARCHAR2(50), LEVEL_DESC_FIELD_05 VARCHAR2(255), LEVEL_TYPE_FIELD_05 VARCHAR2(50), LEVEL_DESC_FIELD_06 VARCHAR2(255), LEVEL_TYPE_FIELD_06 VARCHAR2(50), LEVEL_DESC_FIELD_07 VARCHAR2(255), LEVEL_TYPE_FIELD_07 VARCHAR2(50), LEVEL_DESC_FIELD_08 VARCHAR2(255), LEVEL_TYPE_FIELD_08 VARCHAR2(50), LEVEL_DESC_FIELD_09 VARCHAR2(255), LEVEL_TYPE_FIELD_09 VARCHAR2(50), LEVEL_DESC_FIELD_10 VARCHAR2(255), LEVEL_TYPE_FIELD_10 VARCHAR2(50) ) TABLESPACE QDAS_DEFAULT; create unique index PRODUCT_LEVEL on PRODUCT_LEVEL(LEVEL_ID); create table PRODUCT_STRUCT ( NODE_ID RAW(16), PARENT_ID RAW(16), NODE_LEVEL NUMBER(10,0), NODE_LOCALPOS NUMBER(10,0), NODE_SOURCE_KEY NUMBER(10,0), NODE_SOURCE_GUID RAW(16), NODE_NO VARCHAR2(50), NODE_DESC VARCHAR2(255), NODE_IMAGE LONG RAW, NODE_FIELD_01 VARCHAR2(255), NODE_FIELD_02 VARCHAR2(255), NODE_FIELD_03 VARCHAR2(255), NODE_FIELD_04 VARCHAR2(255), NODE_FIELD_05 VARCHAR2(255), NODE_FIELD_06 VARCHAR2(255), NODE_FIELD_07 VARCHAR2(255), NODE_FIELD_08 VARCHAR2(255), NODE_FIELD_09 VARCHAR2(255), NODE_FIELD_10 VARCHAR2(255), NODE_FILTER_PART VARCHAR2(255), NODE_FILTER_CHAR VARCHAR2(255), NODE_FILTER_VALUE VARCHAR2(255) ) TABLESPACE QDAS_DEFAULT; create unique index PRODUCT_STRUCT on PRODUCT_STRUCT(NODE_ID); CREATE INDEX PRODUCT_STRUCT2 ON PRODUCT_STRUCT(NODE_LEVEL, NODE_LOCALPOS); create table MEASUREMENT_DOKUMENTS ( MD_ID NUMBER(10,0), MD_TEIL NUMBER(10,0), MD_MEASUREMENT_IDENT VARCHAR2(50), MD_DOCDESCR VARCHAR2(50), MD_DOCPATH VARCHAR2(255), MD_MERKMAL NUMBER(10,0), MD_WERTNR NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index MEASUREMENT_DOKUMENTS on MEASUREMENT_DOKUMENTS(MD_ID); create index TEIL_VALUE on MEASUREMENT_DOKUMENTS(MD_TEIL, MD_MEASUREMENT_IDENT); create table KAT_4270 ( KATKEY NUMBER(10,0), NR VARCHAR2(20), BEZ VARCHAR2(100), STATE NUMBER(10,0), BEMERK VARCHAR2(200) ) TABLESPACE QDAS_DEFAULT; create unique index KAT_4270 on KAT_4270(KATKEY); create table KAT_4270KAT ( SUBKATKEY NUMBER(10,0), SUBKATNAME VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; create unique index KAT_4270KAT on KAT_4270KAT(SUBKATKEY); create table ZU_4270KAT ( KATKEY NUMBER(10,0), SUBKATKEY NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_4270KAT on ZU_4270KAT(KATKEY, SUBKATKEY); create table KAT_4280 ( KATKEY NUMBER(10,0), NR VARCHAR2(20), BEZ VARCHAR2(100), STATE NUMBER(10,0), BEMERK VARCHAR2(200) ) TABLESPACE QDAS_DEFAULT; create unique index KAT_4280 on KAT_4280(KATKEY); create table KAT_4280KAT ( SUBKATKEY NUMBER(10,0), SUBKATNAME VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; create unique index KAT_4280KAT on KAT_4280KAT(SUBKATKEY); create table ZU_4280KAT ( KATKEY NUMBER(10,0), SUBKATKEY NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_4280KAT on ZU_4280KAT(KATKEY, SUBKATKEY); create table KAT_4290 ( KATKEY NUMBER(10,0), NR VARCHAR2(20), BEZ VARCHAR2(100), STATE NUMBER(10,0), BEMERK VARCHAR2(200) ) TABLESPACE QDAS_DEFAULT; create unique index KAT_4290 on KAT_4290(KATKEY); create table KAT_4290KAT ( SUBKATKEY NUMBER(10,0), SUBKATNAME VARCHAR2(100) ) TABLESPACE QDAS_DEFAULT; create unique index KAT_4290KAT on KAT_4290KAT(SUBKATKEY); create table ZU_4290KAT ( KATKEY NUMBER(10,0), SUBKATKEY NUMBER(10,0) ) TABLESPACE QDAS_DEFAULT; create unique index ZU_4290KAT on ZU_4290KAT(KATKEY, SUBKATKEY); -- Stored Procedures zum Abspeichern in WERTEVAR CREATE OR REPLACE PROCEDURE WVINSERT( PARA1 IN NUMBER, PARA2 IN NUMBER, PARA3 IN NUMBER, PARA4 IN NUMBER, PARA5 IN FLOAT, PARA6 IN NUMBER, PARA7 IN NUMBER, PARA8 IN NUMBER, PARA9 IN NUMBER, PARA10 IN NUMBER, PARA11 IN DATE, PARA12 IN NUMBER, PARA13 IN VARCHAR, PARA14 IN VARCHAR ) AS BEGIN INSERT INTO WERTEVAR ( WVTEIL, WVMERKMAL, WVUNTERS, WVWERTNR, WVWERT, WVATTRIBUT,WVPRUEFER,WVPRUEFMIT,WVMASCHINE,WVNEST,WVDATZEIT, WVSTIANF,WVCHARGE,WVAUFTRAG ) VALUES (PARA1, PARA2, PARA3, PARA4, PARA5, PARA6, PARA7, PARA8, PARA9, PARA10, PARA11, PARA12, PARA13, PARA14); END; / CREATE OR REPLACE PROCEDURE WVINSERT05( PARA1 IN NUMBER, PARA2 IN NUMBER, PARA3 IN NUMBER, PARA4 IN NUMBER, PARA5 IN FLOAT, PARA6 IN NUMBER, PARA7 IN NUMBER, PARA8 IN NUMBER, PARA9 IN NUMBER, PARA10 IN NUMBER, PARA11 IN DATE, PARA12 IN NUMBER, PARA13 IN VARCHAR, PARA14 IN VARCHAR, PARA_WV0005 IN VARCHAR ) AS BEGIN INSERT INTO WERTEVAR ( WVTEIL, WVMERKMAL, WVUNTERS, WVWERTNR, WVWERT, WVATTRIBUT,WVPRUEFER,WVPRUEFMIT,WVMASCHINE,WVNEST,WVDATZEIT, WVSTIANF,WVCHARGE,WVAUFTRAG,WV0005 ) VALUES (PARA1, PARA2, PARA3, PARA4, PARA5, PARA6, PARA7, PARA8, PARA9, PARA10, PARA11, PARA12, PARA13, PARA14, PARA_WV0005); END; / CREATE SEQUENCE LAST_UPLOAD_KEYS MINVALUE 1 MAXVALUE 2000000000 CYCLE NOCACHE ORDER; CREATE TABLE MANUAL_QCC_PRINT ( BORDEREAU_ID NUMBER(10,0) NOT NULL ENABLE, DG_BORDEREAU_ID NUMBER(10,0), STATUS NUMBER(2,0) NOT NULL ENABLE, WORKSTATION_ID VARCHAR2(100 BYTE), PRINTER_ID VARCHAR2(100 BYTE), BORDEREAU_TYPE NUMBER(2,0), YEAR_NO NUMBER(4,0), WEEK_NO NUMBER(2,0), DAY_NO NUMBER(1,0), CLASSIFICATION VARCHAR2(50 BYTE), EVENT_01_ID NUMBER(10,0), EVENT_02_ID NUMBER(10,0), EVENT_03_ID NUMBER(10,0), EVENT_04_ID NUMBER(10,0), EVENT_05_ID NUMBER(10,0), EVENT_06_ID NUMBER(10,0), EVENT_07_ID NUMBER(10,0), EVENT_08_ID NUMBER(10,0), EVENT_09_ID NUMBER(10,0), EVENT_10_ID NUMBER(10,0), DIV_01_ID VARCHAR2(50 BYTE), DIV_01_REVISION VARCHAR2(20 BYTE), DIV_02_ID VARCHAR2(50 BYTE), DIV_02_REVISION VARCHAR2(20 BYTE), DIV_03_ID VARCHAR2(50 BYTE), DIV_03_REVISION VARCHAR2(20 BYTE), DIV_04_ID VARCHAR2(50 BYTE), DIV_04_REVISION VARCHAR2(20 BYTE), DIV_05_ID VARCHAR2(50 BYTE), DIV_05_REVISION VARCHAR2(20 BYTE), CONTROL_PLAN_ID VARCHAR2(50 BYTE), ATELIER_NO VARCHAR2(50 BYTE), LINE_NO VARCHAR2(50 BYTE), LINE_DESC VARCHAR2(50 BYTE), OPERATION_NO VARCHAR2(50 BYTE), OPERATION_DESC VARCHAR2(50 BYTE), MACHINE_NO VARCHAR2(50 BYTE), MACHINE_DESC VARCHAR2(50 BYTE), CHAR_NO VARCHAR2(20 BYTE), CHAR_DESC VARCHAR2(80 BYTE), GAGE_ID VARCHAR2(50 BYTE), GAGE_DESC VARCHAR2(50 BYTE), SAMPLE_FREQ VARCHAR2(80 BYTE), SAMPLE_SIZE NUMBER(5,0), LSL FLOAT(126), USL FLOAT(126), NOMINAL FLOAT(126), LLIMITTYPE NUMBER(2,0), ULIMITTYPE NUMBER(2,0), LCL FLOAT(126), UCL FLOAT(126), UNIT VARCHAR2(20 BYTE), PRECISION_SIZE NUMBER(2,0), PAGENO NUMBER(2,0), MAXPAGE NUMBER(2,0), LOI NUMBER(2,0), DISTRIBUTIONNO VARCHAR2(20 BYTE), EVENT_01_TEXT VARCHAR2(40 BYTE), EVENT_02_TEXT VARCHAR2(40 BYTE), EVENT_03_TEXT VARCHAR2(40 BYTE), EVENT_04_TEXT VARCHAR2(40 BYTE), EVENT_05_TEXT VARCHAR2(40 BYTE), EVENT_06_TEXT VARCHAR2(40 BYTE), EVENT_07_TEXT VARCHAR2(40 BYTE), EVENT_08_TEXT VARCHAR2(40 BYTE), EVENT_09_TEXT VARCHAR2(40 BYTE), EVENT_10_TEXT VARCHAR2(40 BYTE), CHAR_REMARK VARCHAR2(255 BYTE), CONSTRAINT PKMANUAL_QCC_PRINT PRIMARY KEY (BORDEREAU_ID) ENABLE ) ; CREATE TABLE MANUAL_QCC_PRINT_HISTORY ( BORDEREAU_ID NUMBER(10,0) NOT NULL ENABLE, STATUS_HISTORY NUMBER(2,0) NOT NULL ENABLE, STATUS_TIME DATE NOT NULL ENABLE, CONSTRAINT FK_MANUAL_QCC_PRINT_HISTORY FOREIGN KEY (BORDEREAU_ID) REFERENCES MANUAL_QCC_PRINT (BORDEREAU_ID) ON DELETE CASCADE ENABLE ) ; create table PLANT_JOBS ( TREE_TYPE NUMBER(3,0), NODE_ID RAW(16), JOB_NO NUMBER(10,0), JOB_NAME VARCHAR2(80), JOB_KIND NUMBER(3,0), JOB_ACTIVE NUMBER(3,0), PLAN_KIND NUMBER(3,0), PLAN_TIME FLOAT, NODE_LEVEL NUMBER(3,0), NODE_SUBLEVEL NUMBER(3,0), JOB_REPORT VARCHAR2(255), VALUE_FILTER NUMBER(10,0), OFFSET NUMBER(5,0), NODE_SUBSUBLEVEL NUMBER(3,0), LT_DIVISION VARCHAR2(100), PDF_OUTPUT_DIR VARCHAR2(255), LANGUAGE NUMBER(10,0), MODULE NUMBER(10,0), STRATEGY NUMBER(10,0), PART_FILTER NUMBER(10,0), CHAR_FILTER NUMBER(10,0), REPORT_LEVEL NUMBER(3,0), MAXNODESPERPAGE NUMBER(3,0), DIVIDE_GRAPHICS NUMBER(3,0), GRAPH_ROWS NUMBER(3,0) ) TABLESPACE QDAS_DEFAULT; create unique index PLANT_JOBS on PLANT_JOBS(TREE_TYPE, NODE_ID, JOB_NO); create index JOB_ACTIVE on PLANT_JOBS(JOB_ACTIVE); create index JOB_KIND on PLANT_JOBS(JOB_KIND); create table JOB_FILTERS ( FILTER_ID NUMBER(10,0), FILTER_LEVEL NUMBER(3,0), FILTER_NAME VARCHAR2(50), FILTER LONG ) TABLESPACE QDAS_DEFAULT; create unique index JOB_FILTERS on JOB_FILTERS(FILTER_ID); create index FILTER_LEVEL on JOB_FILTERS(FILTER_LEVEL); create index FILTER_NAME on JOB_FILTERS(FILTER_NAME); create table NODELOCK ( NLNODEGUID RAW(16), NLNODETYPE NUMBER(10,0), NLNODESUBTYPE NUMBER(10,0), NLUSERNAME VARCHAR2(90) ) TABLESPACE QDAS_DEFAULT; create unique index NODELOCK on NODELOCK(NLNODEGUID); create table NODERIGHTS ( NRNODEGUID RAW(16), NRUSERKEY NUMBER(10,0), NRCREATECHILD VARCHAR2(1), NREDITNODE VARCHAR2(1), NRDELETENODE VARCHAR2(1), NRGRANTRIGHTS VARCHAR2(1) ) TABLESPACE QDAS_DEFAULT; create unique index NODERIGHTS on NODERIGHTS(NRNODEGUID, NRUSERKEY); create table PLANT_REPORT_MAIL_LIST ( NODE_ID RAW(16), JOB_NO NUMBER(10,0), RECIPIENT_KEY NUMBER(10,0), ATTACH_REPORTS NUMBER(3,0) ) TABLESPACE QDAS_DEFAULT; create unique index PLANT_REPORT_MAIL_LIST on PLANT_REPORT_MAIL_LIST(NODE_ID, JOB_NO, RECIPIENT_KEY); create index MEMASTERGUID on MERKMAL(MEMASTERGUID) TABLESPACE qmerk_index; create table PART_CHAR_MACHINE ( PARTNO_1001 VARCHAR2(30), CHARNO_2001 VARCHAR2(30), MACHINEKEY NUMBER(10,0), CHAR_MASTERGUID RAW(16) ) TABLESPACE QDAS_DEFAULT; create unique index PART_CHAR_MACHINE on PART_CHAR_MACHINE(PARTNO_1001, CHARNO_2001, MACHINEKEY); create table UNCONFORMITY_REPORTS ( UR_ID NUMBER(10,0), UR_USERID NUMBER(10,0), UR_USERNAME varchar2(50), UR_CREATIONDATE DATE, UR_TEIL NUMBER(10,0), UR_MERKMAL NUMBER(10,0), UR_WERTNR NUMBER(10,0), UR_STATUS NUMBER(3,0), UR_IMAGE LONG RAW, UR_MODIFDATE DATE, UR_CLOSE_USERID NUMBER(10,0), UR_CLOSE_USERNAME varchar2(50), UR_CLOSE_COMMENT varchar2(255), UR_TYPE NUMBER(3,0), UR_SUPPLIER varchar2(50), UR_PRIO_ACTION NUMBER(10,0), UR_ALLOC_USERS varchar2(25), UR_PH_RECT varchar2(30), UR_USER_TEXT varchar2(80), UR_GROUPING_ID RAW(16), UR_LAYOUT NUMBER(3,0) ) TABLESPACE QDAS_DEFAULT; create unique index UNCONFORMITY_REPORTS on UNCONFORMITY_REPORTS(UR_ID); create index UR_CLOSE_USERID on UNCONFORMITY_REPORTS(UR_CLOSE_USERID); create index UR_USERID on UNCONFORMITY_REPORTS(UR_USERID); create table UNCONFORMITY_REPORTS2 ( UR_ID NUMBER(10,0), UR_2ND_IMAGE LONG RAW, UR_2ND_IMAGETYPE varchar2(10) ) TABLESPACE QDAS_DEFAULT; create unique index UNCONFORMITY_REPORTS2 on UNCONFORMITY_REPORTS2(UR_ID); create table UNCONF_DIAGN ( UR_ID NUMBER(10,0), UD_ID NUMBER(10,0), UD_ANALYSIS varchar2(255), UD_CAUSE varchar2(255) ) TABLESPACE QDAS_DEFAULT; create unique index UNCONF_DIAGN on UNCONF_DIAGN(UR_ID, UD_ID); create table UNCONF_ACTION ( UR_ID NUMBER(10,0), UA_ID NUMBER(10,0), UA_NOTE varchar2(100), UA_ACTION varchar2(255), UA_RESPONS varchar2(50), UA_DATE varchar2(20), UA_EFFECT varchar2(100) ) TABLESPACE QDAS_DEFAULT; create unique index UNCONF_ACTION on UNCONF_ACTION(UR_ID, UA_ID); CREATE TABLE NODERESULTS ( NRNODEID RAW(16), NRMODULE NUMBER(10,0), NRFIRSTDATE DATE, NRLASTDATE DATE, NROPERATOR NUMBER(10,0), NRGAGE NUMBER(10,0), NRMACHINE NUMBER(10,0), NRNEST NUMBER(10,0), NRBATCHNO VARCHAR2(30), NRORDERNO VARCHAR2(30), NRSEPFIELDS VARCHAR2(50), NRSTRATEGY NUMBER(10,0), NRPS15210_00000033 FLOAT, NRPS15210_00330067 FLOAT, NRPS15210_00670100 FLOAT, NRPS15210_01000133 FLOAT, NRPS15210_01330167 FLOAT, NRPS15210_01670200 FLOAT, NRPS15210_02000233 FLOAT, NRPS15210_02330267 FLOAT, NRPS15210_02679999 FLOAT, NRPS15220_M9990000 FLOAT, NRPS15220_00000033 FLOAT, NRPS15220_00330067 FLOAT, NRPS15220_00670100 FLOAT, NRPS15220_01000133 FLOAT, NRPS15220_01330167 FLOAT, NRPS15220_01670200 FLOAT, NRPS15220_02000233 FLOAT, NRPS15220_02330267 FLOAT, NRPS15220_02679999 FLOAT, NR_OEE FLOAT, NR_OEE_V FLOAT, NR_OEE_P FLOAT, NR_OEE_N FLOAT, NR_OEE_F FLOAT, NRPS15000_00000001 FLOAT, NRPS15000_00000016 FLOAT, NRPS15000_00000032 FLOAT, NRPS15000_00004096 FLOAT ) TABLESPACE QDAS_DEFAULT; CREATE TABLE NODEREPORTFILES ( NRF_NODEID RAW(16), NRF_MODULE NUMBER(10,0), NRF_FIRSTDATE DATE, NRF_LASTDATE DATE, NRF_OPERATOR NUMBER(10,0), NRF_GAGE NUMBER(10,0), NRF_MACHINE NUMBER(10,0), NRF_NEST NUMBER(10,0), NRF_BATCHNO VARCHAR2(30), NRF_ORDERNO VARCHAR2(30), NRF_SEPFIELDS VARCHAR2(50), NRF_STRATEGY NUMBER(10,0), NRF_REPORT_NUM NUMBER(10,0), NRF_ENTRY_TYPE NUMBER(10,0), NRF_ENTRY LONG RAW, NRF_REPORTNAME VARCHAR2(255) ) TABLESPACE QDAS_DEFAULT; CREATE TABLE CAQ_EREIGNIS ( CE_ID NUMBER(10,0), CE_TEIL NUMBER(10,0), CE_MERKMAL NUMBER(10,0), CE_EREIGNISID VARCHAR2(255) ) TABLESPACE QDAS_DEFAULT; CREATE TABLE CAQ_URSACHE ( CU_ID NUMBER(10,0), CU_EREIGNISID VARCHAR2(255), CU_URSACHEID VARCHAR2(255) ) TABLESPACE QDAS_DEFAULT; CREATE TABLE CAQ_MASSNAHME ( CM_ID NUMBER(10,0), CM_URSACHENID VARCHAR2(255), CM_MASSNAHMEID VARCHAR2(255) ) TABLESPACE QDAS_DEFAULT; CREATE TABLE IQS_QDAS_MAPPING ( IQS_CLASS VARCHAR2(30), IQS_FIELD VARCHAR2(40), IQS_SUBFIELD VARCHAR2(20), QDAS_TABLE VARCHAR2(30), QDAS_FIELD VARCHAR2(20), QDAS_FIELD_SUBKEY VARCHAR2(20), QDAS_PARTKEY VARCHAR2(20), QDAS_CHARKEY VARCHAR2(20), QDAS_TAKEOVER VARCHAR2(20), QDAS_TRIGGER VARCHAR2(20), QDAS_PPLANKEY VARCHAR2(20), QDAS_PAUFTRAGKEY VARCHAR2(20), QDAS_UNTERSKEY VARCHAR2(20) ) TABLESPACE QDAS_DEFAULT; CREATE TABLE IQS_QDAS_CONTENT_MAPPING ( IQS_CLASS VARCHAR2(30), IQS_FIELD VARCHAR2(40), IQS_FIELD_SUBKEY VARCHAR2(3), QDAS_FIELD VARCHAR2(20), QDAS_FIELD_SUBKEY VARCHAR2(20), IQS_CONTENT VARCHAR2(20), QDAS_CONTENT VARCHAR2(20) ) TABLESPACE QDAS_DEFAULT; CREATE TABLE IQS_FIELD_TO_FIELD_MAPPING ( IQS_CLASS_SOURCE VARCHAR2(30), IQS_FIELD_SOURCE VARCHAR2(40), IQS_CLASS_DEST VARCHAR2(30), IQS_FIELD_DEST VARCHAR2(40) ) TABLESPACE QDAS_DEFAULT; CREATE TABLE ALARMHIST ( TNR NUMBER(10,0), MMNR NUMBER(10,0), MWNR NUMBER(10,0), IDENT VARCHAR2(255) ) TABLESPACE QDAS_DEFAULT; create unique index ALARMHIST on ALARMHIST(TNR, MMNR, IDENT); CREATE TABLE DATA_IMAGES ( IM_ID RAW(16), IM_PARENT RAW(16), IM_PATH VARCHAR2(80), IM_TYPE NUMBER(3,0), IM_TREEDEPTH NUMBER(3,0), IM_IMAGE LONG RAW ) TABLESPACE QDAS_DEFAULT; CREATE UNIQUE INDEX DATA_IMAGES ON DATA_IMAGES(IM_ID); create table EG_AEND_ZD ( EGTEIL NUMBER(10,0) , EGMERKMAL NUMBER(5,0) , EGUNTERS NUMBER(5,0) , EGWERTNR NUMBER(10,0) , EG_FIELDS VARCHAR2(20), EG_K0006 VARCHAR2(50), EG_K0007 NUMBER(10,0), EG_K0008 NUMBER(10,0), EG_K0010 NUMBER(10,0), EG_K0012 NUMBER(10,0), EG_K0014 VARCHAR2(50), EG_K0016 VARCHAR2(50), EG_K0017 VARCHAR2(50), EG_K0053 VARCHAR2(50), EG_K0054 VARCHAR2(50), EG_K0055 VARCHAR2(50), EG_K0056 VARCHAR2(50), EG_K0057 VARCHAR2(50), EG_K0058 VARCHAR2(50), EG_K0059 VARCHAR2(50), EG_K0060 VARCHAR2(50), EG_K0061 NUMBER(10,0), EG_K0062 NUMBER(10,0), EG_K0063 NUMBER(10,0), EGCP FLOAT , EGCPK FLOAT , EGLAGART NUMBER(3,0) , EGLAGSTREU NUMBER(3,0) , EGLAGGRART NUMBER(3,0) , EGPEARSON NUMBER(3,0) , EGMINMAX FLOAT , EGMITTELW NUMBER(3,0) , EGCWERTGUE NUMBER(5,0) , EGCAUSGZUL NUMBER(3,0) , EGCUN FLOAT , EGCUN_UN FLOAT , EGCUN_OB FLOAT , EGCOB FLOAT , EGCOB_UN FLOAT , EGCOB_OB FLOAT , EGC FLOAT , EGC_UN FLOAT , EGC_OB FLOAT , EGCUNATR NUMBER(3,0) , EGCUNVBATR NUMBER(3,0) , EGCOBATR NUMBER(3,0) , EGCOBVBATR NUMBER(3,0) , EGCATR NUMBER(3,0) , EGCVBATR NUMBER(3,0) , EGCKATR NUMBER(3,0) , EGLAGEMIN FLOAT , EGLAGEMAX FLOAT , EGLAGUEG FLOAT , EGLAGMITTE FLOAT , EGLAGOEG FLOAT , EGLAGUWG FLOAT , EGLAGOWG FLOAT , EGLAGUUNT FLOAT , EGLAGUOB FLOAT , EGP_F FLOAT , EGEW_F FLOAT , EGGS_F FLOAT , EGSAQRKGSF FLOAT , EGSTRART NUMBER(3,0) , EGSTRSTREU NUMBER(3,0) , EGSTRBER NUMBER(3,0) , EGSTRUEG FLOAT , EGSTRMITTE FLOAT , EGSTROEG FLOAT , EGSTRUWG FLOAT , EGSTROWG FLOAT , EGSTRPQFSK FLOAT , EGSTRNQFSK FLOAT , EGDAT DATE , EGMASCHINE NUMBER(10,0) , EGNEST NUMBER(10,0) , EGUGW FLOAT , EGOGW FLOAT , EGNENNMASS FLOAT , EGLAGUIG FLOAT , EGLAGOIG FLOAT , EGSTRUIG FLOAT , EGSTROIG FLOAT, EG_LEXL FLOAT, EG_UEXL FLOAT, EG_EXSTART DATE, EG_EXEND DATE, EG_EXVALID NUMBER(3,0) ) TABLESPACE QDAS_DEFAULT; create index EGZ_TM on EG_AEND_ZD (EGTEIL, EGMERKMAL); commit;