Database

Database part of SensLog consists of data model and stored functions, procedures and triggers. Database model is implemented in PostgreSQL 9+ with PostGIS 2+ spatial extension. The core data model is shown on following diagram.

Tables

units
observations
units_positions
units_positions
units_tracks
sensors
phenomenons
groups
system_users
alert_events
alerts
alert_queries

Data models of additional modules

Additional tables were added to the core data model for implementing the VGI module. VGI data model is shown on following diagram.

Tables

observations_vgi
observations_vgi_media
observations_vgi_category
vgi_datasets

SensLog runs in Tomcat as web application and needs PostgreSQL with PostGIS installed on server.