log db_schema/lada_schema.sql @ 1257:423b5f620467

age author description
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
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)