The name of all externally linked tables is contained within an extra table called "T_Links". In case of an online connection, some tables are linked from ORACLE , otherwise, they are linked from the local Access database dvs_data.mdb
Please note, that in the source databases, certain external tables (those with boolOnlineOffline=true) are preceded by the Database OwnerOffline respectively Database OwnerOnline. In our case, this prefix is "JORDAN", but that could be changed in the configuration without modifying any code.
Depending on the individual sub-module used, the Runoff module will only link those tables that are required.
The tables are located in different databases, DB_num indicates the name of these databases, their location is defined in the configuration.
| 0 | ORACLE only | |
| 1 | #eRainData | Rainfall_offline.mdb |
| 2 | #eEvapData | Evap_offline.mdb |
| 3 | #eOffData | Runoff_Offline.mdb |
| 7 | #eDVSData | DVS_data.mdb |
| Modul | Table_name | DB_num | boolOnlineOffline |
|---|---|---|---|
| EvapPrePro | DAILY_CLIMATOLIGICAL | 0 | Yes |
| Core | jRain | 1 | No |
| Core | RainStat | 1 | No |
| Core | App_Params | 3 | No |
| RainPrePro | T_exclude | 1 | No |
| RainPrePro | jRain | 1 | No |
| RainPrePro | RainStat | 1 | No |
| Core | ClimStat | 2 | No |
| Core | mETP | 2 | No |
| EvapPrePro | D_Drybulb | 2 | No |
| EvapPrePro | D_Humidity | 2 | No |
| EvapPrePro | D_Sunshine | 2 | No |
| EvapPrePro | D_TempMax | 2 | No |
| EvapPrePro | D_TempMin | 2 | No |
| EvapPrePro | D_WetBulb | 2 | No |
| EvapPrePro | D_Windrun | 2 | No |
| EvapPrePro | M_DepMeteo | 2 | No |
| EvapPrePro | M_Humidity | 2 | No |
| EvapPrePro | M_SunShine | 2 | No |
| EvapPrePro | M_TempMax | 2 | No |
| EvapPrePro | M_TempMin | 2 | No |
| EvapPrePro | M_Windrun | 2 | No |
| EvapPrePro | MetData_db | 2 | No |
| EvapPrePro | StData_db | 2 | No |
| EvapPrePro | mETP | 2 | No |
| EvapPrePro | ClimStat | 2 | No |
| PostPro | mbasins | 3 | No |
| PostPro | mon_E | 3 | No |
| PostPro | mon_I | 3 | No |
| PostPro | mon_Q | 3 | No |
| PostPro | mon_R | 3 | No |
| PostPro | stat_E | 3 | No |
| PostPro | stat_I | 3 | No |
| PostPro | stat_Q | 3 | No |
| PostPro | stat_R | 3 | No |
| PostPro | STP_GROUNDWATER_TMP | 3 | No |
| PostPro | STP_HISTFLOOD_TMP | 3 | No |
| PostPro | T_Stations | 3 | No |
| PostPro | T_WaterBudget | 3 | No |
| PostPro | T_WE_all | 3 | No |
| PostPro | WE_scenarios | 3 | No |
| PostPro | WE_scenario_details | 3 | No |
| PostPro | y_E | 3 | No |
| PostPro | y_I | 3 | No |
| PostPro | y_Q | 3 | No |
| PostPro | y_R | 3 | No |
| PostPro | d_Q | 3 | No |
| PostPro | d_R | 3 | No |
| Postpro | y_Y | 3 | No |
| RainPrePro | bigproxy | 3 | No |
| PostPro | GW_Basins | 3 | No |
| PostPro | T_GW_SY | 3 | No |
| ModBuilder | T_Land_classify | 3 | No |
| ModBuilder | T_climate_soil_d | 3 | No |
| ModBuilder | T_CN_percolation | 3 | No |
| ModBuilder | T_CN_surface | 3 | No |
| RainPrePro | DAILY_RAINFALL | 7 | Yes |
| PostPro | STP_FLOODFLOW_OUT_HIST | 7 | Yes |
| PostPro | STP_GROUNDWATER | 7 | Yes |
| RainPrePro | STATIONS | 7 | Yes |