Mercurial > lada > lada-server

comparison db_schema/lada_schema.sql @ 799:2059ac26fd49

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Whitespace-cleanup in schema definitions.
author Tom Gottfried <tom@intevation.de>
date Thu, 19 Nov 2015 12:13:10 +0100
parents 84cc23ab49f7
children 2b0d99fbeecc
comparison
equal deleted inserted replaced
798:84cc23ab49f7 799:2059ac26fd49
202 where s00.ebene = 0 and s00.sn = d00::smallint; 202 where s00.ebene = 0 and s00.sn = d00::smallint;
203 else 203 else
204 if d02 = '00' or d00 <> '01' then 204 if d02 = '00' or d00 <> '01' then
205 select s01.beschreibung into result FROM stammdaten.deskriptoren s01 205 select s01.beschreibung into result FROM stammdaten.deskriptoren s01
206 where s01.ebene = 1 and s01.sn = d01::smallint 206 where s01.ebene = 1 and s01.sn = d01::smallint
207 and s01.vorgaenger = 207 and s01.vorgaenger =
208 (select s00.id FROM stammdaten.deskriptoren s00 208 (select s00.id FROM stammdaten.deskriptoren s00
209 where s00.ebene = 0 and s00.sn = d00::smallint); 209 where s00.ebene = 0 and s00.sn = d00::smallint);
210 else 210 else
211 if d03 = '00' then 211 if d03 = '00' then
212 select s02.beschreibung into result FROM stammdaten.deskriptoren s02 212 select s02.beschreibung into result FROM stammdaten.deskriptoren s02
213 where s02.ebene = 2 and s02.sn = d02::smallint 213 where s02.ebene = 2 and s02.sn = d02::smallint
214 and s02.vorgaenger = 214 and s02.vorgaenger =
215 (select s01.id FROM stammdaten.deskriptoren s01 215 (select s01.id FROM stammdaten.deskriptoren s01
216 where s01.ebene = 1 and s01.sn = d01::smallint 216 where s01.ebene = 1 and s01.sn = d01::smallint
217 and s01.vorgaenger = 217 and s01.vorgaenger =
218 (select s00.id FROM stammdaten.deskriptoren s00 218 (select s00.id FROM stammdaten.deskriptoren s00
219 where s00.ebene = 0 and s00.sn = d00::smallint)); 219 where s00.ebene = 0 and s00.sn = d00::smallint));
220 else 220 else
221 select s03.beschreibung into result FROM stammdaten.deskriptoren s03 221 select s03.beschreibung into result FROM stammdaten.deskriptoren s03
222 where s03.ebene = 3 and s03.sn = d03::smallint 222 where s03.ebene = 3 and s03.sn = d03::smallint
223 and s03.vorgaenger = 223 and s03.vorgaenger =
224 (select s02.id FROM stammdaten.deskriptoren s02 224 (select s02.id FROM stammdaten.deskriptoren s02
225 where s02.ebene = 2 and s02.sn = d02::smallint 225 where s02.ebene = 2 and s02.sn = d02::smallint
226 and s02.vorgaenger = 226 and s02.vorgaenger =
227 (select s01.id FROM stammdaten.deskriptoren s01 227 (select s01.id FROM stammdaten.deskriptoren s01
228 where s01.ebene = 1 and s01.sn = d01::smallint 228 where s01.ebene = 1 and s01.sn = d01::smallint
229 and s01.vorgaenger = 229 and s01.vorgaenger =
230 (select s00.id FROM stammdaten.deskriptoren s00 230 (select s00.id FROM stammdaten.deskriptoren s00
231 where s00.ebene = 0 and s00.sn = d00::smallint))); 231 where s00.ebene = 0 and s00.sn = d00::smallint)));
232 end if; 232 end if;
233 end if; 233 end if;
234 end if; 234 end if;
258 SET default_tablespace = ''; 258 SET default_tablespace = '';
259 259
260 SET default_with_oids = false; 260 SET default_with_oids = false;
261 261
262 -- 262 --
263 -- Name: kommentar; Type: TABLE; Schema: bund; Owner: -; Tablespace: 263 -- Name: kommentar; Type: TABLE; Schema: bund; Owner: -; Tablespace:
264 -- 264 --
265 265
266 CREATE TABLE kommentar ( 266 CREATE TABLE kommentar (
267 id integer DEFAULT nextval('kommentar_id_seq'::regclass) NOT NULL, 267 id integer DEFAULT nextval('kommentar_id_seq'::regclass) NOT NULL,
268 erzeuger character varying(5) NOT NULL, 268 erzeuger character varying(5) NOT NULL,
270 text character varying(1024) 270 text character varying(1024)
271 ); 271 );
272 272
273 273
274 -- 274 --
275 -- Name: kommentar_m; Type: TABLE; Schema: bund; Owner: -; Tablespace: 275 -- Name: kommentar_m; Type: TABLE; Schema: bund; Owner: -; Tablespace:
276 -- 276 --
277 277
278 CREATE TABLE kommentar_m ( 278 CREATE TABLE kommentar_m (
279 messungs_id integer NOT NULL 279 messungs_id integer NOT NULL
280 ) 280 )
281 INHERITS (kommentar); 281 INHERITS (kommentar);
282 282
283 283
284 -- 284 --
285 -- Name: kommentar_p; Type: TABLE; Schema: bund; Owner: -; Tablespace: 285 -- Name: kommentar_p; Type: TABLE; Schema: bund; Owner: -; Tablespace:
286 -- 286 --
287 287
288 CREATE TABLE kommentar_p ( 288 CREATE TABLE kommentar_p (
289 probe_id integer NOT NULL 289 probe_id integer NOT NULL
290 ) 290 )
291 INHERITS (kommentar); 291 INHERITS (kommentar);
292 292
293 293
294 -- 294 --
295 -- Name: list; Type: TABLE; Schema: bund; Owner: -; Tablespace: 295 -- Name: list; Type: TABLE; Schema: bund; Owner: -; Tablespace:
296 -- 296 --
297 297
298 CREATE TABLE list ( 298 CREATE TABLE list (
299 id integer NOT NULL, 299 id integer NOT NULL,
300 typ character(1) NOT NULL, 300 typ character(1) NOT NULL,
323 323
324 ALTER SEQUENCE list_id_seq OWNED BY list.id; 324 ALTER SEQUENCE list_id_seq OWNED BY list.id;
325 325
326 326
327 -- 327 --
328 -- Name: list_zuordnung; Type: TABLE; Schema: bund; Owner: -; Tablespace: 328 -- Name: list_zuordnung; Type: TABLE; Schema: bund; Owner: -; Tablespace:
329 -- 329 --
330 330
331 CREATE TABLE list_zuordnung ( 331 CREATE TABLE list_zuordnung (
332 list_id integer NOT NULL, 332 list_id integer NOT NULL,
333 probe_id integer 333 probe_id integer
345 NO MAXVALUE 345 NO MAXVALUE
346 CACHE 1; 346 CACHE 1;
347 347
348 348
349 -- 349 --
350 -- Name: messung; Type: TABLE; Schema: bund; Owner: -; Tablespace: 350 -- Name: messung; Type: TABLE; Schema: bund; Owner: -; Tablespace:
351 -- 351 --
352 352
353 CREATE TABLE messung ( 353 CREATE TABLE messung (
354 id integer DEFAULT nextval('messung_id_seq'::regclass) NOT NULL, 354 id integer DEFAULT nextval('messung_id_seq'::regclass) NOT NULL,
355 probe_id integer NOT NULL, 355 probe_id integer NOT NULL,
398 NO MAXVALUE 398 NO MAXVALUE
399 CACHE 1; 399 CACHE 1;
400 400
401 401
402 -- 402 --
403 -- Name: messwert; Type: TABLE; Schema: bund; Owner: -; Tablespace: 403 -- Name: messwert; Type: TABLE; Schema: bund; Owner: -; Tablespace:
404 -- 404 --
405 405
406 CREATE TABLE messwert ( 406 CREATE TABLE messwert (
407 id integer DEFAULT nextval('messwert_id_seq'::regclass) NOT NULL, 407 id integer DEFAULT nextval('messwert_id_seq'::regclass) NOT NULL,
408 messungs_id integer NOT NULL, 408 messungs_id integer NOT NULL,
428 NO MAXVALUE 428 NO MAXVALUE
429 CACHE 1; 429 CACHE 1;
430 430
431 431
432 -- 432 --
433 -- Name: ort; Type: TABLE; Schema: bund; Owner: -; Tablespace: 433 -- Name: ort; Type: TABLE; Schema: bund; Owner: -; Tablespace:
434 -- 434 --
435 435
436 CREATE TABLE ort ( 436 CREATE TABLE ort (
437 id integer DEFAULT nextval('ort_id_seq'::regclass) NOT NULL, 437 id integer DEFAULT nextval('ort_id_seq'::regclass) NOT NULL,
438 probe_id integer NOT NULL, 438 probe_id integer NOT NULL,
461 NO MAXVALUE 461 NO MAXVALUE
462 CACHE 1; 462 CACHE 1;
463 463
464 464
465 -- 465 --
466 -- Name: probe; Type: TABLE; Schema: bund; Owner: -; Tablespace: 466 -- Name: probe; Type: TABLE; Schema: bund; Owner: -; Tablespace:
467 -- 467 --
468 468
469 CREATE TABLE probe ( 469 CREATE TABLE probe (
470 id integer DEFAULT nextval('probe_id_seq'::regclass) NOT NULL, 470 id integer DEFAULT nextval('probe_id_seq'::regclass) NOT NULL,
471 test boolean DEFAULT false NOT NULL, 471 test boolean DEFAULT false NOT NULL,
567 NO MAXVALUE 567 NO MAXVALUE
568 CACHE 1; 568 CACHE 1;
569 569
570 570
571 -- 571 --
572 -- Name: status_protokoll; Type: TABLE; Schema: bund; Owner: -; Tablespace: 572 -- Name: status_protokoll; Type: TABLE; Schema: bund; Owner: -; Tablespace:
573 -- 573 --
574 574
575 CREATE TABLE status_protokoll ( 575 CREATE TABLE status_protokoll (
576 status_stufe integer NOT NULL, 576 status_stufe integer NOT NULL,
577 status_wert integer NOT NULL, 577 status_wert integer NOT NULL,
591 NO MAXVALUE 591 NO MAXVALUE
592 CACHE 1; 592 CACHE 1;
593 593
594 594
595 -- 595 --
596 -- Name: zusatz_wert; Type: TABLE; Schema: bund; Owner: -; Tablespace: 596 -- Name: zusatz_wert; Type: TABLE; Schema: bund; Owner: -; Tablespace:
597 -- 597 --
598 598
599 CREATE TABLE zusatz_wert ( 599 CREATE TABLE zusatz_wert (
600 id integer DEFAULT nextval('zusatz_wert_id_seq'::regclass) NOT NULL, 600 id integer DEFAULT nextval('zusatz_wert_id_seq'::regclass) NOT NULL,
601 probe_id integer NOT NULL, 601 probe_id integer NOT NULL,
608 608
609 609
610 SET search_path = land, pg_catalog; 610 SET search_path = land, pg_catalog;
611 611
612 -- 612 --
613 -- Name: kommentar_m; Type: TABLE; Schema: land; Owner: -; Tablespace: 613 -- Name: kommentar_m; Type: TABLE; Schema: land; Owner: -; Tablespace:
614 -- 614 --
615 615
616 CREATE TABLE kommentar_m ( 616 CREATE TABLE kommentar_m (
617 ) 617 )
618 INHERITS (bund.kommentar_m); 618 INHERITS (bund.kommentar_m);
619 619
620 620
621 -- 621 --
622 -- Name: kommentar_p; Type: TABLE; Schema: land; Owner: -; Tablespace: 622 -- Name: kommentar_p; Type: TABLE; Schema: land; Owner: -; Tablespace:
623 -- 623 --
624 624
625 CREATE TABLE kommentar_p ( 625 CREATE TABLE kommentar_p (
626 ) 626 )
627 INHERITS (bund.kommentar_p); 627 INHERITS (bund.kommentar_p);
628 628
629 629
630 -- 630 --
631 -- Name: messprogramm; Type: TABLE; Schema: land; Owner: -; Tablespace: 631 -- Name: messprogramm; Type: TABLE; Schema: land; Owner: -; Tablespace:
632 -- 632 --
633 633
634 CREATE TABLE messprogramm ( 634 CREATE TABLE messprogramm (
635 id integer NOT NULL, 635 id integer NOT NULL,
636 name character varying(256), 636 name character varying(256),
681 681
682 ALTER SEQUENCE messprogramm_id_seq OWNED BY messprogramm.id; 682 ALTER SEQUENCE messprogramm_id_seq OWNED BY messprogramm.id;
683 683
684 684
685 -- 685 --
686 -- Name: messprogramm_mmt; Type: TABLE; Schema: land; Owner: -; Tablespace: 686 -- Name: messprogramm_mmt; Type: TABLE; Schema: land; Owner: -; Tablespace:
687 -- 687 --
688 688
689 CREATE TABLE messprogramm_mmt ( 689 CREATE TABLE messprogramm_mmt (
690 id integer NOT NULL, 690 id integer NOT NULL,
691 messprogramm_id integer NOT NULL, 691 messprogramm_id integer NOT NULL,
713 713
714 ALTER SEQUENCE messprogramm_mmt_id_seq OWNED BY messprogramm_mmt.id; 714 ALTER SEQUENCE messprogramm_mmt_id_seq OWNED BY messprogramm_mmt.id;
715 715
716 716
717 -- 717 --
718 -- Name: messung; Type: TABLE; Schema: land; Owner: -; Tablespace: 718 -- Name: messung; Type: TABLE; Schema: land; Owner: -; Tablespace:
719 -- 719 --
720 720
721 CREATE TABLE messung ( 721 CREATE TABLE messung (
722 geplant boolean DEFAULT false NOT NULL, 722 geplant boolean DEFAULT false NOT NULL,
723 tree_modified timestamp without time zone DEFAULT now() 723 tree_modified timestamp without time zone DEFAULT now()
724 ) 724 )
725 INHERITS (bund.messung); 725 INHERITS (bund.messung);
726 726
727 727
728 -- 728 --
729 -- Name: messung_translation; Type: TABLE; Schema: land; Owner: -; Tablespace: 729 -- Name: messung_translation; Type: TABLE; Schema: land; Owner: -; Tablespace:
730 -- 730 --
731 731
732 CREATE TABLE messung_translation ( 732 CREATE TABLE messung_translation (
733 id integer NOT NULL, 733 id integer NOT NULL,
734 messungs_id integer NOT NULL, 734 messungs_id integer NOT NULL,
754 754
755 ALTER SEQUENCE messung_translation_id_seq OWNED BY messung_translation.id; 755 ALTER SEQUENCE messung_translation_id_seq OWNED BY messung_translation.id;
756 756
757 757
758 -- 758 --
759 -- Name: messwert; Type: TABLE; Schema: land; Owner: -; Tablespace: 759 -- Name: messwert; Type: TABLE; Schema: land; Owner: -; Tablespace:
760 -- 760 --
761 761
762 CREATE TABLE messwert ( 762 CREATE TABLE messwert (
763 tree_modified timestamp without time zone DEFAULT now() 763 tree_modified timestamp without time zone DEFAULT now()
764 ) 764 )
765 INHERITS (bund.messwert); 765 INHERITS (bund.messwert);
766 766
767 767
768 -- 768 --
769 -- Name: ort; Type: TABLE; Schema: land; Owner: -; Tablespace: 769 -- Name: ort; Type: TABLE; Schema: land; Owner: -; Tablespace:
770 -- 770 --
771 771
772 CREATE TABLE ort ( 772 CREATE TABLE ort (
773 tree_modified timestamp without time zone DEFAULT now() 773 tree_modified timestamp without time zone DEFAULT now()
774 ) 774 )
775 INHERITS (bund.ort); 775 INHERITS (bund.ort);
776 776
777 777
778 -- 778 --
779 -- Name: probe; Type: TABLE; Schema: land; Owner: -; Tablespace: 779 -- Name: probe; Type: TABLE; Schema: land; Owner: -; Tablespace:
780 -- 780 --
781 781
782 CREATE TABLE probe ( 782 CREATE TABLE probe (
783 erzeuger_id integer, 783 erzeuger_id integer,
784 probe_nehmer_id integer, 784 probe_nehmer_id integer,
791 ) 791 )
792 INHERITS (bund.probe); 792 INHERITS (bund.probe);
793 793
794 794
795 -- 795 --
796 -- Name: probe_translation; Type: TABLE; Schema: land; Owner: -; Tablespace: 796 -- Name: probe_translation; Type: TABLE; Schema: land; Owner: -; Tablespace:
797 -- 797 --
798 798
799 CREATE TABLE probe_translation ( 799 CREATE TABLE probe_translation (
800 id integer NOT NULL, 800 id integer NOT NULL,
801 probe_id integer NOT NULL, 801 probe_id integer NOT NULL,
821 821
822 ALTER SEQUENCE probe_translation_id_seq OWNED BY probe_translation.id; 822 ALTER SEQUENCE probe_translation_id_seq OWNED BY probe_translation.id;
823 823
824 824
825 -- 825 --
826 -- Name: status_protokoll; Type: TABLE; Schema: land; Owner: -; Tablespace: 826 -- Name: status_protokoll; Type: TABLE; Schema: land; Owner: -; Tablespace:
827 -- 827 --
828 828
829 CREATE TABLE status_protokoll ( 829 CREATE TABLE status_protokoll (
830 ) 830 )
831 INHERITS (bund.status_protokoll); 831 INHERITS (bund.status_protokoll);
832 832
833 833
834 -- 834 --
835 -- Name: zusatz_wert; Type: TABLE; Schema: land; Owner: -; Tablespace: 835 -- Name: zusatz_wert; Type: TABLE; Schema: land; Owner: -; Tablespace:
836 -- 836 --
837 837
838 CREATE TABLE zusatz_wert ( 838 CREATE TABLE zusatz_wert (
839 tree_modified timestamp without time zone DEFAULT now() 839 tree_modified timestamp without time zone DEFAULT now()
840 ) 840 )
842 842
843 843
844 SET search_path = stammdaten, pg_catalog; 844 SET search_path = stammdaten, pg_catalog;
845 845
846 -- 846 --
847 -- Name: auth; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 847 -- Name: auth; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
848 -- 848 --
849 849
850 CREATE TABLE auth ( 850 CREATE TABLE auth (
851 id integer NOT NULL, 851 id integer NOT NULL,
852 ldap_group character varying(40) NOT NULL, 852 ldap_group character varying(40) NOT NULL,
856 funktion_id smallint 856 funktion_id smallint
857 ); 857 );
858 858
859 859
860 -- 860 --
861 -- Name: auth_funktion; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 861 -- Name: auth_funktion; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
862 -- 862 --
863 863
864 CREATE TABLE auth_funktion ( 864 CREATE TABLE auth_funktion (
865 id smallint NOT NULL, 865 id smallint NOT NULL,
866 funktion character varying(40) 866 funktion character varying(40)
904 904
905 ALTER SEQUENCE auth_id_seq1 OWNED BY auth.id; 905 ALTER SEQUENCE auth_id_seq1 OWNED BY auth.id;
906 906
907 907
908 -- 908 --
909 -- Name: auth_lst_umw; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 909 -- Name: auth_lst_umw; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
910 -- 910 --
911 911
912 CREATE TABLE auth_lst_umw ( 912 CREATE TABLE auth_lst_umw (
913 id integer NOT NULL, 913 id integer NOT NULL,
914 lst_id character varying(5), 914 lst_id character varying(5),
934 934
935 ALTER SEQUENCE auth_lst_umw_id_seq OWNED BY auth_lst_umw.id; 935 ALTER SEQUENCE auth_lst_umw_id_seq OWNED BY auth_lst_umw.id;
936 936
937 937
938 -- 938 --
939 -- Name: datenbasis; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 939 -- Name: datenbasis; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
940 -- 940 --
941 941
942 CREATE TABLE datenbasis ( 942 CREATE TABLE datenbasis (
943 id integer NOT NULL, 943 id integer NOT NULL,
944 beschreibung character varying(30), 944 beschreibung character varying(30),
964 964
965 ALTER SEQUENCE datenbasis_id_seq OWNED BY datenbasis.id; 965 ALTER SEQUENCE datenbasis_id_seq OWNED BY datenbasis.id;
966 966
967 967
968 -- 968 --
969 -- Name: de_vg; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 969 -- Name: de_vg; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
970 -- 970 --
971 971
972 CREATE TABLE de_vg ( 972 CREATE TABLE de_vg (
973 id integer NOT NULL, 973 id integer NOT NULL,
974 use double precision, 974 use double precision,
1008 1008
1009 ALTER SEQUENCE de_vg_id_seq OWNED BY de_vg.id; 1009 ALTER SEQUENCE de_vg_id_seq OWNED BY de_vg.id;
1010 1010
1011 1011
1012 -- 1012 --
1013 -- Name: deskriptor_umwelt; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1013 -- Name: deskriptor_umwelt; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1014 -- 1014 --
1015 1015
1016 CREATE TABLE deskriptor_umwelt ( 1016 CREATE TABLE deskriptor_umwelt (
1017 id integer NOT NULL, 1017 id integer NOT NULL,
1018 s00 integer NOT NULL, 1018 s00 integer NOT NULL,
1031 umw_id character varying(3) NOT NULL 1031 umw_id character varying(3) NOT NULL
1032 ); 1032 );
1033 1033
1034 1034
1035 -- 1035 --
1036 -- Name: deskriptoren; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1036 -- Name: deskriptoren; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1037 -- 1037 --
1038 1038
1039 CREATE TABLE deskriptoren ( 1039 CREATE TABLE deskriptoren (
1040 id integer NOT NULL, 1040 id integer NOT NULL,
1041 vorgaenger integer, 1041 vorgaenger integer,
1065 1065
1066 ALTER SEQUENCE deskriptoren_id_seq OWNED BY deskriptoren.id; 1066 ALTER SEQUENCE deskriptoren_id_seq OWNED BY deskriptoren.id;
1067 1067
1068 1068
1069 -- 1069 --
1070 -- Name: koordinaten_art; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1070 -- Name: koordinaten_art; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1071 -- 1071 --
1072 1072
1073 CREATE TABLE koordinaten_art ( 1073 CREATE TABLE koordinaten_art (
1074 id integer NOT NULL, 1074 id integer NOT NULL,
1075 koordinatenart character varying(50), 1075 koordinatenart character varying(50),
1095 1095
1096 ALTER SEQUENCE koordinaten_art_id_seq OWNED BY koordinaten_art.id; 1096 ALTER SEQUENCE koordinaten_art_id_seq OWNED BY koordinaten_art.id;
1097 1097
1098 1098
1099 -- 1099 --
1100 -- Name: mess_einheit; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1100 -- Name: mess_einheit; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1101 -- 1101 --
1102 1102
1103 CREATE TABLE mess_einheit ( 1103 CREATE TABLE mess_einheit (
1104 id integer NOT NULL, 1104 id integer NOT NULL,
1105 beschreibung character varying(50), 1105 beschreibung character varying(50),
1127 1127
1128 ALTER SEQUENCE mess_einheit_id_seq OWNED BY mess_einheit.id; 1128 ALTER SEQUENCE mess_einheit_id_seq OWNED BY mess_einheit.id;
1129 1129
1130 1130
1131 -- 1131 --
1132 -- Name: mess_methode; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1132 -- Name: mess_methode; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1133 -- 1133 --
1134 1134
1135 CREATE TABLE mess_methode ( 1135 CREATE TABLE mess_methode (
1136 id character varying(2) NOT NULL, 1136 id character varying(2) NOT NULL,
1137 beschreibung character varying(300), 1137 beschreibung character varying(300),
1138 messmethode character varying(50) 1138 messmethode character varying(50)
1139 ); 1139 );
1140 1140
1141 1141
1142 -- 1142 --
1143 -- Name: mess_stelle; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1143 -- Name: mess_stelle; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1144 -- 1144 --
1145 1145
1146 CREATE TABLE mess_stelle ( 1146 CREATE TABLE mess_stelle (
1147 id character varying(5) NOT NULL, 1147 id character varying(5) NOT NULL,
1148 netzbetreiber_id character varying(2), 1148 netzbetreiber_id character varying(2),
1152 amtskennung character varying(6) 1152 amtskennung character varying(6)
1153 ); 1153 );
1154 1154
1155 1155
1156 -- 1156 --
1157 -- Name: messgroesse; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1157 -- Name: messgroesse; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1158 -- 1158 --
1159 1159
1160 CREATE TABLE messgroesse ( 1160 CREATE TABLE messgroesse (
1161 id integer NOT NULL, 1161 id integer NOT NULL,
1162 beschreibung character varying(300), 1162 beschreibung character varying(300),
1187 1187
1188 ALTER SEQUENCE messgroesse_id_seq OWNED BY messgroesse.id; 1188 ALTER SEQUENCE messgroesse_id_seq OWNED BY messgroesse.id;
1189 1189
1190 1190
1191 -- 1191 --
1192 -- Name: messgroessen_gruppe; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1192 -- Name: messgroessen_gruppe; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1193 -- 1193 --
1194 1194
1195 CREATE TABLE messgroessen_gruppe ( 1195 CREATE TABLE messgroessen_gruppe (
1196 id integer NOT NULL, 1196 id integer NOT NULL,
1197 bezeichnung character varying(80), 1197 bezeichnung character varying(80),
1217 1217
1218 ALTER SEQUENCE messgroessen_gruppe_id_seq OWNED BY messgroessen_gruppe.id; 1218 ALTER SEQUENCE messgroessen_gruppe_id_seq OWNED BY messgroessen_gruppe.id;
1219 1219
1220 1220
1221 -- 1221 --
1222 -- Name: mg_grp; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1222 -- Name: mg_grp; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1223 -- 1223 --
1224 1224
1225 CREATE TABLE mg_grp ( 1225 CREATE TABLE mg_grp (
1226 messgroessengruppe_id integer NOT NULL, 1226 messgroessengruppe_id integer NOT NULL,
1227 messgroesse_id integer NOT NULL 1227 messgroesse_id integer NOT NULL
1228 ); 1228 );
1229 1229
1230 1230
1231 -- 1231 --
1232 -- Name: mmt_messgroesse_grp; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1232 -- Name: mmt_messgroesse_grp; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1233 -- 1233 --
1234 1234
1235 CREATE TABLE mmt_messgroesse_grp ( 1235 CREATE TABLE mmt_messgroesse_grp (
1236 messgroessengruppe_id integer NOT NULL, 1236 messgroessengruppe_id integer NOT NULL,
1237 mmt_id character varying(2) NOT NULL 1237 mmt_id character varying(2) NOT NULL
1249 mg_grp 1249 mg_grp
1250 WHERE (mg_grp.messgroessengruppe_id = mmt_messgroesse_grp.messgroessengruppe_id); 1250 WHERE (mg_grp.messgroessengruppe_id = mmt_messgroesse_grp.messgroessengruppe_id);
1251 1251
1252 1252
1253 -- 1253 --
1254 -- Name: netz_betreiber; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1254 -- Name: netz_betreiber; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1255 -- 1255 --
1256 1256
1257 CREATE TABLE netz_betreiber ( 1257 CREATE TABLE netz_betreiber (
1258 id character varying(2) NOT NULL, 1258 id character varying(2) NOT NULL,
1259 netzbetreiber character varying(50), 1259 netzbetreiber character varying(50),
1264 zust_mst_id character varying(5) 1264 zust_mst_id character varying(5)
1265 ); 1265 );
1266 1266
1267 1267
1268 -- 1268 --
1269 -- Name: ort; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1269 -- Name: ort; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1270 -- 1270 --
1271 1271
1272 CREATE TABLE ort ( 1272 CREATE TABLE ort (
1273 id integer NOT NULL, 1273 id integer NOT NULL,
1274 o_typ character varying(1), 1274 o_typ character varying(1),
1320 1320
1321 ALTER SEQUENCE ort_id_seq OWNED BY ort.id; 1321 ALTER SEQUENCE ort_id_seq OWNED BY ort.id;
1322 1322
1323 1323
1324 -- 1324 --
1325 -- Name: pflicht_messgroesse; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1325 -- Name: pflicht_messgroesse; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1326 -- 1326 --
1327 1327
1328 CREATE TABLE pflicht_messgroesse ( 1328 CREATE TABLE pflicht_messgroesse (
1329 id integer NOT NULL, 1329 id integer NOT NULL,
1330 messgroesse_id integer, 1330 messgroesse_id integer,
1352 1352
1353 ALTER SEQUENCE pflicht_messgroesse_id_seq OWNED BY pflicht_messgroesse.id; 1353 ALTER SEQUENCE pflicht_messgroesse_id_seq OWNED BY pflicht_messgroesse.id;
1354 1354
1355 1355
1356 -- 1356 --
1357 -- Name: proben_zusatz; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1357 -- Name: proben_zusatz; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1358 -- 1358 --
1359 1359
1360 CREATE TABLE proben_zusatz ( 1360 CREATE TABLE proben_zusatz (
1361 id character varying(3) NOT NULL, 1361 id character varying(3) NOT NULL,
1362 meh_id integer, 1362 meh_id integer,
1365 eudf_keyword character varying(40) 1365 eudf_keyword character varying(40)
1366 ); 1366 );
1367 1367
1368 1368
1369 -- 1369 --
1370 -- Name: probenart; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1370 -- Name: probenart; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1371 -- 1371 --
1372 1372
1373 CREATE TABLE probenart ( 1373 CREATE TABLE probenart (
1374 id integer NOT NULL, 1374 id integer NOT NULL,
1375 beschreibung character varying(30), 1375 beschreibung character varying(30),
1710 FROM deskriptoren 1710 FROM deskriptoren
1711 WHERE (deskriptoren.ebene = 12); 1711 WHERE (deskriptoren.ebene = 12);
1712 1712
1713 1713
1714 -- 1714 --
1715 -- Name: staat; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1715 -- Name: staat; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1716 -- 1716 --
1717 1717
1718 CREATE TABLE staat ( 1718 CREATE TABLE staat (
1719 id integer NOT NULL, 1719 id integer NOT NULL,
1720 staat character varying(50) NOT NULL, 1720 staat character varying(50) NOT NULL,
1746 1746
1747 ALTER SEQUENCE staat_id_seq OWNED BY staat.id; 1747 ALTER SEQUENCE staat_id_seq OWNED BY staat.id;
1748 1748
1749 1749
1750 -- 1750 --
1751 -- Name: status_kombi; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1751 -- Name: status_kombi; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1752 -- 1752 --
1753 1753
1754 CREATE TABLE status_kombi ( 1754 CREATE TABLE status_kombi (
1755 id integer NOT NULL, 1755 id integer NOT NULL,
1756 stufe_id integer, 1756 stufe_id integer,
1757 wert_id integer 1757 wert_id integer
1758 ); 1758 );
1759 1759
1760 1760
1761 -- 1761 --
1762 -- Name: status_reihenfolge; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1762 -- Name: status_reihenfolge; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1763 -- 1763 --
1764 1764
1765 CREATE TABLE status_reihenfolge ( 1765 CREATE TABLE status_reihenfolge (
1766 id integer NOT NULL, 1766 id integer NOT NULL,
1767 von_id integer, 1767 von_id integer,
1768 zu_id integer 1768 zu_id integer
1769 ); 1769 );
1770 1770
1771 1771
1772 -- 1772 --
1773 -- Name: status_stufe; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1773 -- Name: status_stufe; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1774 -- 1774 --
1775 1775
1776 CREATE TABLE status_stufe ( 1776 CREATE TABLE status_stufe (
1777 id integer NOT NULL, 1777 id integer NOT NULL,
1778 stufe character varying(50) 1778 stufe character varying(50)
1779 ); 1779 );
1780 1780
1781 1781
1782 -- 1782 --
1783 -- Name: status_wert; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1783 -- Name: status_wert; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1784 -- 1784 --
1785 1785
1786 CREATE TABLE status_wert ( 1786 CREATE TABLE status_wert (
1787 id integer NOT NULL, 1787 id integer NOT NULL,
1788 wert character varying(50) 1788 wert character varying(50)
1789 ); 1789 );
1790 1790
1791 1791
1792 -- 1792 --
1793 -- Name: umwelt; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1793 -- Name: umwelt; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1794 -- 1794 --
1795 1795
1796 CREATE TABLE umwelt ( 1796 CREATE TABLE umwelt (
1797 id character varying(3) NOT NULL, 1797 id character varying(3) NOT NULL,
1798 beschreibung character varying(300), 1798 beschreibung character varying(300),
1800 meh_id integer 1800 meh_id integer
1801 ); 1801 );
1802 1802
1803 1803
1804 -- 1804 --
1805 -- Name: verwaltungseinheit; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 1805 -- Name: verwaltungseinheit; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
1806 -- 1806 --
1807 1807
1808 CREATE TABLE verwaltungseinheit ( 1808 CREATE TABLE verwaltungseinheit (
1809 id character varying(8) NOT NULL, 1809 id character varying(8) NOT NULL,
1810 bundesland character varying(8) NOT NULL, 1810 bundesland character varying(8) NOT NULL,
2151 2151
2152 2152
2153 SET search_path = bund, pg_catalog; 2153 SET search_path = bund, pg_catalog;
2154 2154
2155 -- 2155 --
2156 -- Name: kommentar_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace: 2156 -- Name: kommentar_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace:
2157 -- 2157 --
2158 2158
2159 ALTER TABLE ONLY kommentar 2159 ALTER TABLE ONLY kommentar
2160 ADD CONSTRAINT kommentar_pkey PRIMARY KEY (id); 2160 ADD CONSTRAINT kommentar_pkey PRIMARY KEY (id);
2161 2161
2162 2162
2163 -- 2163 --
2164 -- Name: list_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace: 2164 -- Name: list_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace:
2165 -- 2165 --
2166 2166
2167 ALTER TABLE ONLY list 2167 ALTER TABLE ONLY list
2168 ADD CONSTRAINT list_pkey PRIMARY KEY (id); 2168 ADD CONSTRAINT list_pkey PRIMARY KEY (id);
2169 2169
2170 2170
2171 -- 2171 --
2172 -- Name: messung_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace: 2172 -- Name: messung_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace:
2173 -- 2173 --
2174 2174
2175 ALTER TABLE ONLY messung 2175 ALTER TABLE ONLY messung
2176 ADD CONSTRAINT messung_pkey PRIMARY KEY (id); 2176 ADD CONSTRAINT messung_pkey PRIMARY KEY (id);
2177 2177
2178 2178
2179 -- 2179 --
2180 -- Name: messwert_messungs_id_messgroesse_id_key; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace: 2180 -- Name: messwert_messungs_id_messgroesse_id_key; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace:
2181 -- 2181 --
2182 2182
2183 ALTER TABLE ONLY messwert 2183 ALTER TABLE ONLY messwert
2184 ADD CONSTRAINT messwert_messungs_id_messgroesse_id_key UNIQUE (messungs_id, messgroesse_id); 2184 ADD CONSTRAINT messwert_messungs_id_messgroesse_id_key UNIQUE (messungs_id, messgroesse_id);
2185 2185
2186 2186
2187 -- 2187 --
2188 -- Name: messwert_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace: 2188 -- Name: messwert_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace:
2189 -- 2189 --
2190 2190
2191 ALTER TABLE ONLY messwert 2191 ALTER TABLE ONLY messwert
2192 ADD CONSTRAINT messwert_pkey PRIMARY KEY (id); 2192 ADD CONSTRAINT messwert_pkey PRIMARY KEY (id);
2193 2193
2194 2194
2195 -- 2195 --
2196 -- Name: ort_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace: 2196 -- Name: ort_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace:
2197 -- 2197 --
2198 2198
2199 ALTER TABLE ONLY ort 2199 ALTER TABLE ONLY ort
2200 ADD CONSTRAINT ort_pkey PRIMARY KEY (id); 2200 ADD CONSTRAINT ort_pkey PRIMARY KEY (id);
2201 2201
2202 2202
2203 -- 2203 --
2204 -- Name: probe_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace: 2204 -- Name: probe_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace:
2205 -- 2205 --
2206 2206
2207 ALTER TABLE ONLY probe 2207 ALTER TABLE ONLY probe
2208 ADD CONSTRAINT probe_pkey PRIMARY KEY (id); 2208 ADD CONSTRAINT probe_pkey PRIMARY KEY (id);
2209 2209
2210 2210
2211 -- 2211 --
2212 -- Name: status_protokoll_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace: 2212 -- Name: status_protokoll_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace:
2213 -- 2213 --
2214 2214
2215 ALTER TABLE ONLY status_protokoll 2215 ALTER TABLE ONLY status_protokoll
2216 ADD CONSTRAINT status_protokoll_pkey PRIMARY KEY (id); 2216 ADD CONSTRAINT status_protokoll_pkey PRIMARY KEY (id);
2217 2217
2218 2218
2219 -- 2219 --
2220 -- Name: zusatz_wert_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace: 2220 -- Name: zusatz_wert_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace:
2221 -- 2221 --
2222 2222
2223 ALTER TABLE ONLY zusatz_wert 2223 ALTER TABLE ONLY zusatz_wert
2224 ADD CONSTRAINT zusatz_wert_pkey PRIMARY KEY (id); 2224 ADD CONSTRAINT zusatz_wert_pkey PRIMARY KEY (id);
2225 2225
2226 2226
2227 -- 2227 --
2228 -- Name: zusatz_wert_probe_id_pzs_id_key; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace: 2228 -- Name: zusatz_wert_probe_id_pzs_id_key; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace:
2229 -- 2229 --
2230 2230
2231 ALTER TABLE ONLY zusatz_wert 2231 ALTER TABLE ONLY zusatz_wert
2232 ADD CONSTRAINT zusatz_wert_probe_id_pzs_id_key UNIQUE (probe_id, pzs_id); 2232 ADD CONSTRAINT zusatz_wert_probe_id_pzs_id_key UNIQUE (probe_id, pzs_id);
2233 2233
2234 2234
2235 SET search_path = land, pg_catalog; 2235 SET search_path = land, pg_catalog;
2236 2236
2237 -- 2237 --
2238 -- Name: kommentar_m_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 2238 -- Name: kommentar_m_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
2239 -- 2239 --
2240 2240
2241 ALTER TABLE ONLY kommentar_m 2241 ALTER TABLE ONLY kommentar_m
2242 ADD CONSTRAINT kommentar_m_pkey PRIMARY KEY (id); 2242 ADD CONSTRAINT kommentar_m_pkey PRIMARY KEY (id);
2243 2243
2244 2244
2245 -- 2245 --
2246 -- Name: kommentar_p_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 2246 -- Name: kommentar_p_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
2247 -- 2247 --
2248 2248
2249 ALTER TABLE ONLY kommentar_p 2249 ALTER TABLE ONLY kommentar_p
2250 ADD CONSTRAINT kommentar_p_pkey PRIMARY KEY (id); 2250 ADD CONSTRAINT kommentar_p_pkey PRIMARY KEY (id);
2251 2251
2252 2252
2253 -- 2253 --
2254 -- Name: messprogramm_mmt_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 2254 -- Name: messprogramm_mmt_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
2255 -- 2255 --
2256 2256
2257 ALTER TABLE ONLY messprogramm_mmt 2257 ALTER TABLE ONLY messprogramm_mmt
2258 ADD CONSTRAINT messprogramm_mmt_pkey PRIMARY KEY (id); 2258 ADD CONSTRAINT messprogramm_mmt_pkey PRIMARY KEY (id);
2259 2259
2260 2260
2261 -- 2261 --
2262 -- Name: messprogramm_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 2262 -- Name: messprogramm_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
2263 -- 2263 --
2264 2264
2265 ALTER TABLE ONLY messprogramm 2265 ALTER TABLE ONLY messprogramm
2266 ADD CONSTRAINT messprogramm_pkey PRIMARY KEY (id); 2266 ADD CONSTRAINT messprogramm_pkey PRIMARY KEY (id);
2267 2267
2268 2268
2269 -- 2269 --
2270 -- Name: messung_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 2270 -- Name: messung_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
2271 -- 2271 --
2272 2272
2273 ALTER TABLE ONLY messung 2273 ALTER TABLE ONLY messung
2274 ADD CONSTRAINT messung_pkey PRIMARY KEY (id); 2274 ADD CONSTRAINT messung_pkey PRIMARY KEY (id);
2275 2275
2276 2276
2277 -- 2277 --
2278 -- Name: messung_translation_messungs_id_key; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 2278 -- Name: messung_translation_messungs_id_key; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
2279 -- 2279 --
2280 2280
2281 ALTER TABLE ONLY messung_translation 2281 ALTER TABLE ONLY messung_translation
2282 ADD CONSTRAINT messung_translation_messungs_id_key UNIQUE (messungs_id); 2282 ADD CONSTRAINT messung_translation_messungs_id_key UNIQUE (messungs_id);
2283 2283
2284 2284
2285 -- 2285 --
2286 -- Name: messung_translation_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 2286 -- Name: messung_translation_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
2287 -- 2287 --
2288 2288
2289 ALTER TABLE ONLY messung_translation 2289 ALTER TABLE ONLY messung_translation
2290 ADD CONSTRAINT messung_translation_pkey PRIMARY KEY (id); 2290 ADD CONSTRAINT messung_translation_pkey PRIMARY KEY (id);
2291 2291
2292 2292
2293 -- 2293 --
2294 -- Name: messwert_messungs_id_messgroesse_id_key; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 2294 -- Name: messwert_messungs_id_messgroesse_id_key; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
2295 -- 2295 --
2296 2296
2297 ALTER TABLE ONLY messwert 2297 ALTER TABLE ONLY messwert
2298 ADD CONSTRAINT messwert_messungs_id_messgroesse_id_key UNIQUE (messungs_id, messgroesse_id); 2298 ADD CONSTRAINT messwert_messungs_id_messgroesse_id_key UNIQUE (messungs_id, messgroesse_id);
2299 2299
2300 2300
2301 -- 2301 --
2302 -- Name: messwert_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 2302 -- Name: messwert_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
2303 -- 2303 --
2304 2304
2305 ALTER TABLE ONLY messwert 2305 ALTER TABLE ONLY messwert
2306 ADD CONSTRAINT messwert_pkey PRIMARY KEY (id); 2306 ADD CONSTRAINT messwert_pkey PRIMARY KEY (id);
2307 2307
2308 2308
2309 -- 2309 --
2310 -- Name: ort_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 2310 -- Name: ort_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
2311 -- 2311 --
2312 2312
2313 ALTER TABLE ONLY ort 2313 ALTER TABLE ONLY ort
2314 ADD CONSTRAINT ort_pkey PRIMARY KEY (id); 2314 ADD CONSTRAINT ort_pkey PRIMARY KEY (id);
2315 2315
2316 2316
2317 -- 2317 --
2318 -- Name: probe_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 2318 -- Name: probe_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
2319 -- 2319 --
2320 2320
2321 ALTER TABLE ONLY probe 2321 ALTER TABLE ONLY probe
2322 ADD CONSTRAINT probe_pkey PRIMARY KEY (id); 2322 ADD CONSTRAINT probe_pkey PRIMARY KEY (id);
2323 2323
2324 2324
2325 -- 2325 --
2326 -- Name: probe_translation_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 2326 -- Name: probe_translation_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
2327 -- 2327 --
2328 2328
2329 ALTER TABLE ONLY probe_translation 2329 ALTER TABLE ONLY probe_translation
2330 ADD CONSTRAINT probe_translation_pkey PRIMARY KEY (id); 2330 ADD CONSTRAINT probe_translation_pkey PRIMARY KEY (id);
2331 2331
2332 2332
2333 -- 2333 --
2334 -- Name: probe_translation_probe_id_key; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 2334 -- Name: probe_translation_probe_id_key; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
2335 -- 2335 --
2336 2336
2337 ALTER TABLE ONLY probe_translation 2337 ALTER TABLE ONLY probe_translation
2338 ADD CONSTRAINT probe_translation_probe_id_key UNIQUE (probe_id); 2338 ADD CONSTRAINT probe_translation_probe_id_key UNIQUE (probe_id);
2339 2339
2340 2340
2341 -- 2341 --
2342 -- Name: status_protokoll_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 2342 -- Name: status_protokoll_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
2343 -- 2343 --
2344 2344
2345 ALTER TABLE ONLY status_protokoll 2345 ALTER TABLE ONLY status_protokoll
2346 ADD CONSTRAINT status_protokoll_pkey PRIMARY KEY (id); 2346 ADD CONSTRAINT status_protokoll_pkey PRIMARY KEY (id);
2347 2347
2348 2348
2349 -- 2349 --
2350 -- Name: zusatz_wert_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 2350 -- Name: zusatz_wert_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
2351 -- 2351 --
2352 2352
2353 ALTER TABLE ONLY zusatz_wert 2353 ALTER TABLE ONLY zusatz_wert
2354 ADD CONSTRAINT zusatz_wert_pkey PRIMARY KEY (id); 2354 ADD CONSTRAINT zusatz_wert_pkey PRIMARY KEY (id);
2355 2355
2356 2356
2357 -- 2357 --
2358 -- Name: zusatz_wert_probe_id_pzs_id_key; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 2358 -- Name: zusatz_wert_probe_id_pzs_id_key; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
2359 -- 2359 --
2360 2360
2361 ALTER TABLE ONLY zusatz_wert 2361 ALTER TABLE ONLY zusatz_wert
2362 ADD CONSTRAINT zusatz_wert_probe_id_pzs_id_key UNIQUE (probe_id, pzs_id); 2362 ADD CONSTRAINT zusatz_wert_probe_id_pzs_id_key UNIQUE (probe_id, pzs_id);
2363 2363
2364 2364
2365 SET search_path = stammdaten, pg_catalog; 2365 SET search_path = stammdaten, pg_catalog;
2366 2366
2367 -- 2367 --
2368 -- Name: auth_lst_umw_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2368 -- Name: auth_lst_umw_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2369 -- 2369 --
2370 2370
2371 ALTER TABLE ONLY auth_lst_umw 2371 ALTER TABLE ONLY auth_lst_umw
2372 ADD CONSTRAINT auth_lst_umw_pkey PRIMARY KEY (id); 2372 ADD CONSTRAINT auth_lst_umw_pkey PRIMARY KEY (id);
2373 2373
2374 2374
2375 -- 2375 --
2376 -- Name: auth_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2376 -- Name: auth_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2377 -- 2377 --
2378 2378
2379 ALTER TABLE ONLY auth 2379 ALTER TABLE ONLY auth
2380 ADD CONSTRAINT auth_pkey PRIMARY KEY (id); 2380 ADD CONSTRAINT auth_pkey PRIMARY KEY (id);
2381 2381
2382 2382
2383 -- 2383 --
2384 -- Name: auth_role_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2384 -- Name: auth_role_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2385 -- 2385 --
2386 2386
2387 ALTER TABLE ONLY auth_funktion 2387 ALTER TABLE ONLY auth_funktion
2388 ADD CONSTRAINT auth_role_pkey PRIMARY KEY (id); 2388 ADD CONSTRAINT auth_role_pkey PRIMARY KEY (id);
2389 2389
2390 2390
2391 -- 2391 --
2392 -- Name: datenbasis_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2392 -- Name: datenbasis_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2393 -- 2393 --
2394 2394
2395 ALTER TABLE ONLY datenbasis 2395 ALTER TABLE ONLY datenbasis
2396 ADD CONSTRAINT datenbasis_pkey PRIMARY KEY (id); 2396 ADD CONSTRAINT datenbasis_pkey PRIMARY KEY (id);
2397 2397
2398 2398
2399 -- 2399 --
2400 -- Name: de_vg_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2400 -- Name: de_vg_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2401 -- 2401 --
2402 2402
2403 ALTER TABLE ONLY de_vg 2403 ALTER TABLE ONLY de_vg
2404 ADD CONSTRAINT de_vg_pkey PRIMARY KEY (id); 2404 ADD CONSTRAINT de_vg_pkey PRIMARY KEY (id);
2405 2405
2406 2406
2407 -- 2407 --
2408 -- Name: deskriptor_umwelt_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2408 -- Name: deskriptor_umwelt_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2409 -- 2409 --
2410 2410
2411 ALTER TABLE ONLY deskriptor_umwelt 2411 ALTER TABLE ONLY deskriptor_umwelt
2412 ADD CONSTRAINT deskriptor_umwelt_pkey PRIMARY KEY (id); 2412 ADD CONSTRAINT deskriptor_umwelt_pkey PRIMARY KEY (id);
2413 2413
2414 2414
2415 -- 2415 --
2416 -- Name: koordinaten_art_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2416 -- Name: koordinaten_art_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2417 -- 2417 --
2418 2418
2419 ALTER TABLE ONLY koordinaten_art 2419 ALTER TABLE ONLY koordinaten_art
2420 ADD CONSTRAINT koordinaten_art_pkey PRIMARY KEY (id); 2420 ADD CONSTRAINT koordinaten_art_pkey PRIMARY KEY (id);
2421 2421
2422 2422
2423 -- 2423 --
2424 -- Name: mess_einheit_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2424 -- Name: mess_einheit_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2425 -- 2425 --
2426 2426
2427 ALTER TABLE ONLY mess_einheit 2427 ALTER TABLE ONLY mess_einheit
2428 ADD CONSTRAINT mess_einheit_pkey PRIMARY KEY (id); 2428 ADD CONSTRAINT mess_einheit_pkey PRIMARY KEY (id);
2429 2429
2430 2430
2431 -- 2431 --
2432 -- Name: mess_methode_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2432 -- Name: mess_methode_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2433 -- 2433 --
2434 2434
2435 ALTER TABLE ONLY mess_methode 2435 ALTER TABLE ONLY mess_methode
2436 ADD CONSTRAINT mess_methode_pkey PRIMARY KEY (id); 2436 ADD CONSTRAINT mess_methode_pkey PRIMARY KEY (id);
2437 2437
2438 2438
2439 -- 2439 --
2440 -- Name: mess_stelle_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2440 -- Name: mess_stelle_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2441 -- 2441 --
2442 2442
2443 ALTER TABLE ONLY mess_stelle 2443 ALTER TABLE ONLY mess_stelle
2444 ADD CONSTRAINT mess_stelle_pkey PRIMARY KEY (id); 2444 ADD CONSTRAINT mess_stelle_pkey PRIMARY KEY (id);
2445 2445
2446 2446
2447 -- 2447 --
2448 -- Name: messgroesse_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2448 -- Name: messgroesse_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2449 -- 2449 --
2450 2450
2451 ALTER TABLE ONLY messgroesse 2451 ALTER TABLE ONLY messgroesse
2452 ADD CONSTRAINT messgroesse_pkey PRIMARY KEY (id); 2452 ADD CONSTRAINT messgroesse_pkey PRIMARY KEY (id);
2453 2453
2454 2454
2455 -- 2455 --
2456 -- Name: messgroessen_gruppe_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2456 -- Name: messgroessen_gruppe_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2457 -- 2457 --
2458 2458
2459 ALTER TABLE ONLY messgroessen_gruppe 2459 ALTER TABLE ONLY messgroessen_gruppe
2460 ADD CONSTRAINT messgroessen_gruppe_pkey PRIMARY KEY (id); 2460 ADD CONSTRAINT messgroessen_gruppe_pkey PRIMARY KEY (id);
2461 2461
2462 2462
2463 -- 2463 --
2464 -- Name: mg_grp_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2464 -- Name: mg_grp_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2465 -- 2465 --
2466 2466
2467 ALTER TABLE ONLY mg_grp 2467 ALTER TABLE ONLY mg_grp
2468 ADD CONSTRAINT mg_grp_pkey PRIMARY KEY (messgroessengruppe_id, messgroesse_id); 2468 ADD CONSTRAINT mg_grp_pkey PRIMARY KEY (messgroessengruppe_id, messgroesse_id);
2469 2469
2470 2470
2471 -- 2471 --
2472 -- Name: mmt_messgroesse_grp_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2472 -- Name: mmt_messgroesse_grp_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2473 -- 2473 --
2474 2474
2475 ALTER TABLE ONLY mmt_messgroesse_grp 2475 ALTER TABLE ONLY mmt_messgroesse_grp
2476 ADD CONSTRAINT mmt_messgroesse_grp_pkey PRIMARY KEY (messgroessengruppe_id, mmt_id); 2476 ADD CONSTRAINT mmt_messgroesse_grp_pkey PRIMARY KEY (messgroessengruppe_id, mmt_id);
2477 2477
2478 2478
2479 -- 2479 --
2480 -- Name: netz_betreiber_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2480 -- Name: netz_betreiber_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2481 -- 2481 --
2482 2482
2483 ALTER TABLE ONLY netz_betreiber 2483 ALTER TABLE ONLY netz_betreiber
2484 ADD CONSTRAINT netz_betreiber_pkey PRIMARY KEY (id); 2484 ADD CONSTRAINT netz_betreiber_pkey PRIMARY KEY (id);
2485 2485
2486 2486
2487 -- 2487 --
2488 -- Name: ort_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2488 -- Name: ort_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2489 -- 2489 --
2490 2490
2491 ALTER TABLE ONLY ort 2491 ALTER TABLE ONLY ort
2492 ADD CONSTRAINT ort_pkey PRIMARY KEY (id); 2492 ADD CONSTRAINT ort_pkey PRIMARY KEY (id);
2493 2493
2494 2494
2495 -- 2495 --
2496 -- Name: pflicht_messgroesse_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2496 -- Name: pflicht_messgroesse_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2497 -- 2497 --
2498 2498
2499 ALTER TABLE ONLY pflicht_messgroesse 2499 ALTER TABLE ONLY pflicht_messgroesse
2500 ADD CONSTRAINT pflicht_messgroesse_pkey PRIMARY KEY (id); 2500 ADD CONSTRAINT pflicht_messgroesse_pkey PRIMARY KEY (id);
2501 2501
2502 2502
2503 -- 2503 --
2504 -- Name: pk_deskriptoren; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2504 -- Name: pk_deskriptoren; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2505 -- 2505 --
2506 2506
2507 ALTER TABLE ONLY deskriptoren 2507 ALTER TABLE ONLY deskriptoren
2508 ADD CONSTRAINT pk_deskriptoren PRIMARY KEY (id); 2508 ADD CONSTRAINT pk_deskriptoren PRIMARY KEY (id);
2509 2509
2510 2510
2511 -- 2511 --
2512 -- Name: proben_zusatz_eudf_keyword_key; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2512 -- Name: proben_zusatz_eudf_keyword_key; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2513 -- 2513 --
2514 2514
2515 ALTER TABLE ONLY proben_zusatz 2515 ALTER TABLE ONLY proben_zusatz
2516 ADD CONSTRAINT proben_zusatz_eudf_keyword_key UNIQUE (eudf_keyword); 2516 ADD CONSTRAINT proben_zusatz_eudf_keyword_key UNIQUE (eudf_keyword);
2517 2517
2518 2518
2519 -- 2519 --
2520 -- Name: proben_zusatz_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2520 -- Name: proben_zusatz_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2521 -- 2521 --
2522 2522
2523 ALTER TABLE ONLY proben_zusatz 2523 ALTER TABLE ONLY proben_zusatz
2524 ADD CONSTRAINT proben_zusatz_pkey PRIMARY KEY (id); 2524 ADD CONSTRAINT proben_zusatz_pkey PRIMARY KEY (id);
2525 2525
2526 2526
2527 -- 2527 --
2528 -- Name: probenart_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2528 -- Name: probenart_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2529 -- 2529 --
2530 2530
2531 ALTER TABLE ONLY probenart 2531 ALTER TABLE ONLY probenart
2532 ADD CONSTRAINT probenart_pkey PRIMARY KEY (id); 2532 ADD CONSTRAINT probenart_pkey PRIMARY KEY (id);
2533 2533
2534 2534
2535 -- 2535 --
2536 -- Name: staat_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2536 -- Name: staat_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2537 -- 2537 --
2538 2538
2539 ALTER TABLE ONLY staat 2539 ALTER TABLE ONLY staat
2540 ADD CONSTRAINT staat_pkey PRIMARY KEY (id); 2540 ADD CONSTRAINT staat_pkey PRIMARY KEY (id);
2541 2541
2542 2542
2543 -- 2543 --
2544 -- Name: status_kombi_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2544 -- Name: status_kombi_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2545 -- 2545 --
2546 2546
2547 ALTER TABLE ONLY status_kombi 2547 ALTER TABLE ONLY status_kombi
2548 ADD CONSTRAINT status_kombi_pkey PRIMARY KEY (id); 2548 ADD CONSTRAINT status_kombi_pkey PRIMARY KEY (id);
2549 2549
2550 2550
2551 -- 2551 --
2552 -- Name: status_reihenfolge_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2552 -- Name: status_reihenfolge_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2553 -- 2553 --
2554 2554
2555 ALTER TABLE ONLY status_reihenfolge 2555 ALTER TABLE ONLY status_reihenfolge
2556 ADD CONSTRAINT status_reihenfolge_pkey PRIMARY KEY (id); 2556 ADD CONSTRAINT status_reihenfolge_pkey PRIMARY KEY (id);
2557 2557
2558 2558
2559 -- 2559 --
2560 -- Name: status_stufe_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2560 -- Name: status_stufe_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2561 -- 2561 --
2562 2562
2563 ALTER TABLE ONLY status_stufe 2563 ALTER TABLE ONLY status_stufe
2564 ADD CONSTRAINT status_stufe_pkey PRIMARY KEY (id); 2564 ADD CONSTRAINT status_stufe_pkey PRIMARY KEY (id);
2565 2565
2566 2566
2567 -- 2567 --
2568 -- Name: status_wert_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2568 -- Name: status_wert_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2569 -- 2569 --
2570 2570
2571 ALTER TABLE ONLY status_wert 2571 ALTER TABLE ONLY status_wert
2572 ADD CONSTRAINT status_wert_pkey PRIMARY KEY (id); 2572 ADD CONSTRAINT status_wert_pkey PRIMARY KEY (id);
2573 2573
2574 2574
2575 -- 2575 --
2576 -- Name: umwelt_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2576 -- Name: umwelt_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2577 -- 2577 --
2578 2578
2579 ALTER TABLE ONLY umwelt 2579 ALTER TABLE ONLY umwelt
2580 ADD CONSTRAINT umwelt_pkey PRIMARY KEY (id); 2580 ADD CONSTRAINT umwelt_pkey PRIMARY KEY (id);
2581 2581
2582 2582
2583 -- 2583 --
2584 -- Name: umwelt_umwelt_bereich_key; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2584 -- Name: umwelt_umwelt_bereich_key; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2585 -- 2585 --
2586 2586
2587 ALTER TABLE ONLY umwelt 2587 ALTER TABLE ONLY umwelt
2588 ADD CONSTRAINT umwelt_umwelt_bereich_key UNIQUE (umwelt_bereich); 2588 ADD CONSTRAINT umwelt_umwelt_bereich_key UNIQUE (umwelt_bereich);
2589 2589
2590 2590
2591 -- 2591 --
2592 -- Name: verwaltungseinheit_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 2592 -- Name: verwaltungseinheit_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
2593 -- 2593 --
2594 2594
2595 ALTER TABLE ONLY verwaltungseinheit 2595 ALTER TABLE ONLY verwaltungseinheit
2596 ADD CONSTRAINT verwaltungseinheit_pkey PRIMARY KEY (id); 2596 ADD CONSTRAINT verwaltungseinheit_pkey PRIMARY KEY (id);
2597 2597
2598 2598
2599 SET search_path = bund, pg_catalog; 2599 SET search_path = bund, pg_catalog;
2600 2600
2601 -- 2601 --
2602 -- Name: p_list_zuord1; Type: INDEX; Schema: bund; Owner: -; Tablespace: 2602 -- Name: p_list_zuord1; Type: INDEX; Schema: bund; Owner: -; Tablespace:
2603 -- 2603 --
2604 2604
2605 CREATE INDEX p_list_zuord1 ON list_zuordnung USING btree (list_id); 2605 CREATE INDEX p_list_zuord1 ON list_zuordnung USING btree (list_id);
2606 2606
2607 2607
2608 -- 2608 --
2609 -- Name: p_list_zuord2; Type: INDEX; Schema: bund; Owner: -; Tablespace: 2609 -- Name: p_list_zuord2; Type: INDEX; Schema: bund; Owner: -; Tablespace:
2610 -- 2610 --
2611 2611
2612 CREATE INDEX p_list_zuord2 ON list_zuordnung USING hash (list_id); 2612 CREATE INDEX p_list_zuord2 ON list_zuordnung USING hash (list_id);
2613 2613
2614 2614
2615 SET search_path = land, pg_catalog; 2615 SET search_path = land, pg_catalog;
2616 2616
2617 -- 2617 --
2618 -- Name: messung_probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: 2618 -- Name: messung_probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace:
2619 -- 2619 --
2620 2620
2621 CREATE INDEX messung_probe_id_idx ON messung USING btree (probe_id); 2621 CREATE INDEX messung_probe_id_idx ON messung USING btree (probe_id);
2622 2622
2623 2623
2624 -- 2624 --
2625 -- Name: messung_translation_messungs_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: 2625 -- Name: messung_translation_messungs_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace:
2626 -- 2626 --
2627 2627
2628 CREATE INDEX messung_translation_messungs_id_idx ON messung_translation USING btree (messungs_id); 2628 CREATE INDEX messung_translation_messungs_id_idx ON messung_translation USING btree (messungs_id);
2629 2629
2630 2630
2631 -- 2631 --
2632 -- Name: messwert_messungs_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: 2632 -- Name: messwert_messungs_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace:
2633 -- 2633 --
2634 2634
2635 CREATE INDEX messwert_messungs_id_idx ON messwert USING btree (messungs_id); 2635 CREATE INDEX messwert_messungs_id_idx ON messwert USING btree (messungs_id);
2636 2636
2637 2637
2638 -- 2638 --
2639 -- Name: probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: 2639 -- Name: probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace:
2640 -- 2640 --
2641 2641
2642 CREATE INDEX probe_id_idx ON probe USING btree (id); 2642 CREATE INDEX probe_id_idx ON probe USING btree (id);
2643 2643
2644 2644
2645 -- 2645 --
2646 -- Name: probe_translation_probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: 2646 -- Name: probe_translation_probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace:
2647 -- 2647 --
2648 2648
2649 CREATE INDEX probe_translation_probe_id_idx ON probe_translation USING btree (probe_id); 2649 CREATE INDEX probe_translation_probe_id_idx ON probe_translation USING btree (probe_id);
2650 2650
2651 2651
2652 SET search_path = stammdaten, pg_catalog; 2652 SET search_path = stammdaten, pg_catalog;
2653 2653
2654 -- 2654 --
2655 -- Name: de_vg_geom_gist; Type: INDEX; Schema: stammdaten; Owner: -; Tablespace: 2655 -- Name: de_vg_geom_gist; Type: INDEX; Schema: stammdaten; Owner: -; Tablespace:
2656 -- 2656 --
2657 2657
2658 CREATE INDEX de_vg_geom_gist ON de_vg USING gist (geom); 2658 CREATE INDEX de_vg_geom_gist ON de_vg USING gist (geom);
2659 2659
2660 2660
2661 -- 2661 --
2662 -- Name: fts_stauts_kooin10001; Type: INDEX; Schema: stammdaten; Owner: -; Tablespace: 2662 -- Name: fts_stauts_kooin10001; Type: INDEX; Schema: stammdaten; Owner: -; Tablespace:
2663 -- 2663 --
2664 2664
2665 CREATE INDEX fts_stauts_kooin10001 ON staat USING btree (kda_id); 2665 CREATE INDEX fts_stauts_kooin10001 ON staat USING btree (kda_id);
2666 2666
2667 2667
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)