Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql-minfo.sql @ 6791:dd5355775ce1 longitudinal-symmetry
merge changes from default into longitudinal-symmetrie branch and make it build
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 07 Aug 2013 18:53:15 +0200 |
| parents | df402b3e0281 |
| children | c14e17dabf39 |
comparison
equal
deleted
inserted
replaced
| 6518:1a7f5d09b9d8 | 6791:dd5355775ce1 |
|---|---|
| 258 river_id int NOT NULL, | 258 river_id int NOT NULL, |
| 259 grain_fraction_id int, | 259 grain_fraction_id int, |
| 260 unit_id int NOT NULL, | 260 unit_id int NOT NULL, |
| 261 time_interval_id int NOT NULL, | 261 time_interval_id int NOT NULL, |
| 262 description VARCHAR(256), | 262 description VARCHAR(256), |
| 263 kind int, | |
| 263 PRIMARY KEY (id), | 264 PRIMARY KEY (id), |
| 264 CONSTRAINT fk_sy_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE, | 265 CONSTRAINT fk_sy_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE, |
| 265 CONSTRAINT fk_sy_grain_fraction_id FOREIGN KEY (grain_fraction_id) REFERENCES grain_fraction(id), | 266 CONSTRAINT fk_sy_grain_fraction_id FOREIGN KEY (grain_fraction_id) REFERENCES grain_fraction(id), |
| 266 CONSTRAINT fk_sy_unit_id FOREIGN KEY (unit_id) REFERENCES units(id), | 267 CONSTRAINT fk_sy_unit_id FOREIGN KEY (unit_id) REFERENCES units(id), |
| 267 CONSTRAINT fk_sy_time_interval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id) | 268 CONSTRAINT fk_sy_time_interval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id) |