diff backend/doc/schema/postgresql-minfo.sql @ 7924:a88e308567a1

SCHEMA CHANGE: Removed bed height epochs.
author "Tom Gottfried <tom@intevation.de>"
date Tue, 10 Jun 2014 15:11:36 +0200
parents 3f6b9fae1637
children bcb05a98bb3f
line wrap: on
line diff
--- a/backend/doc/schema/postgresql-minfo.sql	Tue Jun 10 12:51:08 2014 +0200
+++ b/backend/doc/schema/postgresql-minfo.sql	Tue Jun 10 15:11:36 2014 +0200
@@ -59,27 +59,6 @@
 );
 
 
-CREATE SEQUENCE BED_HEIGHT_EPOCH_ID_SEQ;
-
-CREATE TABLE bed_height_epoch (
-    id                      int NOT NULL,
-    river_id                int NOT NULL,
-    time_interval_id        int NOT NULL,
-    -- sounding_width           int,
-    -- type_id                 int NOT NULL,
-    cur_elevation_model_id  int NOT NULL,
-    old_elevation_model_id  int,
-    range_id                int,
-    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                      int NOT NULL,
-    bed_height_epoch_id     int NOT NULL,
-    station                 NUMERIC NOT NULL,
-    height                  NUMERIC,
-    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 (

http://dive4elements.wald.intevation.org