Database documentation: beach
Download as PDF (184KB)
K. A. Mackay
NIWA Internal Report
2004
Revised May 2005
Revision History
Version |
Change |
Date |
Person Responsible |
1.0 |
First documented release |
? |
Kevin Mackay |
1.1 |
Revised |
23 Jun 2004 |
Kevin Mackay |
1.2 |
Added proj_code to t_survey table |
May 2005 |
Fred Wei |
Table of Contents
1 Database Document Series
2 Beach Sampling Programmes
3 Data Structures
3.1 Table Relationships
3.2 Database Design
4 Table Summaries.
5 beach Tables
5.1 Table 1: t_survey
5.2 Table 2: t_stratum
5.3 Table 3: t_transect
5.4 Table 4: t_quadrat .
5.5 Table 5: t_replicate
5.6 Table 6: t_catch
5.7 Table 7: t_length
5.8 Table 8: t_lgth_wg
5.9 Table 9: t_bed
5.10 Table 10: t_bed_density
6 beach business rules
6.1 Introduction to business rules
6.2 Summary of rules
7 Acknowledgments
Appendix 1 - Reference code tables
Appendix 2 - Survey location maps
List of Figures
Figure 1: Entity Relationship Diagram (ERD) for the beach database.
Figure 2: ERD showing the relationship between the table t_catch and the rdb database. .
Figure 3: Beach survey locations in the greater Auckland metropolitan area.