changeset 7466:5cddf115b27b

Merged
author Sascha L. Teichmann <teichmann@intevation.de>
date Wed, 30 Oct 2013 11:59:09 +0100
parents 4b29bb2c785f (current diff) 5b5a2cc8210f (diff)
children 6878708ac1ab
files
diffstat 2 files changed, 17 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/backend/doc/schema/oracle-minfo.sql	Wed Oct 30 11:58:57 2013 +0100
+++ b/backend/doc/schema/oracle-minfo.sql	Wed Oct 30 11:59:09 2013 +0100
@@ -250,6 +250,13 @@
     PRIMARY KEY (id)
 );
 
+--lookup table for sediment yield kinds
+CREATE TABLE sediment_yield_kinds (
+    id 	     int PRIMARY KEY NOT NULL,
+    kind     VARCHAR(64) NOT NULL
+);
+INSERT INTO sediment_yield_kinds (id, kind) VALUES (0, 'non-official');
+INSERT INTO sediment_yield_kinds (id, kind) VALUES (1, 'official');
 
 CREATE SEQUENCE SEDIMENT_YIELD_ID_SEQ;
 
@@ -263,6 +270,7 @@
     kind                NUMBER(38,0),
     PRIMARY KEY (id),
     CONSTRAINT fk_sy_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE,
+    CONSTRAINT fk_sy_kind_id FOREIGN KEY (kind) REFERENCES sediment_yield_kinds(id),
     CONSTRAINT fk_sy_grain_fraction_id FOREIGN KEY (grain_fraction_id) REFERENCES grain_fraction(id),
     CONSTRAINT fk_sy_unit_id FOREIGN KEY (unit_id) REFERENCES units(id),
     CONSTRAINT fk_sy_time_interval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id)
--- a/backend/doc/schema/postgresql-minfo.sql	Wed Oct 30 11:58:57 2013 +0100
+++ b/backend/doc/schema/postgresql-minfo.sql	Wed Oct 30 11:59:09 2013 +0100
@@ -251,6 +251,14 @@
 );
 
 
+--lookup table for sediment yield kinds
+CREATE TABLE sediment_yield_kinds (
+    id 	     int PRIMARY KEY NOT NULL,
+    kind     VARCHAR(64) NOT NULL
+);
+INSERT INTO sediment_yield_kinds (id, kind) VALUES (0, 'non-official');
+INSERT INTO sediment_yield_kinds (id, kind) VALUES (1, 'official');
+
 CREATE SEQUENCE SEDIMENT_YIELD_ID_SEQ;
 
 CREATE TABLE sediment_yield (
@@ -263,6 +271,7 @@
     kind                int,
     PRIMARY KEY (id),
     CONSTRAINT fk_sy_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE,
+    CONSTRAINT fk_sy_kind_id FOREIGN KEY (kind) REFERENCES sediment_yield_kinds(id),
     CONSTRAINT fk_sy_grain_fraction_id FOREIGN KEY (grain_fraction_id) REFERENCES grain_fraction(id),
     CONSTRAINT fk_sy_unit_id FOREIGN KEY (unit_id) REFERENCES units(id),
     CONSTRAINT fk_sy_time_interval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id)

http://dive4elements.wald.intevation.org