Database documentation: kina

  Download as PDF (43.6KB)

K. A. Mackay & D. O. Fisher

NIWA Internal Report 2000

Revised on 30 November 2000

Contents

1 Introduction to the Database Document series

2 Kina Population Surveys .

2.1 Data sources.

2.1.1 Commercial Catch and Effort

2.1.2 SOP Catch Sampling

2.1.3 Marine Research Dive Surveys

2.2 Data Validation..

3 Data Structures

3.1 Table relationships.

3.2 Database design

3.2.1 Commercial catch and effort data structures .

3.2.2 Biological data structures .

3.2.3 Grid references.

4 Table Summaries .

5 kina Tables.

5.1 Table 1: t_catch_site

5.2 Table 2: t_sample.

5.3 Table 3: t_test_dia

5.4 Table 4: t_biological

5.5 Table 5: t_grid_ref

6 References

List of Figures

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