comparison flys-backend/doc/schema/oracle-minfo.sql @ 5475:b6a6d13eec41

backout r5460 to be compatible with r5471 and Oracle database
author Tom Gottfried <tom@intevation.de>
date Wed, 27 Mar 2013 16:26:50 +0100
parents c2bd97cd127f
children 5bb3610b94f7
comparison
equal deleted inserted replaced
5474:3e9bf93dc95c 5475:b6a6d13eec41
289 reference_gauge_id NUMBER(38), 289 reference_gauge_id NUMBER(38),
290 -- store name 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 observation_timerange_id NUMBER(38), 292 observation_timerange_id NUMBER(38),
293 operator VARCHAR(64), 293 operator VARCHAR(64),
294 comment VARCHAR(512), 294 description VARCHAR(512),
295 PRIMARY KEY (id), 295 PRIMARY KEY (id),
296 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,
297 CONSTRAINT fk_ms_range_id FOREIGN KEY (range_id) REFERENCES ranges(id) ON DELETE CASCADE, 297 CONSTRAINT fk_ms_range_id FOREIGN KEY (range_id) REFERENCES ranges(id) ON DELETE CASCADE,
298 CONSTRAINT fk_ms_reference_gauge_id FOREIGN KEY (reference_gauge_id) REFERENCES gauges(id) ON DELETE CASCADE, 298 CONSTRAINT fk_ms_reference_gauge_id FOREIGN KEY (reference_gauge_id) REFERENCES gauges(id) ON DELETE CASCADE,
299 CONSTRAINT fk_ms_observation_timerange_id FOREIGN KEY (observation_timerange_id) REFERENCES time_intervals(id), 299 CONSTRAINT fk_ms_observation_timerange_id FOREIGN KEY (observation_timerange_id) REFERENCES time_intervals(id),

http://dive4elements.wald.intevation.org