Enhydris supports PostgreSQL (with PostGIS).
In Django parlance, a model is a type of entity, which usually maps to a single database table. Therefore, in Django, we usually talk of models rather than of database tables, and we design models, which is close to conceptual database design, leaving it to Django’s object-relational mapper to translate to the physical. In this text, we also speak more of models than of tables. Since a model is a Python class, we describe it as a Python class rather than as a relational database table. If, however, you feel more comfortable with tables, you can generally read the text understanding that a model is a table.
If you are interested in the physical structure of the database, you need to know the model translation rules, which are quite simple:
The name of the table is the lower case name of the model, with a prefix. The prefix for the core of the database is
enhydris_. (More on the prefix below).
Tables normally have an implicit integer id field, which is the primary key of the table.
Table fields have the same name as model attributes, except for foreign keys.
Foreign keys have the name of the model attribute suffixed with
When using multi-table inheritance, the primary key of the child table is also a foreign key to the id field of the parent table. The name of the database column for the key of the child table is the lower cased parent model name suffixed with
The core of the Enhydris database is a list of measuring stations, with
additional information such as photos, videos, and the hydrological and
meteorological time series stored for each measuring station. This can
be used in or assisted by many more applications, which may or may not
be needed in each setup. A billing system is needed for agencies that
charge for their data, but not for those who offer them freely or only
internally. Some organisations may need to develop additional software
for managing aqueducts, and some may not. Therefore, the core is kept as
simple as possible. The core database tables use the
prefix. Other applications use another prefix. The name of a table is
the lowercased model name preceded by the prefix. For example, the
table that corresponds to the
Gentity model is
Lookup tables are those that are used for enumerated values. For example, the list of variables is a lookup table. Most lookup tables in the Enhydris database have three fields: id, descr, and short_descr, and they all inherit the following abstract base class:
- class enhydris.models.Lookup¶
This class contains the common attribute of the lookup tables:
A character field with a descriptive name.
Most lookup tables are described in a relevant section of this document, where their description fits better.
The Lentity is the superclass of people and groups. For example, a measuring station can belong either to an organisation or an individual. Lawyers use the word “entity” to refer to individuals and organisations together, but this would create confusion because of the more generic meaning of “entity” in computing; therefore, we use “lentity”, which is something like a legal entity. The lentity hierarchy is implemented by using Django’s multi-table inheritance.
- class enhydris.models.Person¶
Gentity and its direct descendants: Gpoint, Gline, Garea¶
A Gentity is a geographical entity. Examples of gentities (short for geographical entities) are measuring stations, cities, boreholes and watersheds. A gentity can be a point (e.g. stations and boreholes), a surface (e.g. lakes and watersheds), a line (e.g. aqueducts), or a network (e.g. a river). The gentities implemented in the core are measuring stations and generic gareas. The gentity hierarchy is implemented by using Django’s multi-table inheritance.
- class enhydris.models.Gentity¶
A field with the name of the gentity, such as the name of a measuring station. Up to 200 characters.
An optional field with a code for the gentity. Up to 50 characters. It can be useful for entities that have a code, e.g. watersheds are codified by the EU, and the watershed of Nestos River has code EL07.
A field with general remarks about the gentity. Unlimited length.
Timestamps of time series records are stored in UTC. This attribute specifies the time zone to which timestamps are converted before displaying or downloading time series. It is a string holding a key from the Olson time zone list. Currently only time zones starting with
Although the storage format of the time zone is
Etc/GMT[±XX], it is displayed differently on the admin (and elsewhere).
Etc/GMTis displayed as
Etc/GMT-2(2 hours east of UTC) is displayed as
UTC+0200; and so on.
- class enhydris.models.Gpoint(Gentity)¶
Specifies the reference system in which the user originally entered the co-ordinates of the point. Valid srid’s are registered at http://www.epsg-registry.org/. See also https://medium.com/@aptiko/introduction-to-geographical-co-ordinate-systems-4e143c5b21bc.
The altitude in metres above mean sea level.
Additional information for generic gentities¶
This section describes models that provide additional information about gentities.
- class enhydris.models.GentityFile¶
- class enhydris.models.GentityImage¶
These models store files and images for the gentity. The difference between
GentityImageobjects are shown in a gallery in the station detail page, whereas files are shown in a much less prominent list.
A short description or legend of the file/image.
Remarks of unlimited length.
For photos, it should be the date the photo was taken. For other kinds of files, it can be any kind of date.
This attribute exists for
GentityImageonly. In the station detail page, one of the images (the “featured” image) is shown in large size (the rest are shown as a thumbnail gallery). This attribute indicates the featured image. If there are more than one featured images (or if there is none), images are sorted by
descr, and the first one is featured.
- class enhydris.models.EventType(Lookup)¶
Stores types of events.
- class enhydris.models.GentityEvent¶
An event is something that happens during the lifetime of a gentity and needs to be recorded. For example, for measuring stations, events such as malfunctions, maintenance sessions, and extreme weather phenomena observations can be recorded and provide a kind of log.
The date of the event.
The username of the user who entered the event to the database.
A report about the event; a text field of unlimited length.