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 |