4 Table Summaries
This database is broken down into a set of nine tables. The
following is a listing of these tables contained in the iki database:
1t_trip : contains relevant
information for a fishing trip from which fish where sampled.
t_trip_catch : contains details of
the total catch for a species for the entire catch.
t_effort : contains the effort
details from the unit of effort sampled; i.e., details for each
longline set, trawl, or danish seine.
t_page : stores the time frame
that covers the sampling, of fish for that page number of the
"LONGLINE FISH CHARACTERISATION RECORD" form.
t_fish : contains details of each
fish caught; includes the length and information on the status of
the fish such as alive, hook position, other wounding.
t_catch : contains details of
catches of species for an unit of effort, including quality grade
t_grade_code : lists the codes and
their descriptions for quality grades of fish. Used primarily for
the snapper iki fishery where fish are grade on quality upon
t_hook_shot : contains details
about the shots of longline sets used during the SNA9802 hook
t_hook_append : contains details
about experiments to determine the effects of longline hook
appendages on incidental mortality and catch rates of snapper.
Details recorded include the results for every hook used and every