changeset 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 5287440b57b3
children 662bcb3bdfd7
files flys-backend/doc/schema/oracle-minfo.sql flys-backend/doc/schema/postgresql-minfo.sql
diffstat 2 files changed, 6 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-minfo.sql	Wed Mar 27 11:48:53 2013 +0100
+++ b/flys-backend/doc/schema/oracle-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       NUMBER(38),
+    -- store name and km of reference gauges here too, as not all are in gauges
+    reference_gauge_name     VARCHAR(64),
+    reference_gauge_station  NUMBER(38,3),
     observation_timerange_id NUMBER(38),
     operator                 VARCHAR(64),
     description              VARCHAR(512),
--- 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),

http://dive4elements.wald.intevation.org