Mercurial > gemma

comparison wamos.sql @ 55:ecb9bb0591c9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Note on spurious nullability.
author Tom Gottfried <tom@intevation.de>
date Wed, 23 May 2018 17:37:19 +0200
parents 285146e8c9c5
children f378959820be
comparison
equal deleted inserted replaced
54:285146e8c9c5 55:ecb9bb0591c9
83 -- i.e. absolut/not absolut) and DEFAULTs and CHECKs at the FK side. 83 -- i.e. absolut/not absolut) and DEFAULTs and CHECKs at the FK side.
84 -- _ Do not mixup things with different meanings in one table at all 84 -- _ Do not mixup things with different meanings in one table at all
85 -- (which would mean a model differing a bit from RIS-Index ideas) 85 -- (which would mean a model differing a bit from RIS-Index ideas)
86 ); 86 );
87 87
88 -- XXX: Nullability differs between DRC (attributes marked "O") and WSDL
89 -- (minOccurs=0; nillable seems to be set arbitrarily as even bottleneck_id and
90 -- fk_g_fid (both mandatory, i.e. marked "M" in DRC) have nillable="true" in WSDL)
88 CREATE TABLE bottlenecks ( 91 CREATE TABLE bottlenecks (
89 bottleneck_id varchar PRIMARY KEY, 92 bottleneck_id varchar PRIMARY KEY,
90 fk_g_fid isrs NOT NULL REFERENCES gauges, 93 fk_g_fid isrs NOT NULL REFERENCES gauges,
91 -- XXX: DRC references "ch. 3.1.1", which does not exist in document. 94 -- XXX: DRC references "ch. 3.1.1", which does not exist in document.
92 objnam varchar, 95 objnam varchar,