log flys-backend/doc/schema/postgresql.sql @ 4734:0b4e1a493045

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

http://dive4elements.wald.intevation.org