Mercurial > lada > lada-server
diff db_schema/stammdaten_schema.sql @ 912:d8c66007fa14
netzbetreiber_id is mandatory for ort.
A federal ort has netzbetreiber_id 'D'
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 08 Apr 2016 11:14:09 +0200 |
| parents | df2908334150 |
| children | 9121d99a471e |
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql Fri Apr 08 11:12:03 2016 +0200 +++ b/db_schema/stammdaten_schema.sql Fri Apr 08 11:14:09 2016 +0200 @@ -494,7 +494,7 @@ CREATE TABLE ort ( id integer PRIMARY KEY DEFAULT nextval('ort_id_seq'::regclass), - netzbetreiber_id character varying(2) REFERENCES netz_betreiber, + netzbetreiber_id character varying(2) NOT NULL REFERENCES netz_betreiber, ort_id character varying(10) NOT NULL, langtext character varying(100) NOT NULL, staat_id smallint NOT NULL REFERENCES staat,