Mercurial > gemma
changeset 46:9106e1510244
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,