Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-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 |
|---|---|
| 336 sediment_load_id int NOT NULL, | 336 sediment_load_id int NOT NULL, |
| 337 measurement_station_id int NOT NULL, | 337 measurement_station_id int NOT NULL, |
| 338 value DOUBLE PRECISION NOT NULL, | 338 value DOUBLE PRECISION NOT NULL, |
| 339 PRIMARY KEY (id), | 339 PRIMARY KEY (id), |
| 340 CONSTRAINT fk_slv_sediment_load_id FOREIGN KEY (sediment_load_id) | 340 CONSTRAINT fk_slv_sediment_load_id FOREIGN KEY (sediment_load_id) |
| 341 REFERENCES sediment_loads(id) ON DELETE CASCADE, | 341 REFERENCES sediment_load(id) ON DELETE CASCADE, |
| 342 CONSTRAINT fk_slv_m_station_id FOREIGN KEY (measurement_station_id) | 342 CONSTRAINT fk_slv_m_station_id FOREIGN KEY (measurement_station_id) |
| 343 REFERENCES measurement_station(id) ON DELETE CASCADE | 343 REFERENCES measurement_station(id) ON DELETE CASCADE |
| 344 ); | 344 ); |
| 345 | 345 |
| 346 | 346 |