The database - jkall/qgis-midvatten-plugin GitHub Wiki

The database can be created by the plugin. The diagram below illustrates the database design valid for Midvatten plugin version 1.4 or higher.

(The database design that was used until Midvatten plugin version 1.3.3 is found on this page.)

The database can be opened and examined by any sqlite editor/viewer. Spatialite-gui is recommended.

Database Tables

The Entity-Relations diagram above shows existing database tables. The tables are also listed (including column descriptions) in the metadata table "about_db" which is included in the database. A printout of the "about_db" is found here.

Database Views

Besides from tables, presented in diagram above and pages below, there is also a number of views defined in the database. Some of them are loaded into qgis as default (spatial) layers and some of them are kept in the db mainly for enabling quick plotting of subets, e.g. a time series plot of the water quality parameter pH. All the views will be described on this page.