comparison flys-backend/doc/schema/oracle-minfo.sql @ 5456:e47c4e9b050e

Schema corrected: measurement_station.reference_gauge_station is not needed
author Tom Gottfried <tom.gottfried@intevation.de>
date Wed, 27 Mar 2013 12:55:57 +0100
parents 45c5b8b08ffd
children c2bd97cd127f
comparison
equal deleted inserted replaced
5455:45c5b8b08ffd 5456:e47c4e9b050e
285 station NUMBER(38,3) NOT NULL, 285 station NUMBER(38,3) NOT NULL,
286 range_id NUMBER(38), 286 range_id NUMBER(38),
287 measurement_type VARCHAR(64) NOT NULL, 287 measurement_type VARCHAR(64) NOT NULL,
288 riverside VARCHAR(16), 288 riverside VARCHAR(16),
289 reference_gauge_id NUMBER(38), 289 reference_gauge_id NUMBER(38),
290 -- store name and km of reference gauges here too, as not all are in gauges 290 -- store name of reference gauges here too, as not all are in gauges
291 reference_gauge_name VARCHAR(64), 291 reference_gauge_name VARCHAR(64),
292 reference_gauge_station NUMBER(38,3),
293 observation_timerange_id NUMBER(38), 292 observation_timerange_id NUMBER(38),
294 operator VARCHAR(64), 293 operator VARCHAR(64),
295 description VARCHAR(512), 294 description VARCHAR(512),
296 PRIMARY KEY (id), 295 PRIMARY KEY (id),
297 CONSTRAINT fk_ms_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE, 296 CONSTRAINT fk_ms_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE,

http://dive4elements.wald.intevation.org