Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-minfo.sql @ 5456:e47c4e9b050e
Schema corrected: measurement_station.reference_gauge_station is not needed
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Wed, 27 Mar 2013 12:55:57 +0100 |
| parents | 45c5b8b08ffd |
| children | c2bd97cd127f |
comparison
equal
deleted
inserted
replaced
| 5455:45c5b8b08ffd | 5456:e47c4e9b050e |
|---|---|
| 285 station NUMERIC NOT NULL, | 285 station NUMERIC NOT NULL, |
| 286 range_id int, | 286 range_id int, |
| 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 int, | 289 reference_gauge_id int, |
| 290 -- store name and km of reference gauges here too, as not all are in gauges | 290 -- store name of reference gauges here too, as not all are in gauges |
| 291 reference_gauge_name VARCHAR(64), | 291 reference_gauge_name VARCHAR(64), |
| 292 reference_gauge_station NUMERIC, | |
| 293 observation_timerange_id int, | 292 observation_timerange_id int, |
| 294 operator VARCHAR(64), | 293 operator VARCHAR(64), |
| 295 description VARCHAR(512), | 294 description VARCHAR(512), |
| 296 PRIMARY KEY (id), | 295 PRIMARY KEY (id), |
| 297 CONSTRAINT fk_ms_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE, | 296 CONSTRAINT fk_ms_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE, |