Mercurial > gemma

comparison wamos.sql @ 95:c79fd71ebe06

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Comment out some rather spurious attributes.
author Tom Gottfried <tom@intevation.de>
date Fri, 01 Jun 2018 20:52:03 +0200
parents 611dc09dbcd8
children d036e1bd5f00
comparison
equal deleted inserted replaced
94:611dc09dbcd8 95:c79fd71ebe06
168 -- country_code char(2) NOT NULL REFERENCES countries, 168 -- country_code char(2) NOT NULL REFERENCES countries,
169 -- TODO: add relations to stuff provided as enumerations 169 -- TODO: add relations to stuff provided as enumerations
170 sender varchar NOT NULL, -- "from" attribute from DRC 170 sender varchar NOT NULL, -- "from" attribute from DRC
171 language_code varchar NOT NULL REFERENCES language_codes, 171 language_code varchar NOT NULL REFERENCES language_codes,
172 date_issue timestamp with time zone NOT NULL, 172 date_issue timestamp with time zone NOT NULL,
173 reference_code varchar(4) NOT NULL REFERENCES depth_references, 173 -- reference_code varchar(4) NOT NULL REFERENCES depth_references,
174 -- XXX: Always ZPG? 174 -- XXX: Always ZPG?
175 water_level double precision NOT NULL, 175 water_level double precision NOT NULL,
176 predicted boolean NOT NULL, 176 predicted boolean NOT NULL,
177 is_waterlevel boolean NOT NULL, 177 is_waterlevel boolean NOT NULL,
178 -- XXX: "measure_code" if really only W or Q 178 -- XXX: "measure_code" if really only W or Q
303 rb char(2) NOT NULL REFERENCES countries, -- from rb_lb in interface 303 rb char(2) NOT NULL REFERENCES countries, -- from rb_lb in interface
304 lb char(2) NOT NULL REFERENCES countries, -- from rb_lb in interface 304 lb char(2) NOT NULL REFERENCES countries, -- from rb_lb in interface
305 responsible_country char(2) NOT NULL REFERENCES countries, 305 responsible_country char(2) NOT NULL REFERENCES countries,
306 revisiting_time smallint NOT NULL, 306 revisiting_time smallint NOT NULL,
307 limiting varchar NOT NULL REFERENCES limiting_factors, 307 limiting varchar NOT NULL REFERENCES limiting_factors,
308 surtyp varchar NOT NULL REFERENCES survey_types, 308 -- surtyp varchar NOT NULL REFERENCES survey_types,
309 -- XXX: Also an attribut of sounding result? 309 -- XXX: Also an attribut of sounding result?
310 coverage varchar REFERENCES coverage_types, 310 -- coverage varchar REFERENCES coverage_types,
311 -- XXX: Also an attribut of sounding result? 311 -- XXX: Also an attribut of sounding result?
312 -- CHECK allowed combinations of surtyp and coverage or 312 -- CHECK allowed combinations of surtyp and coverage or
313 -- different model approach? 313 -- different model approach?
314 depth_reference char(3) NOT NULL REFERENCES depth_references, 314 -- depth_reference char(3) NOT NULL REFERENCES depth_references,
315 -- XXX: Also an attribut of sounding result? 315 -- XXX: Also an attribut of sounding result?
316 date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP, 316 date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
317 source_organization varchar NOT NULL, 317 source_organization varchar NOT NULL,
318 -- additional_data xml -- Currently not relevant for WAMOS 318 -- additional_data xml -- Currently not relevant for WAMOS
319 staging_done boolean NOT NULL DEFAULT false 319 staging_done boolean NOT NULL DEFAULT false