log flys-backend/doc/schema/oracle.sql @ 5796:53cff50918b1

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-11 Tom Gottfried SCHEMA CHANGE: analogue r5201. Here for Oracle
2013-03-08 Tom Gottfried corrected constraints on table gauges
2013-03-08 Andre Heinecke SCHEME CHANGE: Add measurement_station to oracle table and rename comment column
2013-03-01 Tom Gottfried added missing constraints in schema (mostly for Oracle)
2013-02-27 Andre Heinecke Add on delete cascade to the constraints that also cascade on postgres 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-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-07-11 Sascha L. Teichmann Partial fix for flys/issue697: Increased the decimal places of Ws, Qs and Kms to 5.
2012-06-29 Sascha L. Teichmann Backend: Added views to access the 'Amtlichen Linien'.
2012-04-27 Ingo Weinzierl Made SQL instructions upper case.
2011-12-19 Sascha L. Teichmann Added support for official gauge numbers.
2011-11-18 Sascha L. Teichmann Fixed flys/issue415: Increased precision of a and b in ranges.
2011-10-19 Bjoern Schilberg Added missing views (wst_value_table,wst_w_values,wst_q_values).
2011-10-18 Bjoern Schilberg Removed all CREATE OR REPLACE TRIGGER statements.
2011-10-17 Bjoern Schilberg Adjusted NUMBER format for units, positions and cross_section_points tables.
2011-10-11 Bjoern Schilberg Fixed errors.
2011-10-10 Bjoern Schilberg Adjust oracle schema [I382]
2011-09-15 Bjoern Schilberg Added inital oracle schema.

http://dive4elements.wald.intevation.org