Mercurial > lada > lada-server
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 1212:6f206d8eab7e | 1213:aed3332cfacc |
|---|---|
| 429 kda_id integer NOT NULL REFERENCES koordinaten_art, | 429 kda_id integer NOT NULL REFERENCES koordinaten_art, |
| 430 koord_x_extern character varying(22) NOT NULL, | 430 koord_x_extern character varying(22) NOT NULL, |
| 431 koord_y_extern character varying(22) NOT NULL, | 431 koord_y_extern character varying(22) NOT NULL, |
| 432 hoehe_land real, | 432 hoehe_land real, |
| 433 letzte_aenderung timestamp without time zone DEFAULT now(), | 433 letzte_aenderung timestamp without time zone DEFAULT now(), |
| 434 geom public.geometry(Point,4326), | 434 geom public.geometry(Point,4326) NOT NULL, |
| 435 shape public.geometry(MultiPolygon,4326), | 435 shape public.geometry(MultiPolygon,4326), |
| 436 ort_typ smallint REFERENCES ort_typ, | 436 ort_typ smallint REFERENCES ort_typ, |
| 437 kurztext character varying(15) NOT NULL, | 437 kurztext character varying(15) NOT NULL, |
| 438 berichtstext character varying(70), | 438 berichtstext character varying(70), |
| 439 zone character varying(1), | 439 zone character varying(1), |