Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-minfo.sql @ 2807:5ac1db5156be
Some oracle db schema adaptions specific to bed heights in MINFO.
flys-backend/trunk@4215 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Wed, 11 Apr 2012 13:09:46 +0000 |
| parents | a55b7b35cc3a |
| children | f283212966e8 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-minfo.sql Wed Apr 11 09:30:04 2012 +0000 +++ b/flys-backend/doc/schema/oracle-minfo.sql Wed Apr 11 13:09:46 2012 +0000 @@ -36,8 +36,9 @@ CREATE TABLE bed_height_single ( id NUMBER(38,0) NOT NULL, year NUMBER(38,0) NOT NULL, - sounding_with NUMBER(38,0) NOT NULL, + sounding_width NUMBER(38,0) NOT NULL, type_id NUMBER(38,0) NOT NULL, + location_system_id NUMBER(38,0) NOT NULL, cur_elevation_model_id NUMBER(38,0) NOT NULL, old_elevation_model_id NUMBER(38,0), range_id NUMBER(38,0) NOT NULL, @@ -45,6 +46,7 @@ description VARCHAR(255), PRIMARY KEY(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), CONSTRAINT fk_old_elevation_model FOREIGN KEY (old_elevation_model_id) REFERENCES elevation_model(id), CONSTRAINT fk_range FOREIGN KEY (range_id) REFERENCES ranges(id) @@ -80,6 +82,7 @@ height NUMBER(38,2), uncertainty NUMBER(38,2), data_gap NUMBER(38,2) NOT NULL, + sounding_width NUMBER(38,2) NOT NULL, width NUMBER(38,2) NOT NULL, PRIMARY KEY(id), CONSTRAINT fk_bed_single_values_parent FOREIGN KEY (bed_height_single_id) REFERENCES bed_height_single(id)