comparison 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
comparison
equal deleted inserted replaced
8058:fbe3ba5a480e 8059:bde5f5ec7c72
273 id NUMBER(38,0) NOT NULL, 273 id NUMBER(38,0) NOT NULL,
274 river_id NUMBER(38,0) NOT NULL, 274 river_id NUMBER(38,0) NOT NULL,
275 grain_fraction_id NUMBER(38,0), 275 grain_fraction_id NUMBER(38,0),
276 unit_id NUMBER(38,0) NOT NULL, 276 unit_id NUMBER(38,0) NOT NULL,
277 time_interval_id NUMBER(38,0) NOT NULL, 277 time_interval_id NUMBER(38,0) NOT NULL,
278 sq_time_interval_id NUMBER(38,0),
278 description VARCHAR(256), 279 description VARCHAR(256),
279 kind NUMBER(38,0), 280 kind NUMBER(38,0),
280 PRIMARY KEY (id), 281 PRIMARY KEY (id),
281 CONSTRAINT fk_sy_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE, 282 CONSTRAINT fk_sy_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE,
282 CONSTRAINT fk_sy_kind_id FOREIGN KEY (kind) REFERENCES sediment_yield_kinds(id), 283 CONSTRAINT fk_sy_kind_id FOREIGN KEY (kind) REFERENCES sediment_yield_kinds(id),
283 CONSTRAINT fk_sy_grain_fraction_id FOREIGN KEY (grain_fraction_id) REFERENCES grain_fraction(id), 284 CONSTRAINT fk_sy_grain_fraction_id FOREIGN KEY (grain_fraction_id) REFERENCES grain_fraction(id),
284 CONSTRAINT fk_sy_unit_id FOREIGN KEY (unit_id) REFERENCES units(id), 285 CONSTRAINT fk_sy_unit_id FOREIGN KEY (unit_id) REFERENCES units(id),
285 CONSTRAINT fk_sy_time_interval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id) 286 CONSTRAINT fk_sy_time_interval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id),
287 CONSTRAINT fk_sy_sq_time_interval_id FOREIGN KEY (sq_time_interval_id)
288 REFERENCES time_intervals(id)
286 ); 289 );
287 290
288 291
289 CREATE SEQUENCE SEDIMENT_YIELD_VALUES_ID_SEQ; 292 CREATE SEQUENCE SEDIMENT_YIELD_VALUES_ID_SEQ;
290 293

http://dive4elements.wald.intevation.org