changeset 55:ecb9bb0591c9

Note on spurious nullability.
author Tom Gottfried <tom@intevation.de>
date Wed, 23 May 2018 17:37:19 +0200
parents 285146e8c9c5
children f378959820be
files wamos.sql
diffstat 1 files changed, 3 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- 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,