Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql-minfo.sql @ 5453:303701ab73c6
store name and km of reference gauges in measurement_stations too, as not all are in gauges
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Wed, 27 Mar 2013 12:13:21 +0100 |
| parents | b279f2d4bc78 |
| children | 45c5b8b08ffd |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-minfo.sql Wed Mar 27 11:48:53 2013 +0100 +++ b/flys-backend/doc/schema/postgresql-minfo.sql Wed Mar 27 12:13:21 2013 +0100 @@ -287,6 +287,9 @@ measurement_type VARCHAR(64) NOT NULL, riverside VARCHAR(16), reference_gauge_id int, + -- store name and km of reference gauges here too, as not all are in gauges + reference_gauge_name VARCHAR(64), + reference_gauge_station NUMERIC, observation_timerange_id int, operator VARCHAR(64), description VARCHAR(512),