log db_schema/stammdaten_schema.sql @ 1204:45308f8a4092

age author description
Tue, 29 Nov 2016 15:57:09 +0100 Raimund Renkert Removed table de_vg and added verwaltungsgrenze.
Fri, 25 Nov 2016 09:37:39 +0100 Michael Stanko redesign stammdaten.verwaltungseinheit
Wed, 16 Nov 2016 17:02:22 +0100 Raimund Renkert Declared variable in db function set_ort_id.
Wed, 16 Nov 2016 15:57:14 +0100 Raimund Renkert Removed NOT NULL constraint from stammdaten.ort.staat_id.
Wed, 16 Nov 2016 15:56:43 +0100 Raimund Renkert Added trigger to fill stammdaten.ort attributes.
Mon, 07 Nov 2016 10:04:57 +0100 Raimund Renkert Updated stammdaten schema.
Fri, 28 Oct 2016 11:58:52 +0200 Tom Gottfried Switch back to 1-based id of betriebsart.
Thu, 27 Oct 2016 19:30:32 +0200 Tom Gottfried Client and server now expect these combinations to be modelled, too.
Mon, 24 Oct 2016 11:47:55 +0200 Raimund Renkert Removed column 'datenbasis_id' from messprogramm_transfer table.
Fri, 14 Oct 2016 18:17:42 +0200 Tom Gottfried Merged branch schema-update into default.
Fri, 14 Oct 2016 15:18:42 +0200 Tom Gottfried Complement and correct data model and docs for queries. 2.3.0
Thu, 13 Oct 2016 11:13:46 +0200 Michael Stanko update stammdaten.deskriptor_umwelt schema-update
Wed, 28 Sep 2016 09:06:18 +0200 Michael Stanko extend docker envireoment to load geographical data of german comunities
Tue, 20 Sep 2016 10:13:43 +0200 Raimund Renkert Added new table for messprogramm mappings. schema-update
Wed, 31 Aug 2016 15:47:52 +0200 Raimund Renkert Updated sql query strings to match the new schema. schema-update
Fri, 08 Jul 2016 15:35:24 +0200 Raimund Renkert merged. schema-update
Fri, 08 Jul 2016 15:34:33 +0200 Raimund Renkert Moved referenced tables. schema-update
Mon, 04 Jul 2016 14:30:40 +0200 Raimund Renkert Added table betriebsart schema-update
Mon, 04 Jul 2016 14:23:50 +0200 Raimund Renkert Updated values. schema-update
Mon, 04 Jul 2016 14:18:42 +0200 Raimund Renkert Added filter and query type table. schema-update
Thu, 07 Jul 2016 11:46:14 +0200 Michael Stanko add stammdaten.kta and stammdaten.ortszusatz schema-update
Mon, 04 Jul 2016 12:10:44 +0200 Raimund Renkert Fixed typos. schema-update
Mon, 04 Jul 2016 12:09:01 +0200 Raimund Renkert Made most constraints inline. schema-update
Mon, 04 Jul 2016 12:05:26 +0200 Raimund Renkert Added inline FK constraints. schema-update
Mon, 04 Jul 2016 12:04:50 +0200 Raimund Renkert Reordered tables. schema-update
Mon, 04 Jul 2016 11:46:42 +0200 Raimund Renkert Replaced explicid sequences with serials. schema-update
Mon, 04 Jul 2016 11:46:20 +0200 Raimund Renkert Fixed column names in constraints. schema-update
Mon, 04 Jul 2016 11:31:31 +0200 Raimund Renkert Fixed names and typos. schema-update
Mon, 04 Jul 2016 11:25:40 +0200 Raimund Renkert Renamed/Removed some columns. schema-update
Fri, 01 Jul 2016 10:32:44 +0200 Tom Gottfried Fix CHECK-Constraint definition.
Wed, 29 Jun 2016 19:23:50 +0200 Raimund Renkert Added unique constraint to result.query_id and result.data_index and fixed data
Thu, 02 Jun 2016 18:04:44 +0200 Tom Gottfried Add missing FK-constraint.
Wed, 01 Jun 2016 15:25:08 +0200 Tom Gottfried Authorize status change only for matching user.
Tue, 24 May 2016 17:15:44 +0200 Tom Gottfried Use ON DELETE CASCADE to ease removing queries from database.
Fri, 29 Apr 2016 16:38:33 +0200 Raimund Renkert Use databse triggers for update on field 'letzteAenderung'.
Fri, 08 Apr 2016 11:14:09 +0200 Tom Gottfried netzbetreiber_id is mandatory for ort.
Tue, 05 Apr 2016 10:49:13 +0200 Tom Gottfried Set netzbetreiber-specific IDs UNIQUE per netzbetreiber.
Tue, 05 Apr 2016 10:29:55 +0200 Tom Gottfried Set known mandatory fields in stammdaten NOT NULL.
Thu, 24 Mar 2016 15:57:05 +0100 Tom Gottfried Improve readability of DDL for editable stammdaten tables.
Fri, 19 Feb 2016 14:23:58 +0100 Raimund Renkert Removed column 'query_id' from filter_value table.
Mon, 15 Feb 2016 11:33:44 +0100 Tom Gottfried Allow 'editing' of status 'Rückfrage'
Thu, 11 Feb 2016 16:23:38 +0100 Tom Gottfried Available status values need to be filtered by the users functions.
Tue, 09 Feb 2016 15:11:36 +0100 Tom Gottfried Remove unused VIEWs.
Mon, 08 Feb 2016 18:31:08 +0100 Tom Gottfried Add necessary constraints for status workflow.
Mon, 08 Feb 2016 18:23:41 +0100 Tom Gottfried Status workflow definitions are needed and assumed to be given by the server.
Mon, 08 Feb 2016 13:21:42 +0100 Tom Gottfried Put status workflow definitions in one place.
Mon, 08 Feb 2016 12:45:26 +0100 Tom Gottfried Functions are needed and assumed to be given by the server.
Fri, 05 Feb 2016 18:32:03 +0100 Tom Gottfried Use inline primary key definitions and remove autogenerated comments.
Fri, 05 Feb 2016 17:03:31 +0100 Tom Gottfried Whitespace cleanup.
Fri, 05 Feb 2016 17:01:28 +0100 Tom Gottfried Reorganise database setup scripts.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)