Mercurial > dive4elements > river
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) );