Database documentation: rocklob

  Download as PDF (100KB)

K. A. Mackay

NIWA Internal Report No. 70 2000

Contents

1. Database documentation series
   
2. Abundance of early life history stages of the rock lobster
   
3. Data structures
   3.1 Table relationships
   3.2 Database design
   
4. Table summaries
   
5. rocklob tables
   5.1 Table 1: t_locations
   5.2 Table 2: t_catch
   5.3 Table 3: t_puer_lfreq
   5.4 Table 4: t_puer_stage
   5.5 Table 5: t_trip
   5.6 Table 6: t_station
   5.7 Table 7: t_stat_comm
   5.8 Table 8: t_phy_stage
   5.9 Table 9: t_evpsumm
   5.10 Table 10: t_dasdata
   5.11 Table 11: t_stage_codes
   
6. rocklob business rules
   6.1 Introduction to business rules
   6.2 Summary of rules
   
7. References

Appendix 1 – Reference Code Tables 41

List of Figures

Figure 1: Entity Relationship Diagram (ERD) showing the relationships between the tables that hold data from puerulus settlement collectors.
Figure 2: ERD showing the relationships between the tables for the phyllosoma trawl surveys