log backend/doc/schema/oracle.sql @ 6011:d9a1cf0438a5

age author description
Mon, 13 May 2013 18:21:55 +0200 Tom Gottfried backout 6009:6ea171b6d8d2 because this was only really valid for fixations
Mon, 13 May 2013 17:48:32 +0200 Tom Gottfried Schema change because WST-columns without time interval are useless
Wed, 08 May 2013 13:16:29 +0200 Tom Gottfried Schema change: leave it up to AFT whether time intervals are unique per gauge but do not accept duplicate bfg_id per gauge
Tue, 07 May 2013 18:19:57 +0200 Tom Gottfried Schema change: named_main_values.name is not unique, as we can have the same name for different types
Fri, 03 May 2013 13:15:28 +0200 Tom Gottfried Schema change: increased precision of discharge_table_values.q to allow unique import of higher precision values
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
Fri, 03 May 2013 07:47:15 +0200 Tom Gottfried Schema change: remove UNIQUE-constraint from rivers.official number as we have different representations of the same river (e.g. for sommer and winter)
Tue, 30 Apr 2013 12:53:10 +0200 Tom Gottfried Schema change: add constraint to discharge tables

http://dive4elements.wald.intevation.org