Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-minfo.sql @ 2809:f283212966e8
Finished work on MINFO bed heights (single).
flys-backend/trunk@4221 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Thu, 12 Apr 2012 10:42:46 +0000 |
| parents | 5ac1db5156be |
| children | 04eeb45df27b |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-minfo.sql Wed Apr 11 13:12:52 2012 +0000 +++ b/flys-backend/doc/schema/oracle-minfo.sql Thu Apr 12 10:42:46 2012 +0000 @@ -35,6 +35,7 @@ CREATE TABLE bed_height_single ( id NUMBER(38,0) NOT NULL, + river_id NUMBER(38,0) NOT NULL, year NUMBER(38,0) NOT NULL, sounding_width NUMBER(38,0) NOT NULL, type_id NUMBER(38,0) NOT NULL, @@ -45,6 +46,7 @@ evaluation_by VARCHAR(255), description VARCHAR(255), PRIMARY KEY(id), + CONSTRAINT fk_bed_single_river_id FOREIGN KEY (river_id) REFERENCES rivers(id), CONSTRAINT fk_type FOREIGN KEY (type_id) REFERENCES bed_height_type(id), CONSTRAINT fk_location_system FOREIGN KEY (location_system_id) REFERENCES location_system(id), CONSTRAINT fk_cur_elevation_model FOREIGN KEY (cur_elevation_model_id) REFERENCES elevation_model(id),