Mercurial > gemma

comparison schema/gemma.sql @ 2863:e2d362589ce6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
gemma.sql removing trailing comma
author Thomas Junk <thomas.junk@intevation.de>
date Fri, 29 Mar 2019 11:27:01 +0100
parents b8972e4671fa
children 96781e519952 cf295096234e
comparison
equal deleted inserted replaced
2862:d37c87f8d79d 2863:e2d362589ce6
335 value_min double precision, -- XXX: NOT NULL if predicted? 335 value_min double precision, -- XXX: NOT NULL if predicted?
336 value_max double precision, -- XXX: NOT NULL if predicted? 336 value_max double precision, -- XXX: NOT NULL if predicted?
337 --- TODO: Add a double range type for checking? 337 --- TODO: Add a double range type for checking?
338 date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP, 338 date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
339 source_organization varchar NOT NULL, -- "originator" 339 source_organization varchar NOT NULL, -- "originator"
340 staging_done boolean NOT NULL DEFAULT false, 340 staging_done boolean NOT NULL DEFAULT false
341 ) 341 )
342 -- Constraints are conditional for gauge_measurements, as they 342 -- Constraints are conditional for gauge_measurements, as they
343 -- differ between predicted values and measured ones. PG does not 343 -- differ between predicted values and measured ones. PG does not
344 -- have real conditional unique constraints, but we can use unique 344 -- have real conditional unique constraints, but we can use unique
345 -- indeces for that. 345 -- indeces for that.