This is the PostGIS data model for QWAT, the water management software based on QGIS
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.
.build enforce PUM checks to all possible checks Nov 13, 2018
diagram adds printable data models Mar 24, 2017
doc FreeMind diagramm of triggers May 25, 2016
drawing Add 3d to construction points Apr 5, 2016
metaproject @ 6ce7afa
ordinary_data be explicit about the unit for cover form_dimension Nov 15, 2018
system improve code readability Nov 14, 2018
tests Add update and change tests Apr 12, 2018
tools bash Feb 16, 2018
update be explicit about the unit for cover form_dimension Nov 15, 2018
value_lists describe what fk_protection SOMO stands for Nov 15, 2018
.gitignore Add pum integration to manage database upgrades Sep 25, 2017
.gitmodules Deploy demodata automatically from travis (#204) Oct 25, 2017
.travis.yml Make the Travis build stop on pum errors Feb 27, 2018 Update Nov 14, 2018 Add pum integration to manage database upgrades Sep 25, 2017 requirements.txt pum 0.5.13 Apr 8, 2018
requirements.txt drop specific version for pum Apr 26, 2018
roles.sql fix re-installation issues Feb 26, 2016


Build Status

This repository contains the definition of the data model used by QWAT project, a module aimed at managing a water network in QGIS.

A full web data model documentation with diagrams and relations is available here.

Model changelog (Detailed)

  • v1.3.3 : Support for customizations
  • v1.3.2 : SIRE extension and infrastructure enhancements
  • v1.3.1 : fix z computation logic for valves
  • v1.3.0 : Switch from custom version control to generic Postgres Update Manager
  • v1.2.8 : add hardcoded schema_visible field to pipes and valves for enhanced performance on QGIS
  • v1.2.7 : AutoPrint Mapview
  • v1.2.6 : Fixes issue 177. Pipes where not audited by audit log system.
  • V1.2.5 : Adds a scale field to print maps
  • v1.2.4 : Fixes bugs when deleting objects
  • v1.2.2 : Integrates the new audit history system. Fixes an issue with multiple primary keys in conformity check procedure
  • v1.2.1 : Allow installation type change (done in trigger function generated by submodule meta-project generator).
  • v1.2.0 : Simplification of the trigger on views, ie there are no more triggers in cascade generated by the inheritance model. That modification does not affect the data-model code, but the change deserves a change in QWAT version number.
  • v1.1.1 : Adds the ability to use post delta files to check auto generated triggers in model
  • v1.1.0 : Remove valve inheritance from nodes.
  • v1.0.1 : Add functionnal to vl status (meaning the object is ready to be used). This is useful to allow finer printing (print inactive but functional objects)
  • v1.0.0 : First version (3 june 2016)
  • v0.1 : Proof of concept model