Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql-minfo.sql @ 8666:1a4ad0d4231a
(issue1763) Use more distinct constraint names and adapt drop-script.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 08 Apr 2015 18:15:55 +0200 |
| parents | 9db1f48bfea9 |
| children | bfca77cbf353 |
comparison
equal
deleted
inserted
replaced
| 8665:8fbc0649da13 | 8666:1a4ad0d4231a |
|---|---|
| 47 old_elevation_model_id int, | 47 old_elevation_model_id int, |
| 48 range_id int, | 48 range_id int, |
| 49 evaluation_by VARCHAR(255), | 49 evaluation_by VARCHAR(255), |
| 50 description VARCHAR(255), | 50 description VARCHAR(255), |
| 51 PRIMARY KEY(id), | 51 PRIMARY KEY(id), |
| 52 CONSTRAINT fk_bed_river_id FOREIGN KEY (river_id) | 52 CONSTRAINT fk_bh_river_id FOREIGN KEY (river_id) |
| 53 REFERENCES rivers(id) ON DELETE CASCADE, | 53 REFERENCES rivers(id) ON DELETE CASCADE, |
| 54 CONSTRAINT fk_type FOREIGN KEY (type_id) REFERENCES bed_height_type(id), | 54 CONSTRAINT fk_bh_type FOREIGN KEY (type_id) REFERENCES bed_height_type(id), |
| 55 CONSTRAINT fk_location_system FOREIGN KEY (location_system_id) | 55 CONSTRAINT fk_bh_location_system FOREIGN KEY (location_system_id) |
| 56 REFERENCES location_system(id), | 56 REFERENCES location_system(id), |
| 57 CONSTRAINT fk_cur_elevation_model FOREIGN KEY (cur_elevation_model_id) | 57 CONSTRAINT fk_bh_cur_elevation_model FOREIGN KEY (cur_elevation_model_id) |
| 58 REFERENCES elevation_model(id), | 58 REFERENCES elevation_model(id), |
| 59 CONSTRAINT fk_old_elevation_model FOREIGN KEY (old_elevation_model_id) | 59 CONSTRAINT fk_bh_old_elevation_model FOREIGN KEY (old_elevation_model_id) |
| 60 REFERENCES elevation_model(id), | 60 REFERENCES elevation_model(id), |
| 61 CONSTRAINT fk_range FOREIGN KEY (range_id) | 61 CONSTRAINT fk_bh_range FOREIGN KEY (range_id) |
| 62 REFERENCES ranges(id) ON DELETE CASCADE | 62 REFERENCES ranges(id) ON DELETE CASCADE |
| 63 ); | 63 ); |
| 64 | 64 |
| 65 | 65 |
| 66 CREATE SEQUENCE BED_HEIGHT_VALUES_ID_SEQ; | 66 CREATE SEQUENCE BED_HEIGHT_VALUES_ID_SEQ; |