Mercurial > lada > lada-server
diff db_schema/stammdaten_schema.sql @ 1213:aed3332cfacc
An Ort always has a location which is created from respective input.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 08 Dec 2016 14:47:21 +0100 |
| parents | 6f206d8eab7e |
| children | 59b0e54426d4 |
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql Thu Dec 08 14:30:35 2016 +0100 +++ b/db_schema/stammdaten_schema.sql Thu Dec 08 14:47:21 2016 +0100 @@ -431,7 +431,7 @@ koord_y_extern character varying(22) NOT NULL, hoehe_land real, letzte_aenderung timestamp without time zone DEFAULT now(), - geom public.geometry(Point,4326), + geom public.geometry(Point,4326) NOT NULL, shape public.geometry(MultiPolygon,4326), ort_typ smallint REFERENCES ort_typ, kurztext character varying(15) NOT NULL,