Mercurial > gemma

comparison schema/gemma.sql @ 1775:fcb0106ec510

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Gauge measurement import: Added reference_code column.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 11 Jan 2019 12:10:23 +0100
parents 0edebe44067d
children 48791416bea5
comparison
equal deleted inserted replaced
1774:f9ac2d4d2069 1775:fcb0106ec510
272 country_code char(2) NOT NULL REFERENCES countries, 272 country_code char(2) NOT NULL REFERENCES countries,
273 -- TODO: add relations to stuff provided as enumerations 273 -- TODO: add relations to stuff provided as enumerations
274 sender varchar NOT NULL, -- "from" attribute from DRC 274 sender varchar NOT NULL, -- "from" attribute from DRC
275 language_code varchar NOT NULL REFERENCES language_codes, 275 language_code varchar NOT NULL REFERENCES language_codes,
276 date_issue timestamp with time zone NOT NULL, 276 date_issue timestamp with time zone NOT NULL,
277 -- reference_code varchar(4) NOT NULL REFERENCES depth_references, 277 reference_code varchar(4) NOT NULL REFERENCES depth_references,
278 -- XXX: Always ZPG?
279 water_level double precision NOT NULL, 278 water_level double precision NOT NULL,
280 predicted boolean NOT NULL, 279 predicted boolean NOT NULL,
281 is_waterlevel boolean NOT NULL, 280 is_waterlevel boolean NOT NULL,
282 -- XXX: "measure_code" if really only W or Q 281 -- XXX: "measure_code" if really only W or Q
283 -- XXX: Do we need "unit" attribute or can we normalise on import? 282 -- XXX: Do we need "unit" attribute or can we normalise on import?