|
|
5 kina Tables
The following are listings of the tables in the kina database,
including attribute names, data types (and any range restrictions),
and comments.
5.1 Table 1: t_catch_site
|
Comment:
|
Catch and effort information by grid reference for each diver
for each participant per fishing day.
|
|
Attributes
|
Data Type
|
Null?
|
Comment
|
|
participant
|
character(30,1)
|
No
|
Name of the participating fisher.
|
|
fishing_date
|
date(5)
|
No
|
Date the fishing took place.
|
|
divers_name
|
character(50,1)
|
No
|
Name of the diver.
|
|
fma
|
character(5,1)
|
No
|
Kina fishery management area code.
|
|
site_no
|
smallint
|
No
|
A sequential number for each different site dived on for the
days catch.
|
|
site_catch_wt
|
integer
|
|
Total catch weight (kg) of kina for a site.
|
|
site_time_diving
|
decimal(4,2)
|
|
Total time (hours) spent diving for the catch at the site.
|
|
latitude
|
decimal(5,1)
|
|
Latitude (DDMM.m format) of the dive site.
|
|
longitude
|
decimal(6,1)
|
|
Longitude (DDDMM.m format) of the dive site.
|
|
grid_ref
|
character(3,1)
|
|
3 character grid reference, to link to any sample in t_sample.
|
|
site_name
|
character(20,1)
|
|
General diving site, i.e., common name of the given latitude
and longitude.
|
|
stratum
|
smallint
|
|
Marine Research stratum number from which the catch was taken
from.
|
|
|
Range 1 to 6
|
|
|
|
Creator:
|
dba
|
|
|
|
Indices:
|
UNIQUE catch_site_key ON (participant, fishing_date,
divers_name, site_no)
NORMAL (2, 15) ON (grid_ref)
NORMAL (2, 15) ON (stratum)
|
5.2 Table 2: t_sample
|
Comment:
|
Details of each sample collected by both the SOP catch
sampling and the Marine Research sampling programme.
|
|
Attributes
|
Data Type
|
Null?
|
Comment
|
|
sample_no
|
character(8,1)
|
No
|
8 character unique identifier for each sample.
|
|
participant
|
character(30,1)
|
No
|
Name of the participating fisher.
|
|
fishing_date
|
date(5)
|
No
|
Date the fishing took place.
|
|
observer
|
character(20,1)
|
|
Observer's name.
|
|
divers_names
|
character(50,1)
|
|
Name(s) of the diver(s) who caught the sample.
|
|
grid_ref
|
character(3,1)
|
|
3 character grid reference for the location where the kina was
caught.
|
|
percent_samp
|
decimal(4,1)
|
|
Percentage of the whole catch that was sampled.
|
|
|
Range 0.1 to 100.0
|
|
|
|
stratum
|
smallint
|
|
Numeric code for the geographic division of the study area.
|
|
|
Range 1 to 8
|
|
|
|
site_no
|
smallint
|
|
A randomly selected study location from where kina were
sampled, for Research samples only.
|
|
comments
|
text(240,240,240,1)
|
|
Any comments about the sample.
|
|
Creator:
|
dba
|
|
|
|
Indices:
|
UNIQUE sample_key ON (sample_no)
NORMAL (2, 15) ON (participant)
NORMAL (2, 15) ON (grid_ref)
NORMAL (2, 15) ON (stratum)
|
5.3 Table 3: t_test_dia
|
Comment:
|
Test diameter frequency data for a sample.
|
|
Attributes
|
Data Type
|
Null?
|
Comment
|
|
sample_no
|
character(8,1)
|
No
|
8 character unique identifier for each sample.
|
|
test_dia
|
integer
|
No
|
Diameter class (mm) of the kina test.
|
|
no_t
|
integer
|
No
|
Total number of kina in the diameter class.
|
|
Creator:
|
dba
|
|
|
|
Referential:
|
Sample no. not in t_sample (sample_no) INSERT t_sample
(sample_no)
|
|
Indices:
|
UNIQUE freq_key ON (sample_no, test_dia)
|
5.4 Table 4: t_biological
|
Comment:
|
Kina biological data for a sub-sample of the test diameter
sample.
|
|
Attributes
|
Data Type
|
Null?
|
Comment
|
|
sample_no
|
character(8,1)
|
No
|
8 character unique identifier for each sample.
|
|
fish_no
|
smallint
|
No
|
A sequential number for each fish sampled.
|
|
whole_weight
|
integer
|
|
Whole weight (gm) of the kina.
|
|
test_diameter
|
integer
|
|
Diameter (mm) of the kina test.
|
|
gonad_volume
|
integer
|
|
Volume (ml) of the kina gonad.
|
|
gonad_colour
|
decimal(2,1)
|
|
Decimal colour code for the kina gonad.
|
|
|
Range 1.0 to 5.0
|
|
|
|
|
match "*.[05]"
|
|
|
|
Creator:
|
dba
|
|
|
|
Referential:
|
Sample no. not in t_sample (sample_no) INSERT t_sample
(sample_no)
|
|
Indices:
|
UNIQUE biol_key ON (sample_no, fish_no)
|
5.5 Table 5: t_grid_ref
|
Comment:
|
Comments for all possible grid references. An entry in the
comment field means that any dive sites referencing this grid are
in error.
The comment attribute is therefore the error message.
|
|
Attributes
|
Data Type
|
Null?
|
Comment
|
|
grid_ref
|
character(3,1)
|
No
|
3 character grid reference.
|
|
stratum
|
smallint
|
|
Marine Research stratum number which the grid reference is in.
|
|
comments
|
text(60,60,60,1)
|
|
Null if the grid reference is valid, else this field is an
error message.
|
|
Creator:
|
dba
|
|
|
|
Indices:
|
UNIQUE grid_key ON (grid_ref) NORMAL (2, 15) ON (stratum)
|
|