Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-minfo.sql @ 2840:71175502d868
Added a parser for sediment yield files; started parsing and store values in db.
flys-backend/trunk@4277 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Thu, 19 Apr 2012 12:48:53 +0000 |
| parents | 6b541d85c5cf |
| children | 6be2bf2492f9 |
comparison
equal
deleted
inserted
replaced
| 2839:163c037f2c7e | 2840:71175502d868 |
|---|---|
| 257 id NUMBER(38,0) NOT NULL, | 257 id NUMBER(38,0) NOT NULL, |
| 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 PRIMARY KEY (id), | 263 PRIMARY KEY (id), |
| 263 CONSTRAINT fk_sy_river_id FOREIGN KEY (river_id) REFERENCES rivers(id), | 264 CONSTRAINT fk_sy_river_id FOREIGN KEY (river_id) REFERENCES rivers(id), |
| 264 CONSTRAINT fk_sy_grain_fraction_id FOREIGN KEY (grain_fraction_id) REFERENCES grain_fraction(id), | 265 CONSTRAINT fk_sy_grain_fraction_id FOREIGN KEY (grain_fraction_id) REFERENCES grain_fraction(id), |
| 265 CONSTRAINT fk_sy_unit_id FOREIGN KEY (unit_id) REFERENCES units(id), | 266 CONSTRAINT fk_sy_unit_id FOREIGN KEY (unit_id) REFERENCES units(id), |
| 266 CONSTRAINT fk_sy_time_interval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id) | 267 CONSTRAINT fk_sy_time_interval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id) |