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 | |
| LEACHING_REQUIREMENTS | 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.