log db_schema/lada_schema.sql @ 1345:883ab3a6f525 tip

age author description
Fri, 27 Jan 2017 15:10:01 +0100 Raimund Renkert Make use of the ort factory in ort service.
Thu, 08 Dec 2016 15:23:55 +0100 Tom Gottfried The referencing column does not need to be wider than what it refereces.
Fri, 25 Nov 2016 10:24:22 +0100 Evi Huber Add MPL to Messprogramm
Wed, 09 Nov 2016 17:24:49 +0100 Tom Gottfried Let the database enforce,too, what rev 46db98d060ae introduced.
Wed, 09 Nov 2016 12:39:08 +0100 Raimund Renkert Let the database generate id_alt and initial status for new messung objects.
Tue, 01 Nov 2016 12:47:25 +0100 Tom Gottfried Adapt definition to LAF and validate uniqueness of idAlt.
Mon, 31 Oct 2016 18:09:45 +0100 Tom Gottfried Fix UNIQUE-constraint and respective validation.
Fri, 28 Oct 2016 21:19:44 +0200 Tom Gottfried Do not allow empty string for media descriptor.
Fri, 28 Oct 2016 16:49:47 +0200 Tom Gottfried Rev d1d7d684800c missed to adapt default FK value.
Fri, 14 Oct 2016 18:17:42 +0200 Tom Gottfried Merged branch schema-update into default.
Mon, 10 Oct 2016 17:23:39 +0200 Tom Gottfried Fix validation of subintervall for yearly samples.
Fri, 30 Sep 2016 18:41:12 +0200 Tom Gottfried Calendar.DAY_OF_YEAR is 1-based.
Thu, 29 Sep 2016 16:48:29 +0200 Tom Gottfried A period with end before start is meaningless.
Thu, 29 Sep 2016 16:23:04 +0200 Tom Gottfried Validate against possible maxima.
Tue, 27 Sep 2016 16:16:31 +0200 Tom Gottfried Complement data model and validation of sub-intervalls.
Fri, 23 Sep 2016 19:13:40 +0200 Tom Gottfried Set default in data model instead of on generation of Probe objects.
Fri, 23 Sep 2016 17:56:22 +0200 Tom Gottfried Remove wrong period check.
Fri, 09 Sep 2016 15:33:04 +0200 Raimund Renkert Added unique constraint for probe.id_alt schema-update
Thu, 08 Sep 2016 12:03:43 +0200 Tom Gottfried A period with end before start is not meaningful.
Wed, 07 Sep 2016 18:17:48 +0200 Tom Gottfried A period with end before start is not meaningful.
Mon, 04 Jul 2016 14:31:06 +0200 Raimund Renkert Added FK to probe and messprogramm. schema-update
Tue, 05 Jul 2016 18:24:55 +0200 Tom Gottfried Introduce default value vor Messregime in Messprogramm.
Mon, 04 Jul 2016 11:24:59 +0200 Raimund Renkert Use status_kombi as FK in status_protokol schema-update
Mon, 04 Jul 2016 10:00:08 +0200 Raimund Renkert Added FK constraints. schema-update
Mon, 04 Jul 2016 08:55:36 +0200 Raimund Renkert Removed column name, added column kommentar in messprogramm schema-update
Mon, 04 Jul 2016 08:53:39 +0200 Raimund Renkert Renamed erzeuger to mst_id. schema-update
Mon, 04 Jul 2016 08:52:13 +0200 Raimund Renkert Removed duplicated netzbetreiber column. (mst_id already contains the schema-update
Fri, 01 Jul 2016 19:53:56 +0200 Raimund Renkert Moved comments to the end of the file. schema-update
Fri, 01 Jul 2016 19:51:41 +0200 Raimund Renkert Added index for "child"-tables and removed index for probe. schema-update
Fri, 01 Jul 2016 19:47:21 +0200 Raimund Renkert Moved messung.status FK constraint. schema-update
Fri, 01 Jul 2016 19:46:11 +0200 Raimund Renkert Updated trigger and functions. schema-update
Fri, 01 Jul 2016 19:04:49 +0200 Raimund Renkert Moved trigger creation to table definition. schema-update
Fri, 01 Jul 2016 19:01:32 +0200 Raimund Renkert Moved FK constraints into table definition. schema-update
Fri, 01 Jul 2016 18:17:23 +0200 Raimund Renkert Reordered table creation to allow inline definition of FKs. schema-update
Fri, 01 Jul 2016 18:11:48 +0200 Raimund Renkert Moved unique constraints into table definition. schema-update
Fri, 01 Jul 2016 18:07:33 +0200 Raimund Renkert Removed duplicated defaults. schema-update
Fri, 01 Jul 2016 18:04:21 +0200 Raimund Renkert Declare primary keys in tabel definition. schema-update
Fri, 01 Jul 2016 18:00:29 +0200 Raimund Renkert Removed obsolete search_path statements. schema-update
Fri, 01 Jul 2016 17:59:24 +0200 Raimund Renkert Replaced explicit sequences by serials. schema-update
Fri, 01 Jul 2016 17:46:39 +0200 Raimund Renkert Replaced translation tables for probe and messung with id_alt columns. schema-update
Fri, 01 Jul 2016 17:39:12 +0200 Raimund Renkert Removed schema 'bund'. schema-update
Fri, 01 Jul 2016 17:36:06 +0200 Tom Gottfried Make ID for Messregime an integer.
Fri, 01 Jul 2016 14:18:00 +0200 Tom Gottfried Complement mandatory fields for messprogramm.
Fri, 29 Apr 2016 16:40:26 +0200 Raimund Renkert merged.
Fri, 29 Apr 2016 16:38:33 +0200 Raimund Renkert Use databse triggers for update on field 'letzteAenderung'.
Fri, 15 Apr 2016 10:18:24 +0200 Tom Gottfried Added missing UNIQUE-Constraint.
Fri, 08 Apr 2016 17:17:06 +0200 Tom Gottfried We need a wider range to allow arbitrary input formated +-9.99e+-99
Wed, 23 Mar 2016 18:52:09 +0100 Tom Gottfried probe and messprogramm always need a mst_id and labor_mst_id.
Wed, 23 Mar 2016 13:07:11 +0100 Tom Gottfried Improve readability of DDL for messprogramm table.
Wed, 23 Mar 2016 12:47:16 +0100 Tom Gottfried Improve readability of DDL for probe tables.
Mon, 14 Mar 2016 10:18:24 +0100 Raimund Renkert Added labor_mst_id column to messprogramm.
Fri, 05 Feb 2016 17:01:28 +0100 Tom Gottfried Reorganise database setup scripts.
Wed, 27 Jan 2016 14:49:19 +0100 Raimund Renkert Updated db schema for filter queries.
Fri, 18 Dec 2015 17:32:30 +0100 Raimund Renkert Fixed database function.
Wed, 02 Dec 2015 14:06:48 +0100 Raimund Renkert Updated database schema.
Thu, 19 Nov 2015 12:13:10 +0100 Tom Gottfried Whitespace-cleanup in schema definitions.
Thu, 19 Nov 2015 12:11:23 +0100 Tom Gottfried Remove outdated duplicate VIEW definition.
Thu, 19 Nov 2015 11:45:00 +0100 Tom Gottfried Do not create database objects in case of erroneous definitions.
Wed, 18 Nov 2015 15:58:11 +0100 Raimund Renkert Added view for reachable status values.
Thu, 12 Nov 2015 12:03:03 +0100 Raimund Renkert Updated database schema for status workflow.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)