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.
|
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.
|