Mercurial > dive4elements > river
diff backend/doc/schema/postgresql-sinfo-uinfo.sql @ 8990:07dcedddf839
Oracle schema extension added, a few changes in the postgresql schema
author | mschaefer |
---|---|
date | Tue, 10 Apr 2018 16:40:52 +0200 |
parents | 66471a3b3db2 |
children | ce99d3db9477 |
line wrap: on
line diff
--- a/backend/doc/schema/postgresql-sinfo-uinfo.sql Mon Apr 09 09:07:00 2018 +0200 +++ b/backend/doc/schema/postgresql-sinfo-uinfo.sql Tue Apr 10 16:40:52 2018 +0200 @@ -155,7 +155,7 @@ evaluation_by VARCHAR(256), "comment" VARCHAR(256) ); -COMMENT ON TABLE tkh IS 'Longitudinal section of computed Transportkörperhöhe of a river' ; +COMMENT ON TABLE tkh IS 'Longitudinal section of computed Transportkörperhöhe of a river' ; COMMENT ON COLUMN tkh.year IS 'File header line info "Bezugsjahr"' ; COMMENT ON COLUMN tkh.kmrange_info IS 'File header line info "Strecke"' ; COMMENT ON COLUMN tkh.filename IS 'Name without type extension of the imported file' ; @@ -171,7 +171,7 @@ tkh_id NUMERIC(9,0) NOT NULL CONSTRAINT cTkhColumnTkh REFERENCES tkh(id) ON DELETE CASCADE, name VARCHAR(64) NOT NULL ); -COMMENT ON TABLE tkh_column IS 'Longitudinal section of computed Transportkörperhöhe for a waterlevel series' ; +COMMENT ON TABLE tkh_column IS 'Longitudinal section of computed Transportkörperhöhe for a waterlevel series' ; COMMENT ON COLUMN tkh_column.name IS 'Name of the tkh computation column' ; CREATE SEQUENCE TKH_COLUMN_ID_SEQ ; @@ -183,9 +183,9 @@ station NUMERIC(7,3) NOT NULL, tkheight NUMERIC(7,3) ); -COMMENT ON TABLE tkh_values IS 'Transportkörperhöhe of a river station and referenced file column' ; +COMMENT ON TABLE tkh_values IS 'Transportkörperhöhe of a river station and referenced file column' ; COMMENT ON COLUMN tkh_values.station IS 'River km' ; -COMMENT ON COLUMN tkh_values.tkheight IS 'Transportkörperhöhe of a river station computed for a waterlevel in m' ; +COMMENT ON COLUMN tkh_values.tkheight IS 'Transportkörperhöhe of a river station computed for a waterlevel in m' ; CREATE SEQUENCE TKH_VALUES_ID_SEQ ; @@ -326,7 +326,7 @@ CREATE TABLE salix_values ( id NUMERIC(9,0) PRIMARY KEY, - salix_id integer NOT NULL CONSTRAINT cSalixValuesSalix REFERENCES salix(id) ON DELETE CASCADE, + salix_id NUMERIC(9,0) NOT NULL CONSTRAINT cSalixValuesSalix REFERENCES salix(id) ON DELETE CASCADE, station NUMERIC(7,3) NOT NULL, factor NUMERIC(6,2) NOT NULL, mnw_mw_diff NUMERIC(6,2)