Mercurial > gemma
changeset 45:cb25ddf16cbf
Probably attributes of sounding results
but they will likely be provided also by bottleneck interface for other
uses than WAMOS.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Mon, 07 May 2018 22:42:02 +0200 |
parents | dcc3b1134b24 |
children | 9106e1510244 |
files | wamos.sql |
diffstat | 1 files changed, 6 insertions(+), 9 deletions(-) [+] |
line wrap: on
line diff
--- 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 );