Mercurial > gemma

comparison wamos.sql @ 39:830287983657

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Comment: details to clarify riverbed material.
author Tom Gottfried <tom@intevation.de>
date Fri, 04 May 2018 19:12:37 +0200
parents 529319bc3c5b
children 535e57373a93
comparison
equal deleted inserted replaced
38:529319bc3c5b 39:830287983657
53 -- factor when there are many FKs pointing here. 53 -- factor when there are many FKs pointing here.
54 ); 54 );
55 55
56 CREATE TABLE riverbed_materials ( 56 CREATE TABLE riverbed_materials (
57 material varchar PRIMARY KEY 57 material varchar PRIMARY KEY
58 -- XXX: Should this table contain choices from DRC 2.2.3 or
59 -- from IENC Encoding Guide M.4.3, attribute NATSUR?
58 ); 60 );
59 61
60 CREATE TABLE survey_types ( 62 CREATE TABLE survey_types (
61 survey_type varchar PRIMARY KEY 63 survey_type varchar PRIMARY KEY
62 ); 64 );
85 stretch isrsrange NOT NULL, 87 stretch isrsrange NOT NULL,
86 rb_lb varchar, -- XXX: Why two data in one attribute? Why not: 88 rb_lb varchar, -- XXX: Why two data in one attribute? Why not:
87 rb char(2) NOT NULL REFERENCES countries, 89 rb char(2) NOT NULL REFERENCES countries,
88 lb char(2) NOT NULL REFERENCES countries, 90 lb char(2) NOT NULL REFERENCES countries,
89 riverbed varchar NOT NULL REFERENCES riverbed_materials, 91 riverbed varchar NOT NULL REFERENCES riverbed_materials,
90 -- XXX: list of materials differs between IENC Encoding Guide and DRC 92 -- XXX: should be 'natsur' according to IENC Encoding Guide M.4.3
91 responsible_country char(2) NOT NULL REFERENCES countries, 93 responsible_country char(2) NOT NULL REFERENCES countries,
92 revisiting_time smallint NOT NULL, 94 revisiting_time smallint NOT NULL,
93 surtyp varchar NOT NULL REFERENCES survey_types, 95 surtyp varchar NOT NULL REFERENCES survey_types,
94 -- XXX: Not an attribut of sounding result? 96 -- XXX: Not an attribut of sounding result?
95 coverage varchar NOT NULL REFERENCES coverage_types, 97 coverage varchar NOT NULL REFERENCES coverage_types,