Mercurial > gemma
changeset 39:830287983657
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 |
files | wamos.sql |
diffstat | 1 files changed, 3 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/wamos.sql Fri May 04 19:06:29 2018 +0200 +++ b/wamos.sql Fri May 04 19:12:37 2018 +0200 @@ -55,6 +55,8 @@ CREATE TABLE riverbed_materials ( material varchar PRIMARY KEY + -- XXX: Should this table contain choices from DRC 2.2.3 or + -- from IENC Encoding Guide M.4.3, attribute NATSUR? ); CREATE TABLE survey_types ( @@ -87,7 +89,7 @@ rb char(2) NOT NULL REFERENCES countries, lb char(2) NOT NULL REFERENCES countries, riverbed varchar NOT NULL REFERENCES riverbed_materials, - -- XXX: list of materials differs between IENC Encoding Guide and DRC + -- XXX: should be 'natsur' according to IENC Encoding Guide M.4.3 responsible_country char(2) NOT NULL REFERENCES countries, revisiting_time smallint NOT NULL, surtyp varchar NOT NULL REFERENCES survey_types,