Database documentation: recruit

  Download as PDF (347KB) 

K. A. Mackay

NIWA Internal Report

2001

Revised on 30 January 2001

Contents

1 Database documentation series

2 Recruitment surveys

3 Data structures

3.1 TABLE RELATIONSHIPS

3.2 DATABASE DESIGN

4 Table summaries

5 recruit tables

5.1 TABLE 1: T_SITE

5.2 TABLE 2: T_SITE_CODES

5.3 TABLE 3: T_LGTH

6 recruit business rules

6.1 INTRODUCTION TO BUSINESS RULES

6.2 SUMMARY OF RULES

7 Acknowledgments

Appendix

List of Figures

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

Figure 2: Map of the coverage of the NZMS 260 map series for the North Island.

Figure 3: Map of the coverage of the NZMS 260 map series for the South Island