The following is a diagram of the table relationships for the Access Databases provided with ESdat. The structure for the SQL Server databases is similar. 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" |
