Mercurial > gemma

comparison schema/gemma.sql @ 5304:6cf4fdaa93f9 zpg-exception

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added new ZPG exception column to sounding result table.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 19 May 2021 16:48:04 +0200
parents f11b9b50fcc9
children 4a6feb5d3727 ac1986c23889
comparison
equal deleted inserted replaced
5303:da04fa72cee8 5304:6cf4fdaa93f9
796 area geography(POLYGON, 4326) NOT NULL 796 area geography(POLYGON, 4326) NOT NULL
797 CHECK(ST_IsValid(CAST(area AS geometry))), 797 CHECK(ST_IsValid(CAST(area AS geometry))),
798 surtyp varchar REFERENCES survey_types, 798 surtyp varchar REFERENCES survey_types,
799 coverage varchar REFERENCES coverage_types, 799 coverage varchar REFERENCES coverage_types,
800 depth_reference varchar NOT NULL, -- REFERENCES depth_references, 800 depth_reference varchar NOT NULL, -- REFERENCES depth_references,
801 zpg_exception bool NOT NULL DEFAULT FALSE, -- Found no LDC in ZPG case.
801 octree_checksum varchar, 802 octree_checksum varchar,
802 octree_index bytea, 803 octree_index bytea,
803 mesh_checksum varchar, 804 mesh_checksum varchar,
804 mesh_index bytea, 805 mesh_index bytea,
805 staging_done boolean NOT NULL DEFAULT false 806 staging_done boolean NOT NULL DEFAULT false