Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql-minfo.sql @ 5894:62e6598a2c4b
Schema change: make gauges.official_number unique per river as we can have multiple identical gauges for different representations of the same river. Comments and TODOs
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 03 May 2013 10:31:34 +0200 |
| parents | 5aa05a7a34b7 |
| children | 2d16f4a0bdcc |
comparison
equal
deleted
inserted
replaced
| 5893:c1abd48a03e2 | 5894:62e6598a2c4b |
|---|---|
| 63 | 63 |
| 64 CREATE TABLE bed_height_epoch ( | 64 CREATE TABLE bed_height_epoch ( |
| 65 id int NOT NULL, | 65 id int NOT NULL, |
| 66 river_id int NOT NULL, | 66 river_id int NOT NULL, |
| 67 time_interval_id int NOT NULL, | 67 time_interval_id int NOT NULL, |
| 68 -- sounding_with int NOT NULL, | 68 -- sounding_width int, |
| 69 -- type_id int NOT NULL, | 69 -- type_id int NOT NULL, |
| 70 cur_elevation_model_id int NOT NULL, | 70 cur_elevation_model_id int NOT NULL, |
| 71 old_elevation_model_id int, | 71 old_elevation_model_id int, |
| 72 range_id int, | 72 range_id int, |
| 73 evaluation_by VARCHAR(255), | 73 evaluation_by VARCHAR(255), |