Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-minfo.sql @ 8412:17db08570637
SCHEMA CHANGE: removed superfluous columns station and river_id from measurement_stations and adapted other components accordingly.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 15 Oct 2014 19:20:26 +0200 |
parents | 5f28aa1be795 |
children | ffbeffe2d266 |
comparison
equal
deleted
inserted
replaced
8411:b8c6cb36607e | 8412:17db08570637 |
---|---|
307 ); | 307 ); |
308 | 308 |
309 | 309 |
310 CREATE SEQUENCE MEASUREMENT_STATION_ID_SEQ; | 310 CREATE SEQUENCE MEASUREMENT_STATION_ID_SEQ; |
311 CREATE TABLE measurement_station ( | 311 CREATE TABLE measurement_station ( |
312 id NUMBER(38) NOT NULL, | 312 id int NOT NULL, |
313 name VARCHAR(256) NOT NULL, | 313 range_id int NOT NULL, |
314 river_id NUMBER(38) NOT NULL, | 314 reference_gauge_id int, |
315 station NUMBER(38,3) NOT NULL, | 315 time_interval_id int, |
316 range_id NUMBER(38), | 316 name VARCHAR2(256 CHAR) NOT NULL, |
317 measurement_type VARCHAR(64) NOT NULL, | 317 measurement_type VARCHAR2(64 CHAR) NOT NULL, |
318 riverside VARCHAR(16), | 318 riverside VARCHAR2(16 CHAR), |
319 reference_gauge_id NUMBER(38), | |
320 -- store name of reference gauges here too, as not all are in gauges | 319 -- store name of reference gauges here too, as not all are in gauges |
321 reference_gauge_name VARCHAR(64), | 320 reference_gauge_name VARCHAR2(64 CHAR), |
322 observation_timerange_id NUMBER(38), | 321 operator VARCHAR2(64 CHAR), |
323 operator VARCHAR(64), | 322 comment VARCHAR2(512 CHAR), |
324 description VARCHAR(512), | 323 PRIMARY KEY (id), |
325 PRIMARY KEY (id), | 324 CONSTRAINT fk_ms_range_id FOREIGN KEY (range_id) |
326 CONSTRAINT fk_ms_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE, | 325 REFERENCES ranges(id) ON DELETE CASCADE, |
327 CONSTRAINT fk_ms_range_id FOREIGN KEY (range_id) REFERENCES ranges(id) ON DELETE CASCADE, | 326 CONSTRAINT fk_ms_reference_gauge_id FOREIGN KEY (reference_gauge_id) |
328 CONSTRAINT fk_ms_reference_gauge_id FOREIGN KEY (reference_gauge_id) REFERENCES gauges(id) ON DELETE CASCADE, | 327 REFERENCES gauges(id) ON DELETE CASCADE, |
329 CONSTRAINT fk_ms_observation_timerange_id FOREIGN KEY (observation_timerange_id) REFERENCES time_intervals(id) | 328 CONSTRAINT fk_time_interval_id FOREIGN KEY (time_interval_id) |
329 REFERENCES time_intervals(id) | |
330 ); | 330 ); |
331 | 331 |
332 | 332 |
333 CREATE SEQUENCE SEDIMENT_LOAD_ID_SEQ; | 333 CREATE SEQUENCE SEDIMENT_LOAD_ID_SEQ; |
334 | 334 |