Mercurial > dive4elements > river

comparison backend/doc/schema/postgresql-sinfo-uinfo.sql @ 8990:07dcedddf839

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
comparison
equal deleted inserted replaced
8989:2693bfaf503d 8990:07dcedddf839
153 filename VARCHAR(256) NOT NULL, 153 filename VARCHAR(256) NOT NULL,
154 sounding_info VARCHAR(64), 154 sounding_info VARCHAR(64),
155 evaluation_by VARCHAR(256), 155 evaluation_by VARCHAR(256),
156 "comment" VARCHAR(256) 156 "comment" VARCHAR(256)
157 ); 157 );
158 COMMENT ON TABLE tkh IS 'Longitudinal section of computed Transportkörperhöhe of a river' ; 158 COMMENT ON TABLE tkh IS 'Longitudinal section of computed Transportkörperhöhe of a river' ;
159 COMMENT ON COLUMN tkh.year IS 'File header line info "Bezugsjahr"' ; 159 COMMENT ON COLUMN tkh.year IS 'File header line info "Bezugsjahr"' ;
160 COMMENT ON COLUMN tkh.kmrange_info IS 'File header line info "Strecke"' ; 160 COMMENT ON COLUMN tkh.kmrange_info IS 'File header line info "Strecke"' ;
161 COMMENT ON COLUMN tkh.filename IS 'Name without type extension of the imported file' ; 161 COMMENT ON COLUMN tkh.filename IS 'Name without type extension of the imported file' ;
162 COMMENT ON COLUMN tkh.sounding_info IS 'File header line info "Peilung"' ; 162 COMMENT ON COLUMN tkh.sounding_info IS 'File header line info "Peilung"' ;
163 COMMENT ON COLUMN tkh.evaluation_by IS 'File header line info "Auswerter"' ; 163 COMMENT ON COLUMN tkh.evaluation_by IS 'File header line info "Auswerter"' ;
169 CREATE TABLE tkh_column ( 169 CREATE TABLE tkh_column (
170 id NUMERIC(9,0) PRIMARY KEY, 170 id NUMERIC(9,0) PRIMARY KEY,
171 tkh_id NUMERIC(9,0) NOT NULL CONSTRAINT cTkhColumnTkh REFERENCES tkh(id) ON DELETE CASCADE, 171 tkh_id NUMERIC(9,0) NOT NULL CONSTRAINT cTkhColumnTkh REFERENCES tkh(id) ON DELETE CASCADE,
172 name VARCHAR(64) NOT NULL 172 name VARCHAR(64) NOT NULL
173 ); 173 );
174 COMMENT ON TABLE tkh_column IS 'Longitudinal section of computed Transportkörperhöhe for a waterlevel series' ; 174 COMMENT ON TABLE tkh_column IS 'Longitudinal section of computed Transportkörperhöhe for a waterlevel series' ;
175 COMMENT ON COLUMN tkh_column.name IS 'Name of the tkh computation column' ; 175 COMMENT ON COLUMN tkh_column.name IS 'Name of the tkh computation column' ;
176 176
177 CREATE SEQUENCE TKH_COLUMN_ID_SEQ ; 177 CREATE SEQUENCE TKH_COLUMN_ID_SEQ ;
178 178
179 179
181 id NUMERIC(9,0) PRIMARY KEY, 181 id NUMERIC(9,0) PRIMARY KEY,
182 tkh_column_id NUMERIC(9,0) NOT NULL CONSTRAINT cTkhValuesTkhColumn REFERENCES tkh_column(id) ON DELETE CASCADE, 182 tkh_column_id NUMERIC(9,0) NOT NULL CONSTRAINT cTkhValuesTkhColumn REFERENCES tkh_column(id) ON DELETE CASCADE,
183 station NUMERIC(7,3) NOT NULL, 183 station NUMERIC(7,3) NOT NULL,
184 tkheight NUMERIC(7,3) 184 tkheight NUMERIC(7,3)
185 ); 185 );
186 COMMENT ON TABLE tkh_values IS 'Transportkörperhöhe of a river station and referenced file column' ; 186 COMMENT ON TABLE tkh_values IS 'Transportkörperhöhe of a river station and referenced file column' ;
187 COMMENT ON COLUMN tkh_values.station IS 'River km' ; 187 COMMENT ON COLUMN tkh_values.station IS 'River km' ;
188 COMMENT ON COLUMN tkh_values.tkheight IS 'Transportkörperhöhe of a river station computed for a waterlevel in m' ; 188 COMMENT ON COLUMN tkh_values.tkheight IS 'Transportkörperhöhe of a river station computed for a waterlevel in m' ;
189 189
190 CREATE SEQUENCE TKH_VALUES_ID_SEQ ; 190 CREATE SEQUENCE TKH_VALUES_ID_SEQ ;
191 191
192 192
193 CREATE TABLE flow_depth ( 193 CREATE TABLE flow_depth (
324 CREATE SEQUENCE SALIX_ID_SEQ ; 324 CREATE SEQUENCE SALIX_ID_SEQ ;
325 325
326 326
327 CREATE TABLE salix_values ( 327 CREATE TABLE salix_values (
328 id NUMERIC(9,0) PRIMARY KEY, 328 id NUMERIC(9,0) PRIMARY KEY,
329 salix_id integer NOT NULL CONSTRAINT cSalixValuesSalix REFERENCES salix(id) ON DELETE CASCADE, 329 salix_id NUMERIC(9,0) NOT NULL CONSTRAINT cSalixValuesSalix REFERENCES salix(id) ON DELETE CASCADE,
330 station NUMERIC(7,3) NOT NULL, 330 station NUMERIC(7,3) NOT NULL,
331 factor NUMERIC(6,2) NOT NULL, 331 factor NUMERIC(6,2) NOT NULL,
332 mnw_mw_diff NUMERIC(6,2) 332 mnw_mw_diff NUMERIC(6,2)
333 ); 333 );
334 334
http://dive4elements.wald.intevation.org