Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql-minfo.sql @ 8019:aa8dcf7331a8
Repair last commit.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 09 Jul 2014 15:56:15 +0200 |
| parents | ad614eff7a9b |
| children | fd3a24336e6a |
comparison
equal
deleted
inserted
replaced
| 8018:ad614eff7a9b | 8019:aa8dcf7331a8 |
|---|---|
| 337 sediment_load_id int NOT NULL, | 337 sediment_load_id int NOT NULL, |
| 338 measurement_station_id int NOT NULL, | 338 measurement_station_id int NOT NULL, |
| 339 value DOUBLE PRECISION NOT NULL, | 339 value DOUBLE PRECISION NOT NULL, |
| 340 PRIMARY KEY (id), | 340 PRIMARY KEY (id), |
| 341 CONSTRAINT fk_slv_sediment_load_id FOREIGN KEY (sediment_load_id) | 341 CONSTRAINT fk_slv_sediment_load_id FOREIGN KEY (sediment_load_id) |
| 342 REFERENCES sediment_loads(id) ON DELETE CASCADE, | 342 REFERENCES sediment_load(id) ON DELETE CASCADE, |
| 343 CONSTRAINT fk_slv_m_station_id FOREIGN KEY (measurement_station_id) | 343 CONSTRAINT fk_slv_m_station_id FOREIGN KEY (measurement_station_id) |
| 344 REFERENCES measurement_station(id) ON DELETE CASCADE | 344 REFERENCES measurement_station(id) ON DELETE CASCADE |
| 345 ); | 345 ); |
| 346 | 346 |
| 347 | 347 |