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, |