Database documentation: rlcs

  Download as PDF (3.40MB) 

Catch sampling schema

K.A. Mackay & K. George

NIWA Internal Report 2002

Revised on 16 September 2002

Table of Contents

1. Database Document Series
   
2. Rock lobster Catch Sampling Programs
   
3. Data Structures
   
4. Table summaries
   
5. rlcs Catch Sampling Tables
   5.1 Table 1: t_sample
   5.2 Table 2: t_effort
   5.3 Table 3: t_crayfish
   5.4 Table 4: t_bait_codes
   
6. rlcs Catch Sampling Views
   6.1 View 1: v_lob_sample
   6.2 View 2: v_cra_catch
   6.2 View 2: v_cra_catch
   6.3 View 3: v_cra_lf
   6.4 View 4: v_morp_sample
   6.5 View 5: v_cra_wt
   6.6 View 6: v_phc_sample
   6.7 View 7: v_phc_catch
   6.8 View 8: v_phc_lf
   6.9 View 9: v_mls_sample
   6.10 View 10: v_mls_lf
   6.11 View 11: v_tag_sample
   
7. rlcs Catch Sampling Business Rules
   
8. Acknowledgments
   
9. Appendix 1 - Data entry, error checking, and loading
   
10. Appendix 2 - Reference Code Tables