Mercurial > lada > lada-server
comparison db_schema/stammdaten_schema.sql @ 1208:9dda1237c756
Add missing FK constraint.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 05 Dec 2016 12:20:10 +0100 |
| parents | 289edf060550 |
| children | df75a467d55a |
comparison
equal
deleted
inserted
replaced
| 1207:6692b3bdc49d | 1208:9dda1237c756 |
|---|---|
| 164 mittelpunkt public.geometry(Point) | 164 mittelpunkt public.geometry(Point) |
| 165 ); | 165 ); |
| 166 | 166 |
| 167 CREATE TABLE verwaltungsgrenze ( | 167 CREATE TABLE verwaltungsgrenze ( |
| 168 id serial PRIMARY KEY, | 168 id serial PRIMARY KEY, |
| 169 gem_id character varying(8) NOT NULL, | 169 gem_id character varying(8) NOT NULL REFERENCES verwaltungseinheit, |
| 170 shape public.geometry(MultiPolygon, 4326) | 170 shape public.geometry(MultiPolygon, 4326) |
| 171 ); | 171 ); |
| 172 | 172 |
| 173 CREATE TABLE netz_betreiber ( | 173 CREATE TABLE netz_betreiber ( |
| 174 id character varying(2) PRIMARY KEY, | 174 id character varying(2) PRIMARY KEY, |