Additional data tables

In addition to the monitoring and STP tables there is another category of rather large data tables stored in ORACLE containing time-independent mass data.

Altogether, the Irrigation module uses the following Look-up Tables (sorted alphabetically):

Table name Notes Database location Online /offline
CROP_GROUP external both
YEAR_TYPE_NIR after selection relevant records copied into table selected_YEAR_TYPE_NIR external both
T_WW_IRR_link relates WW irrigation schemes to WWTPs. internal -

N.B. Internal means, that the table is not linked from an external database but that it is built-in the irrigation module.