diff backend/doc/schema/oracle-minfo.sql @ 8059:bde5f5ec7c72

SCHEMA CHANGE and Importer: get time intervals of SQ-relations from metalines in sediment load files.
author Tom Gottfried <tom@intevation.de>
date Fri, 18 Jul 2014 18:01:49 +0200
parents fd3a24336e6a
children 5f28aa1be795
line wrap: on
line diff
--- a/backend/doc/schema/oracle-minfo.sql	Fri Jul 18 17:43:27 2014 +0200
+++ b/backend/doc/schema/oracle-minfo.sql	Fri Jul 18 18:01:49 2014 +0200
@@ -275,6 +275,7 @@
     grain_fraction_id   NUMBER(38,0),
     unit_id             NUMBER(38,0) NOT NULL,
     time_interval_id    NUMBER(38,0) NOT NULL,
+    sq_time_interval_id NUMBER(38,0),
     description         VARCHAR(256),
     kind                NUMBER(38,0),
     PRIMARY KEY (id),
@@ -282,7 +283,9 @@
     CONSTRAINT fk_sy_kind_id FOREIGN KEY (kind) REFERENCES sediment_yield_kinds(id),
     CONSTRAINT fk_sy_grain_fraction_id FOREIGN KEY (grain_fraction_id) REFERENCES grain_fraction(id),
     CONSTRAINT fk_sy_unit_id FOREIGN KEY (unit_id) REFERENCES units(id),
-    CONSTRAINT fk_sy_time_interval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id)
+    CONSTRAINT fk_sy_time_interval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id),
+    CONSTRAINT fk_sy_sq_time_interval_id FOREIGN KEY (sq_time_interval_id)
+        REFERENCES time_intervals(id)
 );
 
 

http://dive4elements.wald.intevation.org