4 Table Summaries
The following is a listing of the tables contained in the hmetal
database:
sites : contains heavy metal
sample site location details including location name and area code.
areas : contains all area codes
used in the sites table and their spatial coordinates expressed as
latitude and longitude.
fish_samples: contains details for
individual fish including species, fish length, weight, sex, and
amounts of various organochlorine insecticides and heavy metals such
as DDT, zinc, arsenic, lead, and mercury.
v_main : is a view that provides a
denormalised view of all the tables in the hmetal database.