4 Table Summaries

The following is a listing of the tables contained in the kina database:

  1. t_catch_site : contains catch (site location, kilograms landed, dive time, etc.) information for each grid reference fished by a diver for one participant for a day.

  2. t_sample : contains details for a sample of kina made by either the SOP or Research, e.g., when the sample was collected, and who by?

  3. t_test_dia : contains test diameter frequency data from a sample.

  4. t_biological : contains further biological information on a sub-sample of twenty five kina, e.g., whole weight, test diameter, gonad volume and colour.

  5. t_grid_ref : contains all possible grid references and comments about them. A null comment means that the grid reference is a valid one; else the comment is an error message.
    Allows comparisons between the SOP grid references and the Research stratum.


Updated : 16 November 2007