Mercurial > gemma

comparison schema/gemma.sql @ 5340:ac1986c23889 extented-report

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merged default into extented-report branch.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 17 Jun 2021 20:48:24 +0200
parents eec88a166251 6cf4fdaa93f9
children 18969a4d31b6
comparison
equal deleted inserted replaced
5339:7365efe9f67d 5340:ac1986c23889
798 area geography(POLYGON, 4326) NOT NULL 798 area geography(POLYGON, 4326) NOT NULL
799 CHECK(ST_IsValid(CAST(area AS geometry))), 799 CHECK(ST_IsValid(CAST(area AS geometry))),
800 surtyp varchar REFERENCES survey_types, 800 surtyp varchar REFERENCES survey_types,
801 coverage varchar REFERENCES coverage_types, 801 coverage varchar REFERENCES coverage_types,
802 depth_reference varchar NOT NULL, -- REFERENCES depth_references, 802 depth_reference varchar NOT NULL, -- REFERENCES depth_references,
803 zpg_exception bool NOT NULL DEFAULT FALSE, -- Found no LDC in ZPG case.
803 octree_checksum varchar, 804 octree_checksum varchar,
804 octree_index bytea, 805 octree_index bytea,
805 mesh_checksum varchar, 806 mesh_checksum varchar,
806 mesh_index bytea, 807 mesh_index bytea,
807 staging_done boolean NOT NULL DEFAULT false 808 staging_done boolean NOT NULL DEFAULT false