Mercurial > gemma

changeset 54:285146e8c9c5

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Align constraints with WSDL (NOT NULL vs. minOccurs).
author Tom Gottfried <tom@intevation.de>
date Wed, 23 May 2018 11:36:47 +0200
parents 6e8d571c720e
children ecb9bb0591c9
files wamos.sql
diffstat 1 files changed, 5 insertions(+), 5 deletions(-) [+]
line wrap: on
line diff
--- a/wamos.sql	Thu May 17 15:52:21 2018 +0200
+++ b/wamos.sql	Wed May 23 11:36:47 2018 +0200
@@ -87,10 +87,10 @@
 
 CREATE TABLE bottlenecks (
        bottleneck_id varchar PRIMARY KEY,
-       fk_g_fid isrs REFERENCES gauges,
+       fk_g_fid isrs NOT NULL REFERENCES gauges,
        -- XXX: DRC references "ch. 3.1.1", which does not exist in document.
-       objnam varchar UNIQUE NOT NULL,
-       nobjnm varchar UNIQUE,
+       objnam varchar,
+       nobjnm varchar,
        stretch isrsrange NOT NULL,
        area geometry(POLYGON, 3146) NOT NULL,
        rb char(2) NOT NULL REFERENCES countries, -- from rb_lb in interface
@@ -100,7 +100,7 @@
        limiting varchar NOT NULL REFERENCES limiting_factors,
        surtyp varchar NOT NULL REFERENCES survey_types,
        -- XXX: Also an attribut of sounding result?
-       coverage varchar NOT NULL REFERENCES coverage_types,
+       coverage varchar REFERENCES coverage_types,
        -- XXX: Also an attribut of sounding result?
        -- CHECK allowed combinations of surtyp and coverage or
        -- different model approach?
@@ -126,7 +126,7 @@
        PRIMARY KEY (bottleneck_id, date_info),
        area geometry(POLYGON, 3146) NOT NULL,
        surtyp varchar NOT NULL REFERENCES survey_types,
-       coverage varchar NOT NULL REFERENCES coverage_types,
+       coverage varchar REFERENCES coverage_types,
        depth_reference char(3) NOT NULL REFERENCES depth_references,
        sounding_data raster NOT NULL
        );