log flys-backend/doc/schema/oracle-minfo.sql @ 5560:ccda0a49a97f

age author description
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.

http://dive4elements.wald.intevation.org