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 |