Mercurial > lada > lada-server
comparison db_schema/stammdaten_schema.sql @ 1221:59b0e54426d4
Use NULL instead of '-' for missing values.
This way missing values can be found and processed in the usual manner.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 09 Dec 2016 14:40:42 +0100 |
| parents | aed3332cfacc |
| children | f8df0eae09e4 |
comparison
equal
deleted
inserted
replaced
| 1220:faa6a2117d1e | 1221:59b0e54426d4 |
|---|---|
| 139 | 139 |
| 140 CREATE TABLE staat ( | 140 CREATE TABLE staat ( |
| 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) NOT NULL, | 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 character(1) DEFAULT NULL::bpchar, |
| 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 |