log backend/doc/schema/postgresql-minfo.sql @ 9405:34cd4faf43f4

age author description
2018-04-03 mschaefer Datatype changes from rev 8942 reverted
2018-03-13 mschaefer Same data types, precision and scale as in Oracle (as far as possible)
2015-04-17 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.
2015-04-08 Tom Gottfried (issue1763) Use more distinct constraint names and adapt drop-script.
2015-03-27 Tom Gottfried Enforce strings we rely on.
2015-03-27 Tom Gottfried SCHEMA CHANGE: Remove unnecessary direct relation of sq_relation with rivers.
2015-02-16 Tom Gottfried Meta-data on sounding width associated to bed heights is redundant to real data associated to values.
2015-02-16 Tom Gottfried Bed heights are just bed heights since a while ('single' is obsolete).
2015-02-16 Tom Gottfried Morphological width imported and stored with heights is redundant to table morphologic_width.
2014-10-15 Tom Gottfried SCHEMA CHANGE: 'comment' is not acceptable as column name for Oracle.
2014-10-15 Tom Gottfried SCHEMA CHANGE: removed superfluous columns station and river_id from measurement_stations and adapted other components accordingly.
2014-08-06 Tom Gottfried SCHEMA CHANGE: rename database tables from yield to load_ls according to respective classes.
2014-07-18 Tom Gottfried SCHEMA CHANGE and Importer: get time intervals of SQ-relations from metalines in sediment load files.
2014-07-14 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.
2014-07-09 Tom Gottfried Repair last commit.
2014-07-09 Tom Gottfried SCHEMA CHANGE: consistent naming scheme and drop script for sediment load at measurement stations.
2014-07-08 Tom Gottfried SCHEMA CHANGE: Added new structure for sediment loads measured at measurement stations.
2014-06-10 Tom Gottfried SCHEMA CHANGE: Removed bed height epochs.
2014-04-30 Raimund Renkert Added tables for porosity and porosity values to postgres schema.
2013-10-29 Tom Gottfried Schema change: add lookup table for sediment yield kinds to have its values documented.
2013-08-12 Tom Gottfried fixed syntax errors in Postgres-schema. double-precision
2013-07-31 Tom Gottfried merged changes from default into double-precision branch double-precision
2013-07-31 Felix Wolfsteller minfo-schema-change/issue1393: add kind column to sediment_yield table.
2013-06-18 Tom Gottfried Minimal schema change: allow longer names in discharge zones double-precision
2013-05-16 Tom Gottfried Schema change: there is only one bed height per station at a given point in time
2013-05-03 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
2013-04-25 Sascha L. Teichmann Rename modules to more fitting names. base flys-backend/doc/schema/postgresql-minfo.sql@683870f52844

http://dive4elements.wald.intevation.org