4 Table Summaries

This database has nine tables containing information pertaining to research plankton surveys. The following is a listing of the tables contained in the plankton database:

  1. t_trip : contains profile information on all trips.

  2. t_trip_comm : contains comments for a particular trip.

  3. t_stratum : contains details of strata surveyed for a trip.

  4. t_station : contains data on location, gear used and environment at each station within a trip.

  5. t_stat_comm : contains comments for a station in a trip.

  6. t_wire_angle : contains wire angles (from the vertical) during gear retrieval.

  7. t_gear_units : contains mesh sizes, warp lengths and other details when more than one unit of gear is used during a station.

  8. t_eggs : contains stage frequency data for samples of eggs caught at each station on a trip.

  9. t_abund : contains total abundance of different species from samples taken from the catch of a plankton net.


Updated : 16 November 2007