Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-minfo.sql @ 6730:c14e17dabf39 double-precision
merged changes from default into double-precision branch
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 31 Jul 2013 11:31:23 +0200 |
| parents | 97145ec4e33c df402b3e0281 |
| children | 5b5a2cc8210f |
comparison
equal
deleted
inserted
replaced
| 6715:5da894daef32 | 6730:c14e17dabf39 |
|---|---|
| 258 river_id NUMBER(38,0) NOT NULL, | 258 river_id NUMBER(38,0) NOT NULL, |
| 259 grain_fraction_id NUMBER(38,0), | 259 grain_fraction_id NUMBER(38,0), |
| 260 unit_id NUMBER(38,0) NOT NULL, | 260 unit_id NUMBER(38,0) NOT NULL, |
| 261 time_interval_id NUMBER(38,0) NOT NULL, | 261 time_interval_id NUMBER(38,0) NOT NULL, |
| 262 description VARCHAR(256), | 262 description VARCHAR(256), |
| 263 kind NUMBER(38,0), | |
| 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) |