log flys-backend/doc/schema/postgresql.sql @ 5436:7dcf604a4bf7

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.
Tue, 04 Oct 2011 15:28:19 +0000 Ingo Weinzierl Removed the Unit from Wsts - added a WstUnit column to rivers.
Tue, 04 Oct 2011 06:47:00 +0000 Ingo Weinzierl Added db table, model class and importer stuff for units.
Tue, 19 Jul 2011 10:10:51 +0000 Sascha L. Teichmann Schema: added missing key contraint on hyks table.
Sun, 17 Jul 2011 10:24:20 +0000 Sascha L. Teichmann Schema: Fixed location of 'Peilungsjahre' in HYKs
Fri, 15 Jul 2011 15:53:33 +0000 Sascha L. Teichmann Schema: Argh! Added distance_{vl|hf|vr} to
Fri, 15 Jul 2011 14:33:12 +0000 Sascha L. Teichmann Schema: Added missing columns in HYK tables.
Fri, 15 Jul 2011 09:36:23 +0000 Sascha L. Teichmann schema: Added structures for HYKs "Hydraulische Kenngroessen"
Fri, 08 Jul 2011 09:45:48 +0000 Sascha L. Teichmann Made import of cross sections work.
Thu, 07 Jul 2011 15:59:24 +0000 Sascha L. Teichmann Querprofile: Added a table to map the points to a given km.
Thu, 07 Jul 2011 15:20:19 +0000 Sascha L. Teichmann Schema: Added description column to the cross section table
Thu, 07 Jul 2011 15:05:30 +0000 Sascha L. Teichmann Schema: Dropped unique constraint of x in a single line of a "Querprofil-Spur".
Wed, 06 Jul 2011 15:35:38 +0000 Sascha L. Teichmann Removed braindead points3d table
Wed, 06 Jul 2011 10:23:45 +0000 Sascha L. Teichmann Add relations for cross sections.
Wed, 15 Jun 2011 09:22:00 +0000 Sascha L. Teichmann First part of flys/issue18
Tue, 14 Jun 2011 12:34:08 +0000 Sascha L. Teichmann Added 'Kanten' model
Tue, 24 May 2011 11:12:59 +0000 Sascha L. Teichmann Added a new view to select qs of a WST.
Tue, 24 May 2011 10:49:14 +0000 Sascha L. Teichmann Added a new view to select ws of a WST.
Wed, 11 May 2011 08:44:14 +0000 Sascha L. Teichmann Schema: Added a column which tells if a river counts its km up or downwards.
Sun, 08 May 2011 11:20:39 +0000 Sascha L. Teichmann Schema: Dropped constraint which forces discharge tables to have a unique time interval for a given gauge and kind.
Fri, 06 May 2011 10:27:32 +0000 Sascha L. Teichmann Importer: Make import of historical discharge tables work.
Mon, 18 Apr 2011 15:52:53 +0000 Sascha L. Teichmann Added a view 'wst_value_table' which aggregates the data to build w/q value tables.
Fri, 15 Apr 2011 16:06:15 +0000 Sascha L. Teichmann Added 'position' column to wst_columns to allow order them by there column position in the original wst file.
Fri, 15 Apr 2011 15:28:35 +0000 Sascha L. Teichmann Forget ',' in schema.
Fri, 15 Apr 2011 10:31:15 +0000 Sascha L. Teichmann Added new column 'kind' in discharge tables and wst to distinguish between different types.
Mon, 21 Mar 2011 10:52:33 +0000 Sascha L. Teichmann Fixed wrong unique constraint.
Tue, 15 Mar 2011 14:49:56 +0000 Sascha L. Teichmann Added foreign key constraint annotations to model classes.
Mon, 14 Mar 2011 15:40:14 +0000 Sascha L. Teichmann Fixed wrong spelled column references in foreign keys introduces with last change.
Mon, 14 Mar 2011 14:52:58 +0000 Sascha L. Teichmann Added entity and id annotations.
Mon, 14 Mar 2011 11:31:00 +0000 Sascha L. Teichmann Added missing sequences. Deleted unsupported sqlite schema.
Fri, 11 Mar 2011 14:41:18 +0000 Sascha L. Teichmann More Hibernate/JPA stuff
Thu, 10 Mar 2011 13:44:51 +0000 Sascha L. Teichmann Added POJOs to be mapped to schema.
Wed, 09 Mar 2011 14:07:15 +0000 Sascha L. Teichmann Converted schema to be PostgreSQL compatible.

http://dive4elements.wald.intevation.org