Mercurial > gemma

changeset 72:158f776732c7

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add gauge measurements stub.
author Tom Gottfried <tom@intevation.de>
date Wed, 30 May 2018 16:51:45 +0200
parents e9bc0d93bef9
children 65a8aeb9e2b3
files wamos.sql
diffstat 1 files changed, 10 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/wamos.sql	Wed May 30 16:42:38 2018 +0200
+++ b/wamos.sql	Wed May 30 16:51:45 2018 +0200
@@ -80,6 +80,16 @@
        value int NOT NULL
        );
 
+CREATE TABLE wamos.gauge_measurements (
+       fk_gauge_id isrs NOT NULL REFERENCES gauges,
+       -- XXX: Is country_code really relevant for WAMOS or just NtS?
+       -- country_code char(2) NOT NULL REFERENCES countries,
+       -- TODO: add relations to stuff provided as enumerations
+       dummy_attrib varchar,
+       "..." varchar
+       -- TODO: add real gauge measurement attributes (DRC 2.1.5)
+       );
+
 --
 -- Bottlenecks
 --