diff db_schema/stammdaten_schema.sql @ 1188:1bc8ab13e1f7

redesign stammdaten.verwaltungseinheit
author Michael Stanko <mstanko@bfs.de>
date Fri, 25 Nov 2016 09:37:39 +0100
parents 612107caf961
children 289edf060550
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql	Mon Nov 21 14:54:09 2016 +0100
+++ b/db_schema/stammdaten_schema.sql	Fri Nov 25 09:37:39 2016 +0100
@@ -149,26 +149,26 @@
     kda_id integer REFERENCES koordinaten_art
 );
 
-
 CREATE TABLE verwaltungseinheit (
-    id character varying(8) PRIMARY KEY,
-    bundesland character varying(8) NOT NULL,
-    kda_id integer REFERENCES koordinaten_art,
-    kreis character varying(8),
-    nuts character varying(10),
-    regbezirk character varying(8),
+    id character varying(8) NOT NULL PRIMARY KEY,
     bezeichnung character varying(80) NOT NULL,
-    is_bundesland character(1) NOT NULL,
-    is_gemeinde character(1) NOT NULL,
-    is_landkreis character(1) NOT NULL,
-    is_regbezirk character(1) NOT NULL,
-    koord_x_extern character varying(22),
-    koord_y_extern character varying(22),
+    regbezirk character varying(8),
+    kreis character varying(8),
+    bundesland character varying(8) NOT NULL,
+    is_gemeinde boolean DEFAULT false NOT NULL,
+    is_landkreis boolean DEFAULT false NOT NULL,
+    is_regbezirk boolean DEFAULT false NOT NULL,
+    is_bundesland boolean DEFAULT false NOT NULL,
     plz character varying(6),
-    longitude double precision,
-    latitude double precision
+    nuts character varying(10),
+    mittelpunkt public.geometry(Point)
 );
 
+CREATE TABLE verwaltungsgrenze (
+    id serial PRIMARY KEY,
+    gem_id character varying(8) NOT NULL,
+    shape public.geometry(MultiPolygon)
+);
 
 CREATE TABLE netz_betreiber (
     id character varying(2) PRIMARY KEY,
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)