Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-minfo.sql @ 5472:d7bb32f95220
merged.
author | Raimund Renkert <rrenkert@intevation.de> |
---|---|
date | Wed, 27 Mar 2013 15:59:30 +0100 |
parents | c2bd97cd127f |
children | b6a6d13eec41 |
comparison
equal
deleted
inserted
replaced
5471:de3c77d35fef | 5472:d7bb32f95220 |
---|---|
289 reference_gauge_id int, | 289 reference_gauge_id int, |
290 -- store name 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 observation_timerange_id int, | 292 observation_timerange_id int, |
293 operator VARCHAR(64), | 293 operator VARCHAR(64), |
294 description VARCHAR(512), | 294 comment VARCHAR(512), |
295 PRIMARY KEY (id), | 295 PRIMARY KEY (id), |
296 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, |
297 CONSTRAINT fk_ms_range_id FOREIGN KEY (range_id) REFERENCES ranges(id) ON DELETE CASCADE, | 297 CONSTRAINT fk_ms_range_id FOREIGN KEY (range_id) REFERENCES ranges(id) ON DELETE CASCADE, |
298 CONSTRAINT fk_ms_reference_gauge_id FOREIGN KEY (reference_gauge_id) REFERENCES gauges(id) ON DELETE CASCADE, | 298 CONSTRAINT fk_ms_reference_gauge_id FOREIGN KEY (reference_gauge_id) REFERENCES gauges(id) ON DELETE CASCADE, |
299 CONSTRAINT fk_ms_observation_timerange_id FOREIGN KEY (observation_timerange_id) REFERENCES time_intervals(id), | 299 CONSTRAINT fk_ms_observation_timerange_id FOREIGN KEY (observation_timerange_id) REFERENCES time_intervals(id), |