log db_schema/stammdaten_schema.sql @ 1235:563c7d18c45f

age author description
Fri, 09 Dec 2016 14:57:17 +0100 Tom Gottfried Make all state identifiers unique.
Fri, 09 Dec 2016 14:47:13 +0100 Tom Gottfried In memoriam Oracle.
Fri, 09 Dec 2016 14:40:42 +0100 Tom Gottfried Use NULL instead of '-' for missing values.
Thu, 08 Dec 2016 14:47:21 +0100 Tom Gottfried An Ort always has a location which is created from respective input.
Thu, 08 Dec 2016 14:30:35 +0100 Tom Gottfried Remove obsolete redundant attributes.
Mon, 05 Dec 2016 12:28:59 +0100 Tom Gottfried Add spatial index to speed up OrtFactory.findVerwaltungseinheit().
Mon, 05 Dec 2016 12:20:10 +0100 Tom Gottfried Add missing FK constraint.
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
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)