Database Documentation: iki

  Download as PDF (135KB)

B.M. Sanders and K.A. Mackay

NIWA Internal Report

2001

Revised on 30 January 2001

Table of Contents

1 Introduction to the Database Document series

2 Longline Sampling Programme

3 Data Structures

3.1Table relationships

3.2 Database design

4 Table Summaries

5 iki Tables

5.1 Table 1: t_trip

5.2 Table 2: t_trip_catch

5.3 Table 3: t_effor

5.3 Table 3: t_effort

5.4 Table 4: t_page

5.5 Table 5: t_fish

5.6 Table 6: t_catch

5.7 Table 7: t_grade_code

5.8 Table 8: t_hook_shot

5.8 Table 8: t_hook_append

6. iki Database Business Rules

6.1 Introduction to business rules

6.2 Summary of rules

7 Acknowledgements

Appendix 1 - Reference Code Tables

Minimum and maximum fish lengths by species

Appendix 2 - Data Forms

Appendix 3 - New Zealand Statistical Areas

List of Figures

Figure 1: Entity Relationship Diagram (ERD) of the iki database.