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:

1. 1t_trip : contains relevant information for a fishing trip from which fish where sampled.

2. t_trip_catch : contains details of the total catch for a species for the entire catch.

3. t_effort : contains the effort details from the unit of effort sampled; i.e., details for each longline set, trawl, or danish seine.

4. t_page : stores the time frame that covers the sampling, of fish for that page number of the "LONGLINE FISH CHARACTERISATION RECORD" form.

5. 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.

6. t_catch : contains details of catches of species for an unit of effort, including quality grade and greenweight.

7. 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 catching

8. t_hook_shot : contains details about the shots of longline sets used during the SNA9802 hook appendage experiment.

9. 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 fish caught.