The following tables are used to store the session parameters log for the irrigation module:
Their relation is as follows:
The diagram depicts four master/detail relationships, where LOG_SESSIONS is the master table, and other tables are detail tables, containing many detail records for each master record. All four tables reside in the part of the database that is common for both WIS and test scenario tables options. During the export of table named <table name> to the other database, the target table is linked in MS Access under the name EXP_<table name>, because both tables have to be linked at the same time (example: LOG_SESSIONS and EXP_LOG_SESSIONS).
Here is a more detailed description of each table:
| Column name | ORACLE type | MS Access type | Null | Primary key | Description |
|---|---|---|---|---|---|
| SESSION_ID | VARCHAR2(30) | Text(30) | No | Yes | Session identifier. |
| USER_NAME | VARCHAR2(30) | Text(30) | No | User that saved the session. | |
| DATE_SAVED | DATE | Date/Time | No | Date/time when the session was saved. | |
| MODULE_TYPE | VARCHAR2(1) | Text(1) | No | A for "agricultural". | |
| REF_YEAR | NUMBER(4) | Integer | No | Reference year. | |
| CENSUS_YEAR | NUMBER(4) | Integer | Yes | (irrelevant for irrigation) | |
| NOTES | VARCHAR2(100) | Text(100) | Yes | Free text description. | |
| SESSION_TYPE | VARCHAR2(1) | Text(1) | No | P-production |
| Column name | ORACLE type | MS Access type | Null | Primary key | Description |
|---|---|---|---|---|---|
| SESSION_ID | VARCHAR2(30) | Text(30) | No | Yes | Session identifier. |
| GIS_ID | VARCHAR2(10) | Text(10) | No | Yes | ID of the selected spatial item (see section 4). |
| Column name | ORACLE type | MS Access type | Null | Primary key | Description |
|---|---|---|---|---|---|
| SESSION_ID | VARCHAR2(30) | Text(30) | No | Yes | Session identifier |
| PARAM_TYPE | VARCHAR2(4) | Text(4) | No | Yes | Parameter type code (see section 4) |
| MONTH | NUMBER(2) | Long Integer | No | Yes | Month corresponding to the parameter value |
| PARAM_VALUE | NUMBER(15,5) | Double | No | Value of the parameter |
| Column name | ORACLE type | MS Access type | Null | Primary key | Description |
|---|---|---|---|---|---|
| SESSION_ID | VARCHAR2(30) | Text(30) | No | Yes | Session identifier |
| PARAM_TYPE | VARCHAR2(4) | Text(4) | No | Yes | Parameter type code (see section 4) |
| SCENARIO | NUMBER(1) | Integer | No | Yes | Scenario number (1, 2 or 3) |
| YEAR | NUMBER(4) | Integer | No | Yes | Balancing year (currently 2005, 2010, …, 2040) |
| PARAM_VALUE | NUMBER(15, 5) | Double | No | Value of the parameter |
| Column name | ORACLE type | MS Access type | Null | Primary key | Description |
|---|---|---|---|---|---|
| SESSION_ID | VARCHAR2(30) | Text(30) | No | Yes | Session identifier |
| PARAM_TYPE | VARCHAR2(4) | Text(4) | No | Yes | Parameter type code (see section 4) |
| CROP_NUM | NUMBER(4) | Integer | No | Yes | ID of crop_group or Main crop group |
| SCENARIO | NUMBER(1) | Integer | No | Yes | Scenario number (1, 2 or 3) |
| YEAR | NUMBER(4) | Integer | No | Yes | Balancing year (currently 2005, 2010, …, 2040) |
| PARAM_VALUE | NUMBER(15,5) | Double | No | Value of the parameter |