Database documentation for the Ministry of Fisheries,

  Download as PDF (68.1KB) 

Regional Catch Effort database

regional_ce

B. M. Sanders

NIWA Fisheries Data Management

Database Document Series

12 October 2005

Revision History

Contents

1 Introduction to the Database Document series

2 Regional Catch Effort data

3 Data Structures

3.1 Table relationships

3.2 Database design

4 Table Summaries

5 regional_ce Tables

5.1 Table 1: t_trip

5.2 Table 2: t_trip_comment

5.3 Table 3: t_effort

5.4 Table 4: t_catch

5.5 Table 5: t_permits

5.6 Table 6: t_landings

5.7 Table 7: t_ memo_codes

5.8 Table 8: t_status_codes

6 Regional_ce business rules

6.1 Introduction to business rules

6.2 Summary of rules

7 Acknowledements

Appendix 1 - Data entry, error checking, and loading

Appendix 2 - Reference codes

List of Figures

Figure 1 Entity Relationship Diagram (ERD) for the regional_ce database