Mercurial > lada > lada-server
comparison db_schema/stammdaten_schema.sql @ 1212:6f206d8eab7e
Remove obsolete redundant attributes.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Thu, 08 Dec 2016 14:30:35 +0100 |
parents | df75a467d55a |
children | aed3332cfacc |
comparison
equal
deleted
inserted
replaced
1211:f5bedfc7bcc6 | 1212:6f206d8eab7e |
---|---|
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 latitude double precision, | |
435 longitude double precision, | |
436 geom public.geometry(Point,4326), | 434 geom public.geometry(Point,4326), |
437 shape public.geometry(MultiPolygon,4326), | 435 shape public.geometry(MultiPolygon,4326), |
438 ort_typ smallint REFERENCES ort_typ, | 436 ort_typ smallint REFERENCES ort_typ, |
439 kurztext character varying(15) NOT NULL, | 437 kurztext character varying(15) NOT NULL, |
440 berichtstext character varying(70), | 438 berichtstext character varying(70), |