Mercurial > gemma

changeset 917:5b90217aa1bb

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fix nullability in sounding results point_cloud represents the actual sounding data and thus should not be NULL. The area is required for processing.
author Tom Gottfried <tom@intevation.de>
date Thu, 04 Oct 2018 12:45:25 +0200
parents 69394644bc73
children 054561be4d68 271561dce2e6
files schema/gemma.sql
diffstat 1 files changed, 2 insertions(+), 4 deletions(-) [+]
line wrap: on
line diff
--- a/schema/gemma.sql	Thu Oct 04 12:28:09 2018 +0200
+++ b/schema/gemma.sql	Thu Oct 04 12:45:25 2018 +0200
@@ -402,13 +402,11 @@
         bottleneck_id varchar NOT NULL REFERENCES bottlenecks,
         date_info date NOT NULL,
         UNIQUE (bottleneck_id, date_info),
-        area geography(POLYGON, 4326),
+        area geography(POLYGON, 4326) NOT NULL,
         surtyp varchar REFERENCES survey_types,
         coverage varchar REFERENCES coverage_types,
         depth_reference char(3) NOT NULL REFERENCES depth_references,
-        point_cloud geography(MULTIPOINTZ, 4326),
-        -- XXX: We may raster the data later.
-        -- sounding_data raster NOT NULL,
+        point_cloud geography(MULTIPOINTZ, 4326) NOT NULL,
         staging_done boolean NOT NULL DEFAULT false
     )