The name of all externally linked tables is contained within an extra table called TTableNames. These tables belong to different classes: monitoring tables, STP tables, station tables and look-up tables.
Please note, that in the source databases, all external tables are preceded by the Database OwnerOffline repectively Database OwnerOnline. In our case, this prefix is "JORDAN", but it could be changed in the configuration without modifying any code.
Note: The type of connection (online or offline) is decided at the start of the application and can can not be modified later.
TTableNames
| TNCode | TNName |
|---|---|
| D01 | STP_MUNICIPAL |
| D02 | STP_INDUSTRY |
| D03 | STP_TOURISTIC |
| D04 | STP_LOSSES |
| D05 | STP_AGRICULTURE |
| D06 | STP_LOSSES_ONFARM |
| D07 | STP_LOSSES_AGRODISTRIB |
| D08 | WATER_USE_BILLING |
| D09 | WATER_USE_BILL_CAT |
| D10 | WATER_USE_TYPES_MWI |
| D11 | QURT_BILLED_INDUSTRY |
| G02 | FACILITIES |
| G03 | FACILITY_PIPES |
| M01 | WATER_LEVELS |
| M02 | DAILY_DISCHARGE |
| M03 | PRIMARY_VALUES |
| M04 | DAILY_CLIMATIC |
| M05 | IRRIG_METHOD_DISTRIBUTION |
| M06 | CROP_GROUP_AREA |
| M07 | FARMGATE_IRRIGATION_USE |
| M08 | GROSS_IRRIGATION_USE |
| M09 | DAILY_RAINFALL |
| M10 | CROP_GROUP |
| R01 | STP_WWTP |
| R02 | STP_TRANSFER |
| R03 | STP_TRANSFER_LOSSES |
| R04 | TRANSFER_POINTS |
| R05 | TRANSFER_STATIONS |
| R06 | MONTHLY_PRODUCTION |
| R07 | SPATIAL_INTERSECT_UNITS |
| R08 | STP_GROUNDWATER |
| R09 | STP_BASEFLOW |
| R10 | STP_BASEFLOW_END |
| R11 | STP_FLOOD_FLOW_OUT |
| R12 | MONTHLY_FACILITY_FLOW |