Mercurial > gemma
comparison schema/gemma.sql @ 577:e6c9d2da2e20
Backed out changeset f3452ce5c056
Lookup tables will be filled from enumerations in XSD
describing the respective SOAP-interfaces.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 05 Sep 2018 19:13:37 +0200 |
parents | ad07846b09d1 |
children | 642df1164aca |
comparison
equal
deleted
inserted
replaced
576:d5626dd370a4 | 577:e6c9d2da2e20 |
---|---|
134 survey_type varchar PRIMARY KEY | 134 survey_type varchar PRIMARY KEY |
135 ); | 135 ); |
136 | 136 |
137 CREATE TABLE coverage_types ( | 137 CREATE TABLE coverage_types ( |
138 coverage_type varchar PRIMARY KEY | 138 coverage_type varchar PRIMARY KEY |
139 ); | |
140 | |
141 CREATE TABLE limiting_factors ( | |
142 limiting_factor varchar PRIMARY KEY | |
139 ); | 143 ); |
140 | 144 |
141 CREATE TABLE measure_types ( | 145 CREATE TABLE measure_types ( |
142 measure_type varchar PRIMARY KEY | 146 measure_type varchar PRIMARY KEY |
143 ); | 147 ); |
325 FOR EACH ROW EXECUTE PROCEDURE update_date_info() | 329 FOR EACH ROW EXECUTE PROCEDURE update_date_info() |
326 | 330 |
327 -- | 331 -- |
328 -- Bottlenecks | 332 -- Bottlenecks |
329 -- | 333 -- |
330 CREATE TABLE limiting_factors ( | |
331 limiting_factor varchar PRIMARY KEY | |
332 ) | |
333 | |
334 -- XXX: Nullability differs between DRC (attributes marked "O") and WSDL | 334 -- XXX: Nullability differs between DRC (attributes marked "O") and WSDL |
335 -- (minOccurs=0; nillable seems to be set arbitrarily as even bottleneck_id and | 335 -- (minOccurs=0; nillable seems to be set arbitrarily as even bottleneck_id and |
336 -- fk_g_fid (both mandatory, i.e. marked "M" in DRC) have nillable="true" in WSDL) | 336 -- fk_g_fid (both mandatory, i.e. marked "M" in DRC) have nillable="true" in WSDL) |
337 CREATE TABLE bottlenecks ( | 337 CREATE TABLE bottlenecks ( |
338 bottleneck_id varchar PRIMARY KEY, | 338 bottleneck_id varchar PRIMARY KEY, |