Database documentation: plankton

  Download as PDF (104KB)

K. A. Mackay

NIWA Internal Report No. 69 2000

Contents

1 Database documentation series

2 Marine Research Plankton Survey Database

3 Data Structures .

3.1 Table Relationships .

3.2 Database design

4 Table Summaries

5 plankton Tables ..

5.1 Table 1: t_trip ..

5.2 Table 2: t_trip_comm

5.3 Table 3: t_stratum....

5.4 Table 4: t_station...

5.5 Table 5: t_stat_comm..

5.6 Table 6: t_wire_angle..

5.7 Table 7: t_gear_unit ..

5.8 Table 8: t_eggs ..

5.9 Table 9: t_abund.

6 plankton Business Rules

6.1 Introduction to business rules

6.2 Summary of rules .

Appendix 1 - Reference Code Tables.

List of Figures

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

Figure 2: Expanded ERD of t_eggs and t_abund showing relationships to the curr_spp table in the rdb database.

Figure 3: Origin of the three sets of time and position for a station. ..