log db_schema/stammdaten_schema.sql @ 1105:d9d57a107478

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