log backend/doc/schema/postgresql-minfo.sql @ 9367:8aa1605e58f1

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.
Wed, 09 Jul 2014 15:56:15 +0200 Tom Gottfried Repair last commit.
Wed, 09 Jul 2014 15:51:31 +0200 Tom Gottfried SCHEMA CHANGE: consistent naming scheme and drop script for sediment load at measurement stations.
Tue, 08 Jul 2014 19:44:54 +0200 Tom Gottfried SCHEMA CHANGE: Added new structure for sediment loads measured at measurement stations.
Tue, 10 Jun 2014 15:11:36 +0200 Tom Gottfried SCHEMA CHANGE: Removed bed height epochs.
Wed, 30 Apr 2014 14:09:53 +0200 Raimund Renkert Added tables for porosity and porosity values to postgres schema.
Tue, 29 Oct 2013 19:59:59 +0100 Tom Gottfried Schema change: add lookup table for sediment yield kinds to have its values documented.
Mon, 12 Aug 2013 18:12:14 +0200 Tom Gottfried fixed syntax errors in Postgres-schema. double-precision
Wed, 31 Jul 2013 11:31:23 +0200 Tom Gottfried merged changes from default into double-precision branch double-precision
Wed, 31 Jul 2013 11:10:11 +0200 Felix Wolfsteller minfo-schema-change/issue1393: add kind column to sediment_yield table.
Tue, 18 Jun 2013 19:32:31 +0200 Tom Gottfried Minimal schema change: allow longer names in discharge zones double-precision
Thu, 16 May 2013 18:03:39 +0200 Tom Gottfried Schema change: there is only one bed height per station at a given point in time
Fri, 03 May 2013 10:31:34 +0200 Tom Gottfried Schema change: make gauges.official_number unique per river as we can have multiple identical gauges for different representations of the same river. Comments and TODOs
Thu, 25 Apr 2013 15:23:37 +0200 Sascha L. Teichmann Rename modules to more fitting names. base flys-backend/doc/schema/postgresql-minfo.sql@683870f52844

http://dive4elements.wald.intevation.org