Mercurial > gemma
diff wamos.sql @ 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 |
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,