Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-minfo.sql @ 5453:303701ab73c6
store name and km of reference gauges in measurement_stations too, as not all are in gauges
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Wed, 27 Mar 2013 12:13:21 +0100 |
| parents | b279f2d4bc78 |
| children | 45c5b8b08ffd |
comparison
equal
deleted
inserted
replaced
| 5452:5287440b57b3 | 5453:303701ab73c6 |
|---|---|
| 285 station NUMBER(38,3) NOT NULL, | 285 station NUMBER(38,3) NOT NULL, |
| 286 range_id NUMBER(38), | 286 range_id NUMBER(38), |
| 287 measurement_type VARCHAR(64) NOT NULL, | 287 measurement_type VARCHAR(64) NOT NULL, |
| 288 riverside VARCHAR(16), | 288 riverside VARCHAR(16), |
| 289 reference_gauge_id NUMBER(38), | 289 reference_gauge_id NUMBER(38), |
| 290 -- store name and km of reference gauges here too, as not all are in gauges | |
| 291 reference_gauge_name VARCHAR(64), | |
| 292 reference_gauge_station NUMBER(38,3), | |
| 290 observation_timerange_id NUMBER(38), | 293 observation_timerange_id NUMBER(38), |
| 291 operator VARCHAR(64), | 294 operator VARCHAR(64), |
| 292 description VARCHAR(512), | 295 description VARCHAR(512), |
| 293 PRIMARY KEY (id), | 296 PRIMARY KEY (id), |
| 294 CONSTRAINT fk_ms_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE, | 297 CONSTRAINT fk_ms_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE, |