log flys-backend/doc/schema/oracle-minfo.sql @ 5825:f529495f901d

age author description
Mon, 15 Apr 2013 16:04:22 +0200 Tom Gottfried Schema change: add constraint to have unique stations per flow velocity model
Fri, 12 Apr 2013 16:13:23 +0200 Tom Gottfried Schema change: fixed constraints
Fri, 05 Apr 2013 15:42:15 +0200 Tom Gottfried added missing ON DELETE CASCADE to Oracle schema
Thu, 28 Mar 2013 16:41:30 +0100 Tom Gottfried Schema change: add shore offset to sediment density values and be more rigid with input files in parser
Thu, 28 Mar 2013 14:02:52 +0100 Tom Gottfried Schema change: make sq_relation_value.qmax NOT NULL and more informative messages in parser
Wed, 27 Mar 2013 19:23:57 +0100 Tom Gottfried Schema Change: removed constraint that did not allow to have more than one measurement_type per station
Wed, 27 Mar 2013 16:26:50 +0100 Tom Gottfried backout r5460 to be compatible with r5471 and Oracle database
Wed, 27 Mar 2013 15:37:25 +0100 Tom Gottfried Schema Change: rename measurement_station.description to comment to fit rest of the code
Wed, 27 Mar 2013 12:55:57 +0100 Tom Gottfried Schema corrected: measurement_station.reference_gauge_station is not needed
Wed, 27 Mar 2013 12:45:52 +0100 Tom Gottfried Schema Change: use parameter instead of fraction in sq_relation_value
Wed, 27 Mar 2013 12:13:21 +0100 Tom Gottfried store name and km of reference gauges in measurement_stations too, as not all are in gauges
Wed, 27 Mar 2013 10:25:45 +0100 Tom Gottfried SCHEMA CHANGE: fixed constraints in MINFO and removed obsolete column
Tue, 26 Mar 2013 19:29:39 +0100 Tom Gottfried remove unit from sediment density and depths (always t/m3 respectively cm, otherwise a typo)
Tue, 26 Mar 2013 13:56:08 +0100 Raimund Renkert SCHEMA CHANGE! Renamed columns in sq_relation and sq_relation_value.
Mon, 25 Mar 2013 15:46:21 +0100 Tom Gottfried SCHEMA CHANGE: additional columns and FK constraint for SQ-relation
Fri, 15 Mar 2013 16:43:00 +0100 Tom Gottfried SCHEMA CHANGE: removed bad triggers and foreign keys from schema
Wed, 13 Mar 2013 17:06:59 +0100 Tom Gottfried additional values in lookup table for bed height types
Wed, 13 Mar 2013 16:39:08 +0100 Sascha L. Teichmann Use lookup table from bedd_height from database in importer.
Mon, 11 Mar 2013 18:17:12 +0100 Tom Gottfried SCHEMA CHANGE: analogue r5201. Here for Oracle
Fri, 08 Mar 2013 15:16:00 +0100 Andre Heinecke SCHEME CHANGE: Add measurement_station to oracle table and rename comment column
Wed, 14 Nov 2012 17:19:54 +0100 Raimund Renkert Added new column 'year' to sediment density values in postgresql and oracle
Thu, 27 Sep 2012 10:15:10 +0000 Felix Wolfsteller Towards fix for issue863 (gaps in bedheight data).
Tue, 11 Sep 2012 13:55:08 +0000 Sascha L. Teichmann FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Wed, 13 Jun 2012 08:12:00 +0000 Ingo Weinzierl Store sq relations into database after parsing.
Thu, 07 Jun 2012 09:52:44 +0000 Ingo Weinzierl Improved minfo db schema and added model classes for s/q relation.
Thu, 26 Apr 2012 09:44:39 +0000 Ingo Weinzierl Added missing constraint to relation 'waterlevel_difference'.
Tue, 24 Apr 2012 13:04:30 +0000 Ingo Weinzierl Improved the db schema to store MINFO specific waterlevel differences.
Tue, 24 Apr 2012 11:16:06 +0000 Ingo Weinzierl Prepared the importer to import MINFO specific waterlevel values and added a stub for a parser.
Fri, 20 Apr 2012 06:59:03 +0000 Ingo Weinzierl Added MINFO specific waterlevel relations.
Thu, 19 Apr 2012 12:48:53 +0000 Ingo Weinzierl Added a parser for sediment yield files; started parsing and store values in db.
Wed, 18 Apr 2012 12:53:45 +0000 Ingo Weinzierl Added missing river_id column to sediment_yield relation.
Wed, 18 Apr 2012 12:12:22 +0000 Ingo Weinzierl Improved the db schema to store sediment yield values.
Wed, 18 Apr 2012 08:54:55 +0000 Ingo Weinzierl Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Tue, 17 Apr 2012 10:16:21 +0000 Ingo Weinzierl Added MINFO specific relations for flow velocity measurements.
Tue, 17 Apr 2012 09:37:52 +0000 Ingo Weinzierl Added a parser for flow velocity model data and adjusted the db relation schema (missing q column).
Mon, 16 Apr 2012 09:48:49 +0000 Ingo Weinzierl Improved the oracle db schema for MINFO specific flow velocity values.
Fri, 13 Apr 2012 16:15:23 +0000 Sascha L. Teichmann Add MINFO schema for PostgreSQL
Fri, 13 Apr 2012 12:53:29 +0000 Ingo Weinzierl Tiny schema modification specific to MINFO morphological width values; added importer classes.
Fri, 13 Apr 2012 12:33:26 +0000 Ingo Weinzierl Improved the MIFNO DB schema for morphological width and added model classes.
Fri, 13 Apr 2012 11:45:29 +0000 Ingo Weinzierl Finished parsing MINFO specific sediment density.
Fri, 13 Apr 2012 10:59:15 +0000 Ingo Weinzierl Implemented the method stubs of the parser for sediment density and made some db schema adaptions.
Fri, 13 Apr 2012 08:16:55 +0000 Ingo Weinzierl Improved the MINFO db schema and added model classes for storing sediment density values specific to a river and depth.
Thu, 12 Apr 2012 12:50:49 +0000 Ingo Weinzierl Implemented model classes and importer classes for bed height epochs.
Thu, 12 Apr 2012 10:42:46 +0000 Ingo Weinzierl Finished work on MINFO bed heights (single).
Wed, 11 Apr 2012 13:09:46 +0000 Ingo Weinzierl Some oracle db schema adaptions specific to bed heights in MINFO.
Wed, 11 Apr 2012 09:23:10 +0000 Ingo Weinzierl First things for MINFO specific database schema.

http://dive4elements.wald.intevation.org