Mercurial > lada > lada-server
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 911:175c89b3550a | 912:d8c66007fa14 |
|---|---|
| 492 NO MAXVALUE | 492 NO MAXVALUE |
| 493 CACHE 1; | 493 CACHE 1; |
| 494 | 494 |
| 495 CREATE TABLE ort ( | 495 CREATE TABLE ort ( |
| 496 id integer PRIMARY KEY DEFAULT nextval('ort_id_seq'::regclass), | 496 id integer PRIMARY KEY DEFAULT nextval('ort_id_seq'::regclass), |
| 497 netzbetreiber_id character varying(2) REFERENCES netz_betreiber, | 497 netzbetreiber_id character varying(2) NOT NULL REFERENCES netz_betreiber, |
| 498 ort_id character varying(10) NOT NULL, | 498 ort_id character varying(10) NOT NULL, |
| 499 langtext character varying(100) NOT NULL, | 499 langtext character varying(100) NOT NULL, |
| 500 staat_id smallint NOT NULL REFERENCES staat, | 500 staat_id smallint NOT NULL REFERENCES staat, |
| 501 gem_id character varying(8) REFERENCES verwaltungseinheit, | 501 gem_id character varying(8) REFERENCES verwaltungseinheit, |
| 502 unscharf character(1) DEFAULT NULL::bpchar, | 502 unscharf character(1) DEFAULT NULL::bpchar, |