Database documentation: rec_data
Download as PDF (3.18MB)
David O. Fisher
NIWA Fisheries Data Management
Database Documentation Series
Revised on 18 April 2007
Revision History
Version |
Changed by |
Reason |
Date |
1 |
David Fisher |
Initial release |
December 1988 |
2 |
David Fisher |
Added tables t_observer and t_count_codes |
11 May 2001 |
2 |
David Fisher |
Added attributes proj_code to t_survey_codes & survey to t_effort |
17 July 2002 |
2 |
David Fisher |
Corrected section 5 table numbering |
16 June 2003 |
3 |
David Fisher |
Added Appendix 2 of Empress data types. Added comments attribute to t_survey_codes. Alter t_effort.locality from char 40 to char 60. Added dist attribute to t_interview. Changed t_length.lgth from integer to decimal(4,1) and added attribute lgth_code. |
December 2003 |
4 |
David Fisher |
Completely restructured the t_response table so the natural key is now (survey, resp, year_s, month_s). Added weighting attribute to t_response table. Added width_meas attribute to t_length table |
April 2004
June 2004 |
| 5 |
Christopher Dick |
Restructure of the t_observer table and
added t_obs_count table.
Added int_before attribute to t_interview
Added maps to Appendix 4
Added paragraph re t_observer and child
tables
Updated some references.
|
November 2006
April 2007 |
Table of Contents
1 Introduction to the Database Document series
2 Recreational fishing data
2.1 Data sources
2.2 Data validation
3 Data Structures
3.1 Table relationships
3.2 Database design
3.2.1 Boat ramp and shellfish harvest tables
3.2.2 Diary survey tables
3.2.3 Common code tables
4 Table Summaries
4.1 Boat ramp and shellfish harvest tables:
4.2 Diary survey tables
4.3 Shared code tables
5 rec_data Tables
5.1 Boat ramp and shellfish harvest tables:
5.1.1 Table 7: t_session
5.1.2 Table 2: t_fisher-count
5.1.3 Table 3: t_group
5.1.4 Table 4: t_interview
5.1.5 Table 5: t_weight
5.1.6 Table 6: t_length
5.1.7 Table 7: t_observd_codes
5.1.8 Table 8: t_observer
5.1.9 Table 9: t_obs_count
5.1.10 Table 10: t_count_codes
5.1.11 Table 11: t_ctch_cen93
5.1.12 Table 12: t_len_cen93
5.2 Diary survey tables
5.2.1 Table 1: t_phone
5.2.2 Table 2: t_sca
5.2.3 Table 3: t_response
5.2.4 Table.4: t_effort
5.2.5 Table 5: t_catch
5.2.6 Table 6: t_lgth
5.3 Shared code tables
5.3.1 Table 1: t_survey_codes
5.3.2 Table 2: t_zonef_codes
5.3.3 Table 3: t_locality_codes
5.3.4 Table 4: t_fishmeth_codes
5.3.5 Table 5: t_ramp_codes
5.3.6 Table 6: t_boat_codes
6 rec_data business rules
6.1 Introduction to business rules
6.2 Summary of rules
7 Acknowledgments
8 References
Appendix 1 - Data entry, error checking, and loading
Appendix 2 - Empress Datatypes
Appendix 3 - Reference Documentation - Code Tables
Appendix 4 - Reference Documentation - Area Maps