Mercurial > gemma

diff schema/gemma.sql @ 3278:831193935739

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Avoid storing of NtS messages other than water level
author Tom Gottfried <tom@intevation.de>
date Wed, 15 May 2019 19:42:21 +0200
parents 232fc90e6ee2
children ec6163c6687d
line wrap: on
line diff
--- a/schema/gemma.sql	Wed May 15 19:08:49 2019 +0200
+++ b/schema/gemma.sql	Wed May 15 19:42:21 2019 +0200
@@ -311,7 +311,6 @@
         date_issue timestamp with time zone NOT NULL,
         reference_code varchar(4) NOT NULL REFERENCES depth_references,
         water_level double precision NOT NULL,
-        is_waterlevel boolean NOT NULL,
         date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
         source_organization varchar NOT NULL, -- "originator" from NtS response
         staging_done boolean NOT NULL DEFAULT false,
@@ -327,7 +326,6 @@
         date_issue timestamp with time zone NOT NULL,
         reference_code varchar(4) NOT NULL REFERENCES depth_references,
         water_level double precision NOT NULL,
-        is_waterlevel boolean NOT NULL,
         conf_interval numrange
             CHECK (conf_interval @> CAST(water_level AS numeric)),
         date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,