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

age author description
Fri, 15 Mar 2013 16:43:00 +0100 Tom Gottfried SCHEMA CHANGE: removed bad triggers and foreign keys from schema
Thu, 14 Mar 2013 13:39:54 +0100 Tom Gottfried trigger sequence of time_interval IDs in DB as it is not used by hibernate only anymore
Thu, 14 Mar 2013 13:32:02 +0100 Tom Gottfried trigger sequence of range IDs in DB as it is not used by hibernate only anymore
Fri, 08 Mar 2013 16:51:55 +0100 Tom Gottfried corrected constraints on table gauges
Fri, 08 Mar 2013 12:45:48 +0100 Tom Gottfried SCHEMA CHANGE: removed Waterlevel and WaterleveDifferences, added lookup table for wst
Thu, 14 Feb 2013 17:36:10 +0100 Tom Gottfried SCHEMA CHANGE: added 'ON DELETE CASCADE' where necessary to delete complete rivers (only in Postgres-Schema so far) dami
Sat, 05 Jan 2013 15:05:51 +0100 Sascha L. Teichmann !!! FLYS backend schema change !!! Add column bfg_id column to discharge_tables.
Thu, 06 Dec 2012 17:30:09 +0100 Sascha L. Teichmann Added view for selecting ranges in wsts.
Sat, 22 Sep 2012 13:45:51 +0000 Sascha L. Teichmann Backend: Added 'official_number' column to rivers table to model the 'Bundeswasserstrassen Identnummer'.
Wed, 12 Sep 2012 16:51:38 +0000 Sascha L. Teichmann FLYS backend: Fixed postgresql scheme.
Wed, 18 Jul 2012 09:24:51 +0000 Felix Wolfsteller Adjusted official lines views schemata to include wst column pos.
Wed, 11 Jul 2012 10:37:03 +0000 Sascha L. Teichmann Backend: Added DB indices for fasten access to cross section points.
Fri, 29 Jun 2012 11:24:50 +0000 Sascha L. Teichmann Backend: Added views to access the 'Amtlichen Linien'.
Mon, 02 Jan 2012 13:42:27 +0000 Sascha L. Teichmann Removed "NOT NULL" constraint from gauges.range_id because there are gauges which dont have a Gueltigkeitsbereich.
Mon, 19 Dec 2011 11:21:25 +0000 Sascha L. Teichmann Added support for official gauge numbers.

http://dive4elements.wald.intevation.org