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)

http://dive4elements.wald.intevation.org