Mercurial > lada > lada-server
comparison db_schema/stammdaten_schema.sql @ 1222:f8df0eae09e4
In memoriam Oracle.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 09 Dec 2016 14:47:13 +0100 |
| parents | 59b0e54426d4 |
| children | 9b8b18c00804 |
comparison
equal
deleted
inserted
replaced
| 1221:59b0e54426d4 | 1222:f8df0eae09e4 |
|---|---|
| 141 id serial PRIMARY KEY, | 141 id serial PRIMARY KEY, |
| 142 staat character varying(50) NOT NULL, | 142 staat character varying(50) NOT NULL, |
| 143 hkl_id smallint NOT NULL, | 143 hkl_id smallint NOT NULL, |
| 144 staat_iso character varying(2), | 144 staat_iso character varying(2), |
| 145 staat_kurz character varying(5), | 145 staat_kurz character varying(5), |
| 146 eu character(1) DEFAULT NULL::bpchar, | 146 eu boolean, |
| 147 koord_x_extern character varying(22), | 147 koord_x_extern character varying(22), |
| 148 koord_y_extern character varying(22), | 148 koord_y_extern character varying(22), |
| 149 kda_id integer REFERENCES koordinaten_art | 149 kda_id integer REFERENCES koordinaten_art |
| 150 ); | 150 ); |
| 151 | 151 |