The following is a diagram of the structure of the Access Databases provided with ESdat. The structure for the SQL Server databases is the same, but has additional fields to accommodate the storage of data for multiple sites and projects in the single database. Some of the Borehole and Geology tables are excluded from the diagram below for simplicity.
The following points are of note:
•Chemistry Sample information can be associated with or without a well, in the wells table, but must be associated with a location
•All spatial data must be associated with a location in the location table
•All Water Level information must be associated with a well.
•All chemicals in the Chemistry table must appear in the chemistry lookup table "zRef_Chemistry_Lookup"