Mercurial > lada > lada-server
comparison db_schema/stammdaten_schema.sql @ 968:69b954343acc
Add missing FK-constraint.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 02 Jun 2016 18:04:44 +0200 |
| parents | ad69878b7280 |
| children | 35878d9b4321 |
comparison
equal
deleted
inserted
replaced
| 966:bc44dcda6f69 | 968:69b954343acc |
|---|---|
| 138 ); | 138 ); |
| 139 | 139 |
| 140 | 140 |
| 141 CREATE TABLE mess_stelle ( | 141 CREATE TABLE mess_stelle ( |
| 142 id character varying(5) PRIMARY KEY, | 142 id character varying(5) PRIMARY KEY, |
| 143 netzbetreiber_id character varying(2) NOT NULL, | 143 netzbetreiber_id character varying(2) NOT NULL REFERENCES netz_betreiber, |
| 144 beschreibung character varying(300), | 144 beschreibung character varying(300), |
| 145 mess_stelle character varying(60), | 145 mess_stelle character varying(60), |
| 146 mst_typ character varying(1), | 146 mst_typ character varying(1), |
| 147 amtskennung character varying(6) | 147 amtskennung character varying(6) |
| 148 ); | 148 ); |