# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1527089839 -7200
# Node ID ecb9bb0591c944e2c6ca92d292eb33b358acf641
# Parent  285146e8c9c501e6ea60c67a205cc23d98339bcd
Note on spurious nullability.

diff -r 285146e8c9c5 -r ecb9bb0591c9 wamos.sql
--- a/wamos.sql	Wed May 23 11:36:47 2018 +0200
+++ b/wamos.sql	Wed May 23 17:37:19 2018 +0200
@@ -85,6 +85,9 @@
        --   (which would mean a model differing a bit from RIS-Index ideas)
        );
 
+-- XXX: Nullability differs between DRC (attributes marked "O") and WSDL
+-- (minOccurs=0; nillable seems to be set arbitrarily as even bottleneck_id and
+-- fk_g_fid (both mandatory, i.e. marked "M" in DRC) have nillable="true" in WSDL)
 CREATE TABLE bottlenecks (
        bottleneck_id varchar PRIMARY KEY,
        fk_g_fid isrs NOT NULL REFERENCES gauges,