Mercurial > gemma
changeset 72:158f776732c7
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 --