Mercurial > gemma

comparison schema/gemma.sql @ 609:6dc1b586328e

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Sounding results: C&P error ... too much brackets.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Mon, 10 Sep 2018 16:20:32 +0200
parents 255f9a4e747f
children effd22c0ae5a
comparison
equal deleted inserted replaced
608:bc2b7da07d60 609:6dc1b586328e
374 PRIMARY KEY (bottleneck_id, date_info), 374 PRIMARY KEY (bottleneck_id, date_info),
375 area geography(POLYGON, 4326) NOT NULL, 375 area geography(POLYGON, 4326) NOT NULL,
376 surtyp varchar NOT NULL REFERENCES survey_types, 376 surtyp varchar NOT NULL REFERENCES survey_types,
377 coverage varchar REFERENCES coverage_types, 377 coverage varchar REFERENCES coverage_types,
378 depth_reference char(3) NOT NULL REFERENCES depth_references, 378 depth_reference char(3) NOT NULL REFERENCES depth_references,
379 point_cloud geography(MULTIPOINTZ, 4326)), 379 point_cloud geography(MULTIPOINTZ, 4326),
380 -- XXX: We may raster the data later. 380 -- XXX: We may raster the data later.
381 -- sounding_data raster NOT NULL, 381 -- sounding_data raster NOT NULL,
382 staging_done boolean NOT NULL DEFAULT false 382 staging_done boolean NOT NULL DEFAULT false
383 ) 383 )
384 384