# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1525725722 -7200
# Node ID cb25ddf16cbf3861eaaad6347f35ebc0bec21393
# Parent  dcc3b1134b24ce8cfad165cc425fe08fd4499999
Probably attributes of sounding results

but they will likely be provided also by bottleneck interface for other
uses than WAMOS.

diff -r dcc3b1134b24 -r cb25ddf16cbf wamos.sql
--- a/wamos.sql	Mon May 07 22:31:12 2018 +0200
+++ b/wamos.sql	Mon May 07 22:42:02 2018 +0200
@@ -97,14 +97,14 @@
        responsible_country char(2) NOT NULL REFERENCES countries,
        revisiting_time smallint NOT NULL,
        surtyp varchar NOT NULL REFERENCES survey_types,
-       -- XXX: Not an attribut of sounding result?
+       -- XXX: Also an attribut of sounding result?
        coverage varchar NOT NULL REFERENCES coverage_types,
-       -- XXX: Not an attribut of sounding result?
+       -- XXX: Also an attribut of sounding result?
        -- CHECK allowed combinations of surtyp and coverage or
        -- different model approach?
        limiting varchar NOT NULL REFERENCES limiting_factors,
        depth_reference char(3) NOT NULL REFERENCES depth_references,
-       -- XXX: Not an attribut of sounding result?
+       -- XXX: Also an attribut of sounding result?
        date_info timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        source_organization varchar NOT NULL,
        additional_data xml -- XXX: What is that really for?
@@ -119,18 +119,15 @@
        PRIMARY KEY (bottleneck_id, riverbed)
        );
 
-
-CREATE TABLE vertical_references (
-       vertical_reference varchar PRIMARY KEY
-       );
-
 CREATE TABLE sounding_results (
        bottleneck_id varchar NOT NULL REFERENCES bottlenecks,
        date_info date NOT NULL,
        PRIMARY KEY (bottleneck_id, date_info),
        area int, -- XX: Check SRS/test data what this should be
        type int, -- XX: Check SRS/test data what this should be
-       vertical_reference varchar NOT NULL REFERENCES vertical_references,
+       surtyp varchar NOT NULL REFERENCES survey_types,
+       coverage varchar NOT NULL REFERENCES coverage_types,
+       depth_reference char(3) NOT NULL REFERENCES depth_references,
        sounding_data raster NOT NULL
        );