5 recruit tables
The following are listings of the tables in the recruit database,
including attribute names, data types (and any range restrictions),
and comments.
5.1 Table 1: t_site
|
Comment:
|
Details of samples at recruitment survey sites.
|
|
|
|
|
|
|
Attributes
|
Data Type
|
Null?
|
Comment
|
|
id
|
integer
|
No
|
Sequential unique number to identify each sample.
|
|
site
|
character(3,1)
|
No
|
3 character code for survey site, refer t_site_codes.
|
|
samp_date
|
date(4)
|
.
|
Date of sample
|
|
time_of_day
|
integer
|
|
Time (24hr, NZST) of sample.
|
|
high_tide
|
integer
|
|
Time (24hr, NZST) of nearest high tide to the sample.
|
|
target_sp
|
character(3,1)
|
|
3 character code for target species, refer rdb:curr_spp.
|
|
no_target_sp
|
integer
|
|
Number of target species caught.
|
|
bycatch
|
character(40,1)
|
|
Description of any bycatch caught.
|
|
comments
|
character(100,1)
|
|
General comments about the sample.
|
|
Creator:
|
dba
|
|
|
|
Referential:
|
invalid site code (site) INSERT t_site_codes (site)
invalid target species (target_sp) INSERT rdb : curr_spp
(code)
|
|
Indices:
|
UNIQUE t_site_PK ON (id)
|
5.2 Table 2: t_site_codes
|
Comment:
|
Descriptions and NZMS 260 grid references for site codes.
|
|
|
|
|
|
|
Attributes
|
Data Type
|
Null?
|
Comment
|
|
site
|
character(3,1)
|
No
|
3 character code for survey site.
|
|
descrptn
|
character(30,1)
|
|
Description of site code.
|
|
map_sheet
|
character(4,1)
|
|
NZMS 260 map sheet number.
|
|
grid_ref
|
character(8,1)
|
|
NZMS 260 map sheet grid reference for the site.
|
|
region
|
character(20,1)
|
|
General geographic region.
|
|
Creator:
|
dba
|
|
|
|
Indices:
|
UNIQUE site_codes_pk ON (site)
|
5.3 Table 3: t_lgth
|
Comment:
|
Length frequency data from samples.
|
|
|
|
|
|
|
Attributes
|
Data Type
|
Null?
|
Comment
|
|
id
|
integer
|
No
|
Sequential unique number to identify each sample.
|
|
species
|
character(3,1)
|
No
|
3 character code for species, refer rdb:curr_spp.
|
|
measure_meth
|
character(1,1).
|
|
Code of method used to measure fish lengths, refer
rdb:t_fish_meas_codes
|
|
lgth
|
integer
|
|
Fish length (mm).
|
|
no_a
|
integer
|
|
Number of species at this length.
|
|
Creator:
|
dba
|
|
|
|
Referential:
|
invalid id (id) INSERT t_site (id) invalid species (species)
INSERT rdb : curr_spp (code)
invalid meas method (measure_meth) INSERT rdb :
t_fish_meas_codes (fish_meas_code)
|
|
Indices:
|
NORMAL (2, 15) LGTH_FK ON (id)
|