log db_schema/stammdaten_schema.sql @ 998:c22a99d5c6f1 schema-update

age author description
2016-07-01 Tom Gottfried Fix CHECK-Constraint definition.
2016-06-29 Raimund Renkert Added unique constraint to result.query_id and result.data_index and fixed data
2016-06-02 Tom Gottfried Add missing FK-constraint.
2016-06-01 Tom Gottfried Authorize status change only for matching user.
2016-05-24 Tom Gottfried Use ON DELETE CASCADE to ease removing queries from database.
2016-04-29 Raimund Renkert Use databse triggers for update on field 'letzteAenderung'.
2016-04-08 Tom Gottfried netzbetreiber_id is mandatory for ort.
2016-04-05 Tom Gottfried Set netzbetreiber-specific IDs UNIQUE per netzbetreiber.
2016-04-05 Tom Gottfried Set known mandatory fields in stammdaten NOT NULL.
2016-03-24 Tom Gottfried Improve readability of DDL for editable stammdaten tables.
2016-02-19 Raimund Renkert Removed column 'query_id' from filter_value table.
2016-02-15 Tom Gottfried Allow 'editing' of status 'Rückfrage'
2016-02-11 Tom Gottfried Available status values need to be filtered by the users functions.
2016-02-09 Tom Gottfried Remove unused VIEWs.
2016-02-08 Tom Gottfried Add necessary constraints for status workflow.
2016-02-08 Tom Gottfried Status workflow definitions are needed and assumed to be given by the server.
2016-02-08 Tom Gottfried Put status workflow definitions in one place.
2016-02-08 Tom Gottfried Functions are needed and assumed to be given by the server.
2016-02-05 Tom Gottfried Use inline primary key definitions and remove autogenerated comments.
2016-02-05 Tom Gottfried Whitespace cleanup.
2016-02-05 Tom Gottfried Reorganise database setup scripts.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)