Mercurial > gemma
changeset 95:c79fd71ebe06
Comment out some rather spurious attributes.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 01 Jun 2018 20:52:03 +0200 |
parents | 611dc09dbcd8 |
children | d036e1bd5f00 |
files | wamos.sql |
diffstat | 1 files changed, 4 insertions(+), 4 deletions(-) [+] |
line wrap: on
line diff
--- a/wamos.sql Fri Jun 01 20:43:06 2018 +0200 +++ b/wamos.sql Fri Jun 01 20:52:03 2018 +0200 @@ -170,7 +170,7 @@ sender varchar NOT NULL, -- "from" attribute from DRC language_code varchar NOT NULL REFERENCES language_codes, date_issue timestamp with time zone NOT NULL, - reference_code varchar(4) NOT NULL REFERENCES depth_references, + -- reference_code varchar(4) NOT NULL REFERENCES depth_references, -- XXX: Always ZPG? water_level double precision NOT NULL, predicted boolean NOT NULL, @@ -305,13 +305,13 @@ responsible_country char(2) NOT NULL REFERENCES countries, revisiting_time smallint NOT NULL, limiting varchar NOT NULL REFERENCES limiting_factors, - surtyp varchar NOT NULL REFERENCES survey_types, + -- surtyp varchar NOT NULL REFERENCES survey_types, -- XXX: Also an attribut of sounding result? - coverage varchar REFERENCES coverage_types, + -- coverage varchar REFERENCES coverage_types, -- XXX: Also an attribut of sounding result? -- CHECK allowed combinations of surtyp and coverage or -- different model approach? - depth_reference char(3) NOT NULL REFERENCES depth_references, + -- depth_reference char(3) NOT NULL REFERENCES depth_references, -- XXX: Also an attribut of sounding result? date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP, source_organization varchar NOT NULL,