diff flys-backend/doc/schema/oracle-minfo.sql @ 5456:e47c4e9b050e

Schema corrected: measurement_station.reference_gauge_station is not needed
author Tom Gottfried <tom.gottfried@intevation.de>
date Wed, 27 Mar 2013 12:55:57 +0100
parents 45c5b8b08ffd
children c2bd97cd127f
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-minfo.sql	Wed Mar 27 12:45:52 2013 +0100
+++ b/flys-backend/doc/schema/oracle-minfo.sql	Wed Mar 27 12:55:57 2013 +0100
@@ -287,9 +287,8 @@
     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
+    -- store name 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),

http://dive4elements.wald.intevation.org