Mercurial > dive4elements > river
diff 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 |
line wrap: on
line diff
--- a/backend/doc/schema/oracle-minfo.sql Wed Oct 15 14:58:46 2014 +0200 +++ b/backend/doc/schema/oracle-minfo.sql Wed Oct 15 19:20:26 2014 +0200 @@ -309,24 +309,24 @@ CREATE SEQUENCE MEASUREMENT_STATION_ID_SEQ; CREATE TABLE measurement_station ( - id NUMBER(38) NOT NULL, - name VARCHAR(256) NOT NULL, - river_id NUMBER(38) NOT NULL, - station NUMBER(38,3) NOT NULL, - range_id NUMBER(38), - measurement_type VARCHAR(64) NOT NULL, - riverside VARCHAR(16), - reference_gauge_id NUMBER(38), + id int NOT NULL, + range_id int NOT NULL, + reference_gauge_id int, + time_interval_id int, + name VARCHAR2(256 CHAR) NOT NULL, + measurement_type VARCHAR2(64 CHAR) NOT NULL, + riverside VARCHAR2(16 CHAR), -- store name of reference gauges here too, as not all are in gauges - reference_gauge_name VARCHAR(64), - observation_timerange_id NUMBER(38), - operator VARCHAR(64), - description VARCHAR(512), - PRIMARY KEY (id), - CONSTRAINT fk_ms_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE, - CONSTRAINT fk_ms_range_id FOREIGN KEY (range_id) REFERENCES ranges(id) ON DELETE CASCADE, - CONSTRAINT fk_ms_reference_gauge_id FOREIGN KEY (reference_gauge_id) REFERENCES gauges(id) ON DELETE CASCADE, - CONSTRAINT fk_ms_observation_timerange_id FOREIGN KEY (observation_timerange_id) REFERENCES time_intervals(id) + reference_gauge_name VARCHAR2(64 CHAR), + operator VARCHAR2(64 CHAR), + comment VARCHAR2(512 CHAR), + PRIMARY KEY (id), + CONSTRAINT fk_ms_range_id FOREIGN KEY (range_id) + REFERENCES ranges(id) ON DELETE CASCADE, + CONSTRAINT fk_ms_reference_gauge_id FOREIGN KEY (reference_gauge_id) + REFERENCES gauges(id) ON DELETE CASCADE, + CONSTRAINT fk_time_interval_id FOREIGN KEY (time_interval_id) + REFERENCES time_intervals(id) );