4 Table summaries

This database is arranged as a set of eleven main tables, two views of species-specific data, and a further two views for codes.

The following is a listing and brief outline of the tables contained within rocklob pertaining to pueruli settlement:

1. t_locations : contains the full name of each location code and the method of puerulus collector deployment.
2. t_catch : contains details for each puerulus collector check, including location code, date, and numbers of pueruli caught.
3. t_puer_lfreq : contains carapace length data for puerulus caught by collectors during a check.
4. t_puer_stage : contains life history stage data for individual pueruli caught by collectors during a check.

The following is a listing and brief outline of the tables contained within rocklob pertaining to phyllosoma trawl surveys:

5. t_trip : contains profile information on all trips.
6. t_station : contains data on location, gear used and environment at each station within a trip.
7. t_stat_comm : contains comments for a station in a trip.
8. t_phy_stage : contains codes for levels of life history development for individual phyllosoma.
   1. _scyllarus : a view of the t_phy_stage table containing all scyllarus (SHL) phyllosoma life history stage data.
   2. v_jasus : a view of the t_phy_stage table containing all Jasus sp. phyllosoma (PHY) life history stage data.
      
9. t_evpsumm : contains start and finish times and positions, and station numbers contained in, envelopes of DAS data.
10. t_dasdata : contains filtered data from the vessel’s sensors collected in DAS envelopes
11. t_stage_codes : contains crayfish development stage codes and their descriptions, from phyllosoma larvae to juveniles.
    1. v_puer_stage_codes : contains puerulus development stage codes and their descriptions.
    2. v_phy_stage_codes: contains phyllosoma development stage codes and their descriptions.