3. Description of Tables
The following tables are used to store the session parameters log:
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 | M, T, I, L or W. | |
| REF_YEAR | NUMBER(4) | Integer | No | Reference year. | |
| CENSUS_YEAR | NUMBER(4) | Integer | Yes | Census year (used for municipal only, set to the reference year for other modules). | |
| NOTES | VARCHAR2(100) | Text(100) | Yes | Free text description. | |
| SESSION_TYPE | VARCHAR2(1) | Text(1) | No | P-production or T-test. |
| 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) |
| SCENARIO | NUMBER(1) | Integer | No | Yes | Scenario number (1, 2 or 3) |
| YEAR | NUMBER(4) | Integer | No | Yes | Balancing year (currently 2005, 2010, …, 2040) |
| MONTH | NUMBER(2) | Integer | No | Yes | Month corresponding to the parameter value |
| PARAM_VALUE | NUMBER(15,5) | Double | No | Value of the parameter |