View on GitHub

Oak Ridges Moraine Groundwater Program - Database Manual

ORMGP Database Manual

Section 2.2 General Overview of Relationships

The following tables provide the general relationship between the ‘data’ tables (i.e. those prepended with a ‘D_’) and the ‘reference’ tables (also known as the ‘look-up’ tables; prepended with a ‘R_’) within the database (Table 2.2.1). Additional ‘web’ tables (prepended with a ‘W_’) contain a weekly summary of information as found within the database by location. These are used as the source for all web-based mapping.

Note that, for the second table (Table 2.2.2), any listed key in the second ‘Key’ column implies a change in the name of the field between the related tables.

Table 2.2.1 Table relationships between the data (D_) and web (W_) tables
using LOC_ID and INT_ID keysTable 2.2.1 Table relationships between the data (D_) and web (W_) tables using LOC_ID and INT_ID keys.

Table 2.2.2 Table relationships and associated keys for all other tables
(excluding data and web tables)Table 2.2.2 Table relationships and associated keys for all other tables (excluding data and web tables)