Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql-minfo.sql @ 8641:c851d1ea543a
SCHEMA CHANGE: Remove unnecessary direct relation of sq_relation with rivers.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 27 Mar 2015 17:42:27 +0100 |
| parents | 6fcf4717605f |
| children | 9db1f48bfea9 |
comparison
equal
deleted
inserted
replaced
| 8640:0d15ebafbd0e | 8641:c851d1ea543a |
|---|---|
| 346 PRIMARY KEY (id), | 346 PRIMARY KEY (id), |
| 347 CONSTRAINT fk_sl_kind_id FOREIGN KEY (kind) | 347 CONSTRAINT fk_sl_kind_id FOREIGN KEY (kind) |
| 348 REFERENCES sediment_load_kinds(id), | 348 REFERENCES sediment_load_kinds(id), |
| 349 CONSTRAINT fk_sl_grain_fraction_id FOREIGN KEY (grain_fraction_id) | 349 CONSTRAINT fk_sl_grain_fraction_id FOREIGN KEY (grain_fraction_id) |
| 350 REFERENCES grain_fraction(id), | 350 REFERENCES grain_fraction(id), |
| 351 CONSTRAINT fk_sl_time_interval_id FOREIGN KEY (time_interval_id) | 351 CONSTRAINT fk_sl_time_interval_id FOREIGN KEY (time_interval_id) |
| 352 REFERENCES time_intervals(id), | 352 REFERENCES time_intervals(id), |
| 353 CONSTRAINT fk_sl_sq_time_interval_id FOREIGN KEY (sq_time_interval_id) | 353 CONSTRAINT fk_sl_sq_time_interval_id FOREIGN KEY (sq_time_interval_id) |
| 354 REFERENCES time_intervals(id) | 354 REFERENCES time_intervals(id) |
| 355 ); | 355 ); |
| 356 | 356 |
| 372 | 372 |
| 373 CREATE SEQUENCE SQ_RELATION_ID_SEQ; | 373 CREATE SEQUENCE SQ_RELATION_ID_SEQ; |
| 374 | 374 |
| 375 CREATE TABLE sq_relation ( | 375 CREATE TABLE sq_relation ( |
| 376 id int NOT NULL, | 376 id int NOT NULL, |
| 377 river_id int NOT NULL, | |
| 378 time_interval_id int NOT NULL, | 377 time_interval_id int NOT NULL, |
| 379 description VARCHAR(256), | 378 description VARCHAR(256), |
| 380 PRIMARY KEY (id), | 379 PRIMARY KEY (id), |
| 381 CONSTRAINT fk_sqr_river_id FOREIGN KEY (river_id) | |
| 382 REFERENCES rivers(id) ON DELETE CASCADE, | |
| 383 CONSTRAINT fk_sqr_tinterval_id FOREIGN KEY (time_interval_id) | 380 CONSTRAINT fk_sqr_tinterval_id FOREIGN KEY (time_interval_id) |
| 384 REFERENCES time_intervals(id) | 381 REFERENCES time_intervals(id) |
| 385 ); | 382 ); |
| 386 | 383 |
| 387 | 384 |