Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql.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 | c1abd48a03e2 |
| children | 4fafe8d147b2 |
comparison
equal
deleted
inserted
replaced
| 5893:c1abd48a03e2 | 5894:62e6598a2c4b |
|---|---|
| 84 name VARCHAR(256) NOT NULL, | 84 name VARCHAR(256) NOT NULL, |
| 85 -- remove river id here because range_id references river already | 85 -- remove river id here because range_id references river already |
| 86 river_id int NOT NULL REFERENCES rivers(id) ON DELETE CASCADE, | 86 river_id int NOT NULL REFERENCES rivers(id) ON DELETE CASCADE, |
| 87 station NUMERIC NOT NULL, | 87 station NUMERIC NOT NULL, |
| 88 aeo NUMERIC NOT NULL, | 88 aeo NUMERIC NOT NULL, |
| 89 official_number int8 UNIQUE, | 89 official_number int8, |
| 90 | 90 |
| 91 -- Pegelnullpunkt | 91 -- Pegelnullpunkt |
| 92 datum NUMERIC NOT NULL, | 92 datum NUMERIC NOT NULL, |
| 93 -- Streckengueltigkeit | 93 -- Streckengueltigkeit |
| 94 range_id int NOT NULL REFERENCES ranges (id) ON DELETE CASCADE, | 94 range_id int NOT NULL REFERENCES ranges (id) ON DELETE CASCADE, |
| 95 | 95 |
| 96 UNIQUE (name, river_id), | 96 UNIQUE (name, river_id), |
| 97 UNIQUE (official_number, river_id), | |
| 97 UNIQUE (river_id, station) | 98 UNIQUE (river_id, station) |
| 98 ); | 99 ); |
| 99 | 100 |
| 100 -- Type of a Hauptwert 'W', 'Q', 'D', etc. | 101 -- Type of a Hauptwert 'W', 'Q', 'D', etc. |
| 101 CREATE SEQUENCE MAIN_VALUE_TYPES_ID_SEQ; | 102 CREATE SEQUENCE MAIN_VALUE_TYPES_ID_SEQ; |