log db_schema/lada_schema.sql @ 1019:e192feaf916f

age author description
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.
Fri, 30 Oct 2015 15:06:22 +0100 Raimund Renkert Updated lada schema: Added status workflow model and cleaned up some triggers.
Mon, 26 Oct 2015 15:44:15 +0100 Tom Gottfried Add initial DB schema script.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)