Mercurial > gemma
comparison schema/gemma.sql @ 5340:ac1986c23889 extented-report
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 |