Database documentation: hmetal

  Download as PDF (37KB)

K. A. Mackay

NIWA Internal Report

2001

Revised on 30 January 2001

Contents

1 Introduction to the Database Document series

2 Heavy Metal Sampling Programme

3 Data Structures

3.1 Table relationships

3.2 Database design

4 Table Summaries

5 hmetal Tables

5.1 Table 1: sites

5.2 Table 2: areas.

5.3 Table 3: fish_samples

5.3.1 v_main

6 References

Appendix

List of Figures

Figure 1: Entity Relationship Diagram (ERD) for the hmetal database

Figure 2: ERD of the view v_main