Skip to content

Database Structure & Schema

Jump to bottom
Sherry edited this page Aug 8, 2017 · 1 revision

HydroDesktop Database Structure

HydroDesktop uses two local databases to store hydrologic observation data and metadata.

The local metadata cache is a database that is populated with search results from both HIS Central and from specific HIS servers. This local metadata cache is searchable using the data discovery plugin.

The observations database is the heart of HydroDesktop and contains raw data observations that are downloaded from HIS servers, or imported from local data.

HydroDesktop Database schema

The following figure shows the database schema of the main database used by HydroDesktop to store downloaded data values. Important tables in the database are DataValues and DataSeries. dataRepository_schema.png

Default Database Engine

By default HydroDesktop uses the SQLite Database Engine. You can learn more about it here: http://sqlite.org/

Clone this wiki locally