log db_schema/stammdaten_schema.sql @ 1194:289edf060550

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