Mercurial > gemma

changeset 46:9106e1510244

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Tweak ER diagramm.
author Tom Gottfried <tom@intevation.de>
date Mon, 07 May 2018 22:45:54 +0200
parents cb25ddf16cbf
children a03ff9076969
files wamos.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/wamos.sql	Mon May 07 22:42:02 2018 +0200
+++ b/wamos.sql	Mon May 07 22:45:54 2018 +0200
@@ -96,13 +96,13 @@
        lb char(2) NOT NULL REFERENCES countries, -- from rb_lb in interface
        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,
        -- XXX: Also an attribut of sounding result?
        coverage varchar NOT NULL REFERENCES coverage_types,
        -- 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: Also an attribut of sounding result?
        date_info timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,