Mercurial > gemma
diff schema/gemma.sql @ 3423:6592396f5061
Make revisiting time of a bottleneck optional
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Thu, 23 May 2019 15:33:56 +0200 |
parents | c04b1409a596 |
children | ba0339118d9c |
line wrap: on
line diff
--- a/schema/gemma.sql Thu May 23 15:33:23 2019 +0200 +++ b/schema/gemma.sql Thu May 23 15:33:56 2019 +0200 @@ -485,9 +485,6 @@ -- -- Bottlenecks -- - -- 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 ( id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, bottleneck_id varchar UNIQUE NOT NULL, @@ -504,7 +501,7 @@ rb char(2) REFERENCES countries, -- from rb_lb in interface lb char(2) REFERENCES countries, -- from rb_lb in interface responsible_country char(2) NOT NULL REFERENCES countries, - revisiting_time smallint NOT NULL, + revisiting_time smallint, limiting varchar NOT NULL REFERENCES limiting_factors, -- surtyp varchar NOT NULL REFERENCES survey_types, -- XXX: Also an attribut of sounding result?