Linking of external tables

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

 

Table "T_Links"

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