Mercurial > dive4elements > river
changeset 7466:5cddf115b27b
Merged
author | Sascha L. Teichmann <teichmann@intevation.de> |
---|---|
date | Wed, 30 Oct 2013 11:59:09 +0100 (2013-10-30) |
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)