Mercurial > dive4elements > river
diff backend/doc/schema/postgresql-sinfo-uinfo.sql @ 9032:1f63e9d3b0ec
New columns for bed_height, tkh and depth_evolution, a few syntactic corrections for Oracle
author | mschaefer |
---|---|
date | Fri, 27 Apr 2018 17:35:12 +0200 |
parents | ce99d3db9477 |
children | 4c5eeaff554c |
line wrap: on
line diff
--- a/backend/doc/schema/postgresql-sinfo-uinfo.sql Fri Apr 27 11:34:04 2018 +0200 +++ b/backend/doc/schema/postgresql-sinfo-uinfo.sql Fri Apr 27 17:35:12 2018 +0200 @@ -9,20 +9,40 @@ --Add new columns bed_height.sounding_width_info and bed_height.comment -ALTER TABLE bed_height ADD COLUMN sounding_width_info VARCHAR(256); +ALTER TABLE bed_height + ADD sounding_width_info VARCHAR(256), + ADD "comment" VARCHAR(256); COMMENT ON COLUMN bed_height.sounding_width_info IS 'File header line info "ausgewertete Peilbreite"' ; - -ALTER TABLE bed_height ADD COLUMN "comment" VARCHAR(256); COMMENT ON COLUMN bed_height."comment" IS 'File header line info "weitere Bemerkungen"' ; --Add new columns bed_height_values.min_height (Talweg) and bed_height_values.max_height (Kammlage) (same type as existing height column) -ALTER TABLE bed_height_values ADD COLUMN min_height NUMERIC; +ALTER TABLE bed_height_values + ADD min_height NUMERIC, + ADD max_height NUMERIC, + ADD height01 NUMERIC, + ADD height02 NUMERIC, + ADD height03 NUMERIC, + ADD height04 NUMERIC, + ADD height05 NUMERIC, + ADD height06 NUMERIC, + ADD height07 NUMERIC, + ADD height08 NUMERIC, + ADD height09 NUMERIC, + ADD height10 NUMERIC; COMMENT ON COLUMN bed_height_values.min_height IS 'Minimum bed height (Talweg) in m' ; - -ALTER TABLE bed_height_values ADD COLUMN max_height NUMERIC; COMMENT ON COLUMN bed_height_values.max_height IS 'Maximum bed height (Kammlage) in m' ; +COMMENT ON COLUMN bed_height_values.height01 IS 'Bed height of section 1 in m' ; +COMMENT ON COLUMN bed_height_values.height02 IS 'Bed height of section 2 in m' ; +COMMENT ON COLUMN bed_height_values.height03 IS 'Bed height of section 3 in m' ; +COMMENT ON COLUMN bed_height_values.height04 IS 'Bed height of section 4 in m' ; +COMMENT ON COLUMN bed_height_values.height05 IS 'Bed height of section 5 in m' ; +COMMENT ON COLUMN bed_height_values.height06 IS 'Bed height of section 6 in m' ; +COMMENT ON COLUMN bed_height_values.height07 IS 'Bed height of section 7 in m' ; +COMMENT ON COLUMN bed_height_values.height08 IS 'Bed height of section 8 in m' ; +COMMENT ON COLUMN bed_height_values.height09 IS 'Bed height of section 9 in m' ; +COMMENT ON COLUMN bed_height_values.height10 IS 'Bed height of section 10 in m' ; --Bed mobility @@ -185,6 +205,7 @@ day DATE, kmrange_info VARCHAR(32), filename VARCHAR(256) NOT NULL, + groupname VARCHAR(32) NOT NULL CHECK(groupname IN ('messung','berechnung')), sounding_info VARCHAR(64), evaluation_by VARCHAR(256), "comment" VARCHAR(256) @@ -193,6 +214,7 @@ COMMENT ON COLUMN tkh.day IS 'File header line info "Datum"' ; 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' ; +COMMENT ON COLUMN tkh.groupname IS 'Group the file belongs to' ; COMMENT ON COLUMN tkh.sounding_info IS 'File header line info "Peilung"' ; COMMENT ON COLUMN tkh.evaluation_by IS 'File header line info "Auswerter"' ; COMMENT ON COLUMN tkh."comment" IS 'File header line info "weitere Bemerkungen"' ; @@ -287,6 +309,7 @@ curr_glw VARCHAR(64) NOT NULL, old_glw VARCHAR(64) NOT NULL, filename VARCHAR(256) NOT NULL, + groupname VARCHAR(32) NOT NULL CHECK(groupname IN ('aktuell','etappe')), "comment" VARCHAR(256) ); COMMENT ON TABLE depth_evolution IS 'Longitudinal section of the evolution of the flow depth of a river' ; @@ -298,6 +321,7 @@ COMMENT ON COLUMN depth_evolution.curr_glw IS 'File header line info "Aktuelle Wasserspiegellage"' ; COMMENT ON COLUMN depth_evolution.old_glw IS 'File header line info "Historische Wasserspiegellage"' ; COMMENT ON COLUMN depth_evolution.filename IS 'Name without type extension of the imported file' ; +COMMENT ON COLUMN depth_evolution.groupname IS 'Group the file belongs to' ; COMMENT ON COLUMN depth_evolution."comment" IS 'File header line info "weitere Bemerkungen"' ; CREATE SEQUENCE DEPTH_EVOLUTION_ID_SEQ ;