4 Table Summaries

The following is a listing and brief outline of the catch sampling tables contained in rlcs.

All sampling programs use the following base tables:

1. t_sample : contains details of all samples undertaken including details such as vessel registration number, date, skipper, sampler's names, weather conditions, season, landed weight if available, and the number of lobsters landed to a Licensed Fish Receiver (LFR).
2. t_effort : contains details for each unit effort (either a pot or a set of pots) used for catch sampling.
3. t_crayfish : contains details for individual rock lobsters.
4. t_bait_codes : contains a list of all bait codes and their meanings.

From these tables are a number of views.

• The red rock lobster catch sampling program uses the following views:
  
5. v_lob_sample : contains details of each sample undertaken including details such as vessel registration number, date, skipper, sampler's names, weather conditions, season, landed weight if available, and the number of red rock lobsters landed to a Licensed Fish Receiver (LFR).
6. v_cra_catch : contains details for each pot lifted during the sample. It includes the pot type, soak time, bait, depth set, number of live and dead lobsters caught, and codes for escape gaps and season. The latter two identify any samples, which were carried out under conditions atypical of a catch sample.
7. v_cra_lf : contains measurements for individual red rock lobsters which are linked to a pot in t_cra_catch. It also contains measurements for any packhorse rock lobsters caught during the red rock lobster catch sampling.
   
   • The red rock lobster market sampling and morphometric sampling programs uses the following views:
     
8. v_morp_sample : contains details of each sample undertaken including details such as vessel registration number, date, skipper, and sampler's names.
9. v_cra_wt : contains red rock lobster morphometric data only, i.e., no effort (pot) information. Measurements may include carapace length, tail width, and/or weight.
   
• The packhorse rock lobster catch sampling program uses the following views:
  
10. v_phc_sample : contains details of each packhorse rock lobster sample undertaken including details such as vessel registration number, date, skipper, sampler's names, and weather conditions.
11. v_phc_catch : contains details for each unit effort during the sample including the number of packhorse rock lobsters caught, number of red rock lobsters caught, pot type, soak, bait used,depth and position of each unit effort. A unit effort is usually one pot lift but may be a set of many pot lifts.
12. v_phc_lf : contains measurements for individual packhorse rock lobsters.
    
    • The red rock lobster Minimum Legal Size tail width feasibility study uses the following views:
13. v_mls_sample : contains details of each sample taken during this program.
14. v_mls_data : contains measurements for individual red rock lobsters.
    
    • The red rock lobster tagging program uses the following view:
      
15. v_tag_sample : contains details of each tag sample undertaken. Tagged individual rock lobster details are stored in the t_releases table in the tag database.