Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-minfo.sql @ 5448:b279f2d4bc78
SCHEMA CHANGE: fixed constraints in MINFO and removed obsolete column
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Wed, 27 Mar 2013 10:25:45 +0100 |
| parents | 7c1dd9c3f6bd |
| children | 303701ab73c6 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-minfo.sql Wed Mar 27 10:09:23 2013 +0100 +++ b/flys-backend/doc/schema/oracle-minfo.sql Wed Mar 27 10:25:45 2013 +0100 @@ -40,13 +40,13 @@ CREATE TABLE bed_height_single ( id NUMBER(38,0) NOT NULL, river_id NUMBER(38,0) NOT NULL, - year NUMBER(38,0) NOT NULL, - sounding_width NUMBER(38,0) NOT NULL, + year NUMBER(38,0), + sounding_width NUMBER(38,0), type_id NUMBER(38,0) NOT NULL, location_system_id NUMBER(38,0) NOT NULL, cur_elevation_model_id NUMBER(38,0) NOT NULL, old_elevation_model_id NUMBER(38,0), - range_id NUMBER(38,0) NOT NULL, + range_id NUMBER(38,0), evaluation_by VARCHAR(255), description VARCHAR(255), PRIMARY KEY(id), @@ -69,7 +69,7 @@ -- type_id NUMBER(38,0) NOT NULL, cur_elevation_model_id NUMBER(38,0) NOT NULL, old_elevation_model_id NUMBER(38,0), - range_id NUMBER(38,0) NOT NULL, + range_id NUMBER(38,0), evaluation_by VARCHAR(255), description VARCHAR(255), PRIMARY KEY(id), @@ -283,7 +283,7 @@ name VARCHAR(256) NOT NULL, river_id NUMBER(38) NOT NULL, station NUMBER(38,3) NOT NULL, - range_id NUMBER(38) NOT NULL, + range_id NUMBER(38), measurement_type VARCHAR(64) NOT NULL, riverside VARCHAR(16), reference_gauge_id NUMBER(38), @@ -318,7 +318,6 @@ id NUMBER(38,0) NOT NULL, sq_relation_id NUMBER(38,0) NOT NULL, measurement_station_id NUMBER(38,0) NOT NULL, - parameter VARCHAR(16) NOT NULL, fraction VARCHAR(32) NOT NULL, a NUMBER(38,20) NOT NULL, b NUMBER(38,20) NOT NULL, @@ -330,5 +329,5 @@ cduan NUMBER(38,20), PRIMARY KEY (id), CONSTRAINT fk_sqr_id FOREIGN KEY (sq_relation_id) REFERENCES sq_relation(id), - CONSTRAINT fk_mstation_id FOREIGN KEY (m_station_id) REFERENCES measurement_station(id) + CONSTRAINT fk_mstation_id FOREIGN KEY (measurement_station_id) REFERENCES measurement_station(id) );