HydroServer Data Model

The following are entity relationship diagrams illustrating the HydroServer data model design. You can also access a data dictionary that describes each of the entities and attributes along with data types and descriptive information.

Primary and foreign keys are specified in the first column of each entity. Mandatory attributes are specified with "(M)" preceding the attribute name. Optional attributes are specified with "(O)" preceding the attribute name. Data types are defined in the data dictionary document. Entities shown with blue title bars are part of the SensorThings API data model. Entities with white title bars were added to the SensorThings data model to accommodate functionality required for the HydroServer software.

Identity and Access Management Model

Covers users, workspaces, roles, and collaborators — the entities that control who owns and has access to resources in HydroServer.

Data Storage Model

Covers sites, datastreams, observations, and associated metadata — the core entities for representing monitoring locations and the time series data collected at them.

Data Processing Model

Covers ETL tasks, data product tasks, and monitoring tasks — the entities that define automated data ingestion, transformation, and quality monitoring workflows.