Mercurial > lada > lada-server
comparison db_schema/stammdaten_schema.sql @ 1176:33dc7dc6b7bc
Removed NOT NULL constraint from stammdaten.ort.staat_id.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Wed, 16 Nov 2016 15:57:14 +0100 |
| parents | 60b91dbb98cc |
| children | 612107caf961 |
comparison
equal
deleted
inserted
replaced
| 1175:60b91dbb98cc | 1176:33dc7dc6b7bc |
|---|---|
| 438 CREATE TABLE ort ( | 438 CREATE TABLE ort ( |
| 439 id serial PRIMARY KEY, | 439 id serial PRIMARY KEY, |
| 440 netzbetreiber_id character varying(2) NOT NULL REFERENCES netz_betreiber, | 440 netzbetreiber_id character varying(2) NOT NULL REFERENCES netz_betreiber, |
| 441 ort_id character varying(10) NOT NULL, | 441 ort_id character varying(10) NOT NULL, |
| 442 langtext character varying(100) NOT NULL, | 442 langtext character varying(100) NOT NULL, |
| 443 staat_id smallint NOT NULL REFERENCES staat, | 443 staat_id smallint REFERENCES staat, |
| 444 gem_id character varying(8) REFERENCES verwaltungseinheit, | 444 gem_id character varying(8) REFERENCES verwaltungseinheit, |
| 445 unscharf character(1) DEFAULT NULL::bpchar, | 445 unscharf character(1) DEFAULT NULL::bpchar, |
| 446 nuts_code character varying(10), | 446 nuts_code character varying(10), |
| 447 kda_id integer NOT NULL REFERENCES koordinaten_art, | 447 kda_id integer NOT NULL REFERENCES koordinaten_art, |
| 448 koord_x_extern character varying(22) NOT NULL, | 448 koord_x_extern character varying(22) NOT NULL, |