log backend/doc/schema/postgresql-minfo.sql @ 8997:d5802f22e4f5

age author description
Tue, 03 Apr 2018 08:26:54 +0200 mschaefer Datatype changes from rev 8942 reverted
Tue, 13 Mar 2018 09:42:41 +0100 mschaefer Same data types, precision and scale as in Oracle (as far as possible)
Fri, 17 Apr 2015 14:55:42 +0200 Tom Gottfried (issue1750) There can be only one SQ-relation of a parameter for a time range (given by sq_relation_id) per station and some other attributes might be null.
Wed, 08 Apr 2015 18:15:55 +0200 Tom Gottfried (issue1763) Use more distinct constraint names and adapt drop-script.
Fri, 27 Mar 2015 18:54:03 +0100 Tom Gottfried Enforce strings we rely on.
Fri, 27 Mar 2015 17:42:27 +0100 Tom Gottfried SCHEMA CHANGE: Remove unnecessary direct relation of sq_relation with rivers.
Mon, 16 Feb 2015 11:48:05 +0100 Tom Gottfried Meta-data on sounding width associated to bed heights is redundant to real data associated to values.
Mon, 16 Feb 2015 11:08:33 +0100 Tom Gottfried Bed heights are just bed heights since a while ('single' is obsolete).
Mon, 16 Feb 2015 09:00:08 +0100 Tom Gottfried Morphological width imported and stored with heights is redundant to table morphologic_width.
Wed, 15 Oct 2014 19:48:20 +0200 Tom Gottfried SCHEMA CHANGE: 'comment' is not acceptable as column name for Oracle.
Wed, 15 Oct 2014 19:20:26 +0200 Tom Gottfried SCHEMA CHANGE: removed superfluous columns station and river_id from measurement_stations and adapted other components accordingly.
Wed, 06 Aug 2014 19:17:12 +0200 Tom Gottfried SCHEMA CHANGE: rename database tables from yield to load_ls according to respective classes.
Fri, 18 Jul 2014 18:01:49 +0200 Tom Gottfried SCHEMA CHANGE and Importer: get time intervals of SQ-relations from metalines in sediment load files.
Mon, 14 Jul 2014 15:36:44 +0200 Tom Gottfried SCHEMA CHANGE and Importer (only longitudinal section data so far): only grain fractions given now in schema are valid. We are handling sediment loads, not yields.

http://dive4elements.wald.intevation.org