Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql-minfo.sql @ 8642:9db1f48bfea9
Enforce strings we rely on.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 27 Mar 2015 18:54:03 +0100 |
| parents | c851d1ea543a |
| children | 1a4ad0d4231a |
comparison
equal
deleted
inserted
replaced
| 8641:c851d1ea543a | 8642:9db1f48bfea9 |
|---|---|
| 323 -- store name of reference gauges here too, as not all are in gauges | 323 -- store name of reference gauges here too, as not all are in gauges |
| 324 reference_gauge_name VARCHAR(64), | 324 reference_gauge_name VARCHAR(64), |
| 325 operator VARCHAR(64), | 325 operator VARCHAR(64), |
| 326 commentary VARCHAR(512), | 326 commentary VARCHAR(512), |
| 327 PRIMARY KEY (id), | 327 PRIMARY KEY (id), |
| 328 CHECK(measurement_type IN ('Geschiebe', 'Schwebstoff')), | |
| 328 CONSTRAINT fk_ms_range_id FOREIGN KEY (range_id) | 329 CONSTRAINT fk_ms_range_id FOREIGN KEY (range_id) |
| 329 REFERENCES ranges(id) ON DELETE CASCADE, | 330 REFERENCES ranges(id) ON DELETE CASCADE, |
| 330 CONSTRAINT fk_ms_reference_gauge_id FOREIGN KEY (reference_gauge_id) | 331 CONSTRAINT fk_ms_reference_gauge_id FOREIGN KEY (reference_gauge_id) |
| 331 REFERENCES gauges(id) ON DELETE CASCADE, | 332 REFERENCES gauges(id) ON DELETE CASCADE, |
| 332 CONSTRAINT fk_time_interval_id FOREIGN KEY (time_interval_id) | 333 CONSTRAINT fk_time_interval_id FOREIGN KEY (time_interval_id) |