log flys-backend/doc/schema/postgresql.sql @ 5783:153456f84602

age author description
2013-04-22 Tom Gottfried add missing constraints to Oracle Schema (issue426) and some cosmetics
2013-04-12 Tom Gottfried Schema change: fixed constraints
2013-03-15 Tom Gottfried SCHEMA CHANGE: removed bad triggers and foreign keys from schema
2013-03-14 Tom Gottfried trigger sequence of time_interval IDs in DB as it is not used by hibernate only anymore
2013-03-14 Tom Gottfried trigger sequence of range IDs in DB as it is not used by hibernate only anymore
2013-03-08 Tom Gottfried corrected constraints on table gauges
2013-03-08 Tom Gottfried SCHEMA CHANGE: removed Waterlevel and WaterleveDifferences, added lookup table for wst
2013-02-14 Tom Gottfried SCHEMA CHANGE: added 'ON DELETE CASCADE' where necessary to delete complete rivers (only in Postgres-Schema so far) dami
2013-01-05 Sascha L. Teichmann !!! FLYS backend schema change !!! Add column bfg_id column to discharge_tables.
2012-12-06 Sascha L. Teichmann Added view for selecting ranges in wsts.
2012-09-22 Sascha L. Teichmann Backend: Added 'official_number' column to rivers table to model the 'Bundeswasserstrassen Identnummer'.
2012-09-12 Sascha L. Teichmann FLYS backend: Fixed postgresql scheme.
2012-07-18 Felix Wolfsteller Adjusted official lines views schemata to include wst column pos.
2012-07-11 Sascha L. Teichmann Backend: Added DB indices for fasten access to cross section points.
2012-06-29 Sascha L. Teichmann Backend: Added views to access the 'Amtlichen Linien'.
2012-01-02 Sascha L. Teichmann Removed "NOT NULL" constraint from gauges.range_id because there are gauges which dont have a Gueltigkeitsbereich.
2011-12-19 Sascha L. Teichmann Added support for official gauge numbers.
2011-10-04 Ingo Weinzierl Removed the Unit from Wsts - added a WstUnit column to rivers.
2011-10-04 Ingo Weinzierl Added db table, model class and importer stuff for units.
2011-07-19 Sascha L. Teichmann Schema: added missing key contraint on hyks table.
2011-07-17 Sascha L. Teichmann Schema: Fixed location of 'Peilungsjahre' in HYKs
2011-07-15 Sascha L. Teichmann Schema: Argh! Added distance_{vl|hf|vr} to
2011-07-15 Sascha L. Teichmann Schema: Added missing columns in HYK tables.
2011-07-15 Sascha L. Teichmann schema: Added structures for HYKs "Hydraulische Kenngroessen"
2011-07-08 Sascha L. Teichmann Made import of cross sections work.
2011-07-07 Sascha L. Teichmann Querprofile: Added a table to map the points to a given km.
2011-07-07 Sascha L. Teichmann Schema: Added description column to the cross section table
2011-07-07 Sascha L. Teichmann Schema: Dropped unique constraint of x in a single line of a "Querprofil-Spur".
2011-07-06 Sascha L. Teichmann Removed braindead points3d table
2011-07-06 Sascha L. Teichmann Add relations for cross sections.
2011-06-15 Sascha L. Teichmann First part of flys/issue18
2011-06-14 Sascha L. Teichmann Added 'Kanten' model
2011-05-24 Sascha L. Teichmann Added a new view to select qs of a WST.
2011-05-24 Sascha L. Teichmann Added a new view to select ws of a WST.
2011-05-11 Sascha L. Teichmann Schema: Added a column which tells if a river counts its km up or downwards.
2011-05-08 Sascha L. Teichmann Schema: Dropped constraint which forces discharge tables to have a unique time interval for a given gauge and kind.
2011-05-06 Sascha L. Teichmann Importer: Make import of historical discharge tables work.
2011-04-18 Sascha L. Teichmann Added a view 'wst_value_table' which aggregates the data to build w/q value tables.
2011-04-15 Sascha L. Teichmann Added 'position' column to wst_columns to allow order them by there column position in the original wst file.
2011-04-15 Sascha L. Teichmann Forget ',' in schema.
2011-04-15 Sascha L. Teichmann Added new column 'kind' in discharge tables and wst to distinguish between different types.
2011-03-21 Sascha L. Teichmann Fixed wrong unique constraint.
2011-03-15 Sascha L. Teichmann Added foreign key constraint annotations to model classes.
2011-03-14 Sascha L. Teichmann Fixed wrong spelled column references in foreign keys introduces with last change.
2011-03-14 Sascha L. Teichmann Added entity and id annotations.
2011-03-14 Sascha L. Teichmann Added missing sequences. Deleted unsupported sqlite schema.
2011-03-11 Sascha L. Teichmann More Hibernate/JPA stuff
2011-03-10 Sascha L. Teichmann Added POJOs to be mapped to schema.
2011-03-09 Sascha L. Teichmann Converted schema to be PostgreSQL compatible.

http://dive4elements.wald.intevation.org