Mercurial > gemma
changeset 917:5b90217aa1bb
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 )