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), |