Database documentation: oyster

  Download as PDF (45KB) 

K. A. Mackay

NIWA Internal Report

2004

Revised on 1 November 2004

Version Control

Contents

1 Database documentation series 3

2 Foveaux Strait oyster sampling programme 3

3 Data Structures 4

3.1 Table Relationships 4

3.2 Database Design 6

3.2.1 Oyster dredge surveys 7

3.2.2 Survey on the impact of dredging on oysters 8

4 Table Summaries 9

5 oyster Tables 10

5.1 Table 1: t_survey 10

5.2 Table 2: t_vessel 10

5.3 Table 3: t_stratum 11

5.4 Table 4: t_station 12

5.5 Table 5: t_biological 15

5.6 Table 6: t_damage 16

5.7 Table 7: t_treatment_codes 17

5.8 Table 8: t_damage_codes 17

5.9 Table 9: t_cluster_codes 17

List of Figures

1 Entity Relationship Diagram (ERD) for the oyster database 5