Mercurial > dive4elements > river
diff backend/doc/schema/oracle-minfo.sql @ 7981:45cced06490c facet-metadata
merged with default.
author | Raimund Renkert <rrenkert@intevation.de> |
---|---|
date | Mon, 30 Jun 2014 11:29:45 +0200 |
parents | a88e308567a1 |
children | bcb05a98bb3f |
line wrap: on
line diff
--- a/backend/doc/schema/oracle-minfo.sql Wed May 21 11:43:10 2014 +0200 +++ b/backend/doc/schema/oracle-minfo.sql Mon Jun 30 11:29:45 2014 +0200 @@ -59,27 +59,6 @@ ); -CREATE SEQUENCE BED_HEIGHT_EPOCH_ID_SEQ; - -CREATE TABLE bed_height_epoch ( - id NUMBER(38,0) NOT NULL, - river_id NUMBER(38,0) NOT NULL, - time_interval_id NUMBER(38,0) NOT NULL, - -- sounding_with NUMBER(38,0) NOT NULL, - -- type_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), - evaluation_by VARCHAR(255), - description VARCHAR(255), - PRIMARY KEY(id), - CONSTRAINT fk_time_interval FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id), - CONSTRAINT fk_epoch_cur_elevation_model FOREIGN KEY (cur_elevation_model_id) REFERENCES elevation_model(id), - CONSTRAINT fk_epoch_old_elevation_model FOREIGN KEY (old_elevation_model_id) REFERENCES elevation_model(id), - CONSTRAINT fk_epoch_range FOREIGN KEY (range_id) REFERENCES ranges(id) ON DELETE CASCADE -); - - CREATE SEQUENCE BED_SINGLE_VALUES_ID_SEQ; CREATE TABLE bed_height_single_values ( @@ -97,18 +76,6 @@ ); -CREATE SEQUENCE BED_EPOCH_VALUES_ID_SEQ; - -CREATE TABLE bed_height_epoch_values ( - id NUMBER(38,0) NOT NULL, - bed_height_epoch_id NUMBER(38,0) NOT NULL, - station NUMBER(38,2) NOT NULL, - height NUMBER(38,2), - PRIMARY KEY(id), - CONSTRAINT fk_bed_epoch_values_parent FOREIGN KEY (bed_height_epoch_id) REFERENCES bed_height_epoch(id) ON DELETE CASCADE -); - - CREATE SEQUENCE DEPTHS_ID_SEQ; CREATE TABLE depths (