Mercurial > gemma

comparison schema/gemma.sql @ 3632:943c454d5633 single-beam

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merged default into single-beam branch.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 11 Jun 2019 14:46:14 +0200
parents 3012d0b3badc
children 02951a62e8c6
comparison
equal deleted inserted replaced
3623:1973fa69b2bb 3632:943c454d5633
535 UNIQUE (bottleneck_id, date_info), 535 UNIQUE (bottleneck_id, date_info),
536 area geography(POLYGON, 4326) NOT NULL 536 area geography(POLYGON, 4326) NOT NULL
537 CHECK(ST_IsValid(CAST(area AS geometry))), 537 CHECK(ST_IsValid(CAST(area AS geometry))),
538 surtyp varchar REFERENCES survey_types, 538 surtyp varchar REFERENCES survey_types,
539 coverage varchar REFERENCES coverage_types, 539 coverage varchar REFERENCES coverage_types,
540 depth_reference varchar(4) NOT NULL, -- REFERENCES depth_references, 540 depth_reference varchar NOT NULL, -- REFERENCES depth_references,
541 octree_checksum varchar, 541 octree_checksum varchar,
542 octree_index bytea, 542 octree_index bytea,
543 staging_done boolean NOT NULL DEFAULT false 543 staging_done boolean NOT NULL DEFAULT false
544 ) 544 )
545 545