Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-minfo.sql @ 2817:8979f2294af9
Finished parsing MINFO specific sediment density.
flys-backend/trunk@4234 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Fri, 13 Apr 2012 11:45:29 +0000 |
| parents | 70b4a31a3306 |
| children | 25ed1f18fcc4 |
comparison
equal
deleted
inserted
replaced
| 2816:70b4a31a3306 | 2817:8979f2294af9 |
|---|---|
| 121 CREATE TABLE sediment_density ( | 121 CREATE TABLE sediment_density ( |
| 122 id NUMBER(38,0) NOT NULL, | 122 id NUMBER(38,0) NOT NULL, |
| 123 river_id NUMBER(38,0) NOT NULL, | 123 river_id NUMBER(38,0) NOT NULL, |
| 124 depth_id NUMBER(38,0) NOT NULL, | 124 depth_id NUMBER(38,0) NOT NULL, |
| 125 unit_id NUMBER(38,0) NOT NULL, | 125 unit_id NUMBER(38,0) NOT NULL, |
| 126 description VARCHAR(256), | |
| 126 PRIMARY KEY(id), | 127 PRIMARY KEY(id), |
| 127 CONSTRAINT fk_sd_river_id FOREIGN KEY (river_id) REFERENCES rivers(id), | 128 CONSTRAINT fk_sd_river_id FOREIGN KEY (river_id) REFERENCES rivers(id), |
| 128 CONSTRAINT fk_sd_depth_id FOREIGN KEY (depth_id) REFERENCES depths(id), | 129 CONSTRAINT fk_sd_depth_id FOREIGN KEY (depth_id) REFERENCES depths(id), |
| 129 CONSTRAINT fk_sd_unit_id FOREIGN KEY (unit_id) REFERENCES units(id) | 130 CONSTRAINT fk_sd_unit_id FOREIGN KEY (unit_id) REFERENCES units(id) |
| 130 ); | 131 ); |